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 would be the cutoff score to indicate a score that is in the top 15% of the scores on a test with a mean of 100 and a standard deviation of 15? This question has multiple p

Assume that the normal distribution applies and find the critical z value(s). A = 0.04; H1 is mean ≠ 98.6 degrees Fahrenheit. Dteremine the value of Z. Find the value of the

What is an example of a real life situation when I would use each of these test

#In planning the teaching assignments for next semester, Mr. Hinton must have a teacher in each of the 7 grades during each of the 6 periods of the day. If he has 10 teachers to ch

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 ).

The following dataset is from a study of the effects of second hand smoking in Baltimore, MD, and Washington, DC. For the 25 children involved in this study the outcome variable is

The weight of the engine in kN is given in P2 and is suspended from a vertical chain at A. A second chain round the engine is attached at A, with a spreader bar between B and C. Th

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

1. For each of the following variables: major, graduate GPA, and height: a. Determine whether the variable is categorical or numerical. b. If the variable is numerical, deter

Suppose the money supply process is now represented by the following function: where m measures the sensitivity of money supply with respect to the interest rate. (i) Us