Compute a correlation coefficient, Applied Statistics

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

Posted Date: 3/11/2013 6:03:59 AM | Location : United States







Related Discussions:- Compute a correlation coefficient, Assignment Help, Ask Question on Compute a correlation coefficient, Get Answer, Expert's Help, Compute a correlation coefficient Discussions

Write discussion on Compute a correlation coefficient
Your posts are moderated
Related Questions
what are the challenges affecting population census in developing countries

The calculations of arithmetic mean may be simple and foolproof, but the application of the result may not be so foolproof. An arithmetic mean may not merely lack

construction of control chart,n chart

Difference between Correlation and Regression Analysis 1. Degree and Nature  of Relationship: Coefficient of correlation measures   the degree  of covariance  between two vari

how can we graph a trend line by semiaverages and least square method?

A consumer preference study involving three different bottle designs (A, B, and C) for the jumbo size of a new liquid detergent was carried out using a randomized block experimenta

Is the random vector (Trunk Space, Length, Turning diameter) of US car normally distributed? Why? If yes, find the unbiased estimators for the mean and variance matrix of (Trunk Sp

A rightist incumbent (player I) and a leftist challenger (player C) run for senate. Each candidate chooses among two possible political platforms: Left or Right. The rules of the g

Meaning of Interpolation and Extrapolation Interpolation is a method of estimating the most probable  missing figure on  the basis of given data under certain assumptions. On t

what do we mean by critical region