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

Determine the subset of variables, Agency revenues. An economic consultant ...

Agency revenues. An economic consultant was retained by a large employment agency in a metropolitan area to develop a regression model for predicting monthly agency revenues ( y ).

Lorenz curve , Lorenz Curve   It is a graphic method of measur...

Lorenz Curve   It is a graphic method of measuring dispersion. This curve was devised by Dr. Max o Lorenz a famous statistician.  He used this technique for wealth it i

Determine the optimal order size, The Truly Canadian Restaurant stocks a pr...

The Truly Canadian Restaurant stocks a private red table wine that it purchases from a local winery in the Niagara Falls region. The daily demand for the wine at the restaurant is

Index number, "index number is an economic barometer" comment on this state...

"index number is an economic barometer" comment on this statement

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

Standard cost method, Under the standard cost method which is also referred...

Under the standard cost method which is also referred as the standard cost method ,stock receipts are assigned a standard cost. Any variations between the actual cost and standard

Chi square test, who invented the chi square test and why? what is central ...

who invented the chi square test and why? what is central chi square and non central chi square test? what is distribution free statistics? what are the conditions when the chi squ

Advantages of mode, Advantages By definition, mode is the most typic...

Advantages By definition, mode is the most typical or representative value of a distribution. Hence, when we talk of modal wage, modal size of shoe or modal size of family i

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