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

LPP, b. A paper mill produces two grades of paper viz., X and Y. Because of...

b. A paper mill produces two grades of paper viz., X and Y. Because of raw material restrictions, it cannot produce more than 400 tons of grade X paper and 300 tons of grade Y

Determine the maximum weight rounded down, Assume that the pulley at A is a...

Assume that the pulley at A is a small frictionless pulley. The cord AB is only allowed to support a maximum tension in Newtons as given in P4, and the cord supporting the block ca

Spatial ability test, What would be the cutoff score to indicate a score th...

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

Cluster analysis, These techniques are applied when the rows and the column...

These techniques are applied when the rows and the columns of the data table represent the same units and when the measure is a disiance or a similarity. The goal of the analysis i

Evaluate minimum capability requirement, You are currently working wit...

You are currently working with a supplier who is producing a shaft whose diameter specification is 6.00 ± .003 inches.  Currently, the process is yielding shafts wit

Bernoulli''s theorem, Bernoulli's Theorem If a trial of an experiment c...

Bernoulli's Theorem If a trial of an experiment can result in success  with probability p and failure with probability q (i.e.1-p) the probability of exactly r success in n tri

Exam, I need to know if the exam will be guarantee to pull my grade up to a...

I need to know if the exam will be guarantee to pull my grade up to a B or an A. I have a D right now so i need to get someone that is willing to put effort on completing it???

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

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