Compute a correlation coefficient, Applied Statistics

Assignment Help:

A researcher was interested lowering the high school dropout level in his county. He measured the reading level of students entering middle school (based on a standard test) and their academic performance at the end of 10th grade (as measured by overall GPA).

Use the following data to:

A. Compute a correlation coefficient using Excel.

B. Create a scatterplot using Excel.

C. Determine the coefficient of determination. Explain what it tells you.

D. Explain in words what the correlation coefficient tells you about the relationship between reading level when entering middle school and 10th grade academic performance as measured by GPA.

E. What does it not tell you?

Student Reading Level Score GPA

1 100 3.0

2 110 2.95

3 80 2.00

4 75 2.10

5 91 2.00

6 124 3.80

7 95 2.40

8 82 3.00

9 104 3.10

10 95 2.20

11 88 2.24

12 95 3.00

13 107 3.45

14 112 3.11


Related Discussions:- Compute a correlation coefficient

Calculate the seasonal indexes , The total number of overtime hours (in 100...

The total number of overtime hours (in 1000s) worked in a large steel mill was recorded for 16 quarters, as shown below. Year Quarter Overtime hour

Heteroskedastic-consistent standard errors, The following table shows the r...

The following table shows the results of fitting a linear regression model of starting annual salaries on a constant, GPA (4 point scale), and a variable (Metrics =1) indicating wh

Factor analysis, Factor analysis (FA) explains variability among observed r...

Factor analysis (FA) explains variability among observed random variables in terms of fewer unobserved random variables called factors. The observed variables are expressed in

Test for equality of proportions, Test for Equality of Proportions For...

Test for Equality of Proportions For example, we may want to test whether the percentage of smokers (p 1 ) among the males equals the percentage of female smokers (p 2 ). W

Analysis of variance (anova), Analysis of variance allows us to test whethe...

Analysis of variance allows us to test whether the differences among more than two sample means are significant or not. This technique overcomes the drawback of the method used in

Statistical procedures - estimation of a mean, Old Faithful Geyser in Yello...

Old Faithful Geyser in Yellowstone National Park derives its names and fame from the regularity (and beauty) of its eruptions. Rangers usually post the predicted times of eruptions

Calculate unbiased estimate of the variance, This question has two parts wi...

This question has two parts with multiple items to answer. You are a psychologist who has collected the subjective well-being scores of a number of elderly people aged 90 or abo

Regression model, Using a random sample of 670 individuals for the populati...

Using a random sample of 670 individuals for the population of people in the workforce in 1976, we want to estimate the impact of education on wages. Let wage denote hourly wage in

Linear regression mode, The State Department of Taxation wishes to investig...

The State Department of Taxation wishes to investigate the effect of experience, x, on the amount of time, y, required to fill out Form ST 1040AVG, the state income-averaging form.

Time series, what is the use of applied statistic in our daily routin life

what is the use of applied statistic in our daily routin life

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd