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

Simplex method, #questionMaximize Z= 3x1 + 2X2 Subject to the constraints: ...

#questionMaximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0..

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

Mean absolute deviation, Mean Absolute Deviation To avoid the problem o...

Mean Absolute Deviation To avoid the problem of positive and negative deviations canceling out each other, we can use the Mean Absolute Deviation which is given by

Time series, merits and demerits of methods to determin trends

merits and demerits of methods to determin trends

Active control equivalence studies (aces), Active Control Equivalence Studi...

Active Control Equivalence Studies (ACES) Clinical trials the field in which the object is easy to show that the new treatment is  as good as the existing treatment. Such type

Sequential sampling, Sequential Sampling Under this method, a number of...

Sequential Sampling Under this method, a number of sample lots are drawn one after another from a universe depending on the results of the earlier samples. Such sampling is gen

Applications of standard error, Applications of Standard Error   ...

Applications of Standard Error   Standard Error is used to test whether the difference between the sample statistic and the population parameter is significant or is d

Geometric mean, Geometric Mean is defined as the n th root of the ...

Geometric Mean is defined as the n th root of the product of numbers to be averaged. The geometric mean of numbers X 1 , X 2 , X 3 .....X n is given as

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