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

Standard gaussian random variable , You will recall the function pnorm() fr...

You will recall the function pnorm() from lectures. Using this, or otherwise, Dteremine the probability of a standard Gaussian random variable exceeding 1.3.  Using table(), or

Evaluate the probability, "MagTek" electronics has developed a smart phone ...

"MagTek" electronics has developed a smart phone that does things that no other phone yetreleased into the market-place will do. The marketing department is planning to demonstrate

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

Multiple regressions, A sample of 43 houses that were purchased in the Sout...

A sample of 43 houses that were purchased in the Southern California town Monrovia within a month was collected. We are interested in the study of the relationships between Price a

Weight distribution, What does the confidence level of a confidence interva...

What does the confidence level of a confidence interval tell you? Suppose that a population has mean, µ, and standard deviation, σ.  What does the central limit theorem tell us

Multi stage or cluster random sampling, Multi stage or Cluster Random sampl...

Multi stage or Cluster Random sampling  Under this method, the random selection is made of primary, intermediate and final units from a given population. The area of investigat

Write out the estimator of the linear combination, Now, let's look at a dif...

Now, let's look at a different linear combination. Suppose we are interested n comparing the average mean log income for no college education ( 16). 1. Write out the linear com

Standard deviation for grouped data, Grouped data  For ...

Grouped data  For grouped data, the formula applied is  σ = Where f = frequency of the variable, μ= population mea

Geometric mean, Geometric Mean The geometric mean   of numbers is defin...

Geometric Mean The geometric mean   of numbers is defined as the th root of the product of numbers .It is obtained by multiplying all the values of a variable and then extracti

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