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

Which average is to be used to describe statistical data?, There ar...

There are situations where none of the three averages is fully satisfactory. For example, if the number of items in a series is very small, none of these av

Initial centroids data set, Find unlabeled data set test.txt and initial ...

Find unlabeled data set test.txt and initial centroids data set centroids.txt in the archive, both files have the following format: [attribute1_value attribute2_value ...

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

Evaluate the p - value, Use the given information to find the P-value. T...

Use the given information to find the P-value. The test statistic in a two-tailed test is z = 1.49 P-value = (round to four decimal places as needed)

Keno, Having 11 numbered balls -0 to 10 -into a basket and have 6 spaces t...

Having 11 numbered balls -0 to 10 -into a basket and have 6 spaces to be numbered with the balls selected in each 6 chances and it returned it back to the basket each time. Chanc

Graphical calculation for mode, For calculating the mode of the grouped dat...

For calculating the mode of the grouped data graphically, the following procedure is adopted. Draw a histogram of the data; the modal class is the tallest rectangle.

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

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