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

the npv of the book , Bill Clinton reportedly was paid $10 million to writ...

Bill Clinton reportedly was paid $10 million to write his book My Way. The book took three years to write. In the time he spent writing, Clinton could have been paid to make speech

Binomial and continuous model, Exercise: (Binomial and Continuous Model.) C...

Exercise: (Binomial and Continuous Model.) Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d =  0:0562, S0 = 100, T = 1, 4t = 1=12. Note that u

Level process control lab, Based on the following graphs (next page) you sh...

Based on the following graphs (next page) you should write a discussion report (2 pages) on: 1. Determination of whether the open-loop system response is consistent with a 1st o

Index Number of formulae, discuss the mathematical test of adequacy of inde...

discuss the mathematical test of adequacy of index number of formulae. prove algebraically that the laspeyre, paasche and fisher price index formulae satisfies this test. What is

Decision theory, 1. Definition of decision tree, 2. Feature of decision the...

1. Definition of decision tree, 2. Feature of decision theory problem

Deviation measures, Deviation Measures The drawback of the range as a m...

Deviation Measures The drawback of the range as a measure of dispersion is that it takes into account the values of only two data points - the largest and the smallest. One

Frailty in multi state models, how can i use continuous frailty in multi st...

how can i use continuous frailty in multi state models?

Small sample test for mean, If the sample size is less than 30, then we nee...

If the sample size is less than 30, then we need to make the assumption that X (the volume of liquid in any cup) is normally distributed. This forces    (the mean volume in the sam

Explain graph theory, For each of the following scenarios, explain how grap...

For each of the following scenarios, explain how graph theory could be used to model the problem described and what a solution to the problem corresponds to in your graph model.

Quantitative Business Analysis, Motion Picture Industry (95 Points) The m...

Motion Picture Industry (95 Points) The motion picture industry is a competitive business. More than 50 studios produce a total of 300 to 400 new motion pictures each year, and t

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