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

WEDGE FRICTION, Ask question #MinimumA wedge is small piece of material hav...

Ask question #MinimumA wedge is small piece of material having two of their opposite faces not parallel. To lift block of weight W, it is pushed by horizontal force P which lifts t

Multiple correspondence analysis, Correspondence Analysis (CA) is a general...

Correspondence Analysis (CA) is a generalization of PCA to contingency tables. The factors of correspondence analysis give an orthogonal decomposi:ion of the Chi- square associated

Probability theory, Origin and Development of probability Theory: The c...

Origin and Development of probability Theory: The credit for origin and development of probability goes to the European gamblers of 17 th century. They  used to gamble  on gam

Local truncation error, (a) If one solves the ordinary differential equati...

(a) If one solves the ordinary differential equation using Euler's method find an expression for the local truncation error. (b) Using the result of (a) above what will

Find the optimal order quantity, The Maju Supermarket stocks Munchies Cerea...

The Maju Supermarket stocks Munchies Cereal. Demand for Munchies is 4,000 boxes per year and the super market is open throughout the year. Each box costs $4 and it costs the store

How many possible latin square designs are there, In an agricultural experi...

In an agricultural experiment, we wish to compare the yields of three different varieties of wheat. Call these varieties A, B and C. We have a ?eld that has been marked into a 3 *

Enumerate the set, Grid is the set of pairs {1, 2, 3, 4} x {1, 2, 3, 4}. ...

Grid is the set of pairs {1, 2, 3, 4} x {1, 2, 3, 4}. Image is the power set of Grid. An element of Image is a subset of Grid and can be represented by a diagram on a 4 by 4

Trying to find test statistic and P value, Ask question #Minimum The data i...

Ask question #Minimum The data in the accompanying table give the weights? (in g) of randomly selected quarters that were minted after 1964. The quarters are supposed to have a med

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