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

Displacement of a simply supported beam, The displacement of a simply suppo...

The displacement of a simply supported beam subject to a uniform load is given by the solution of the following differential equation (for small displacements); and q is th

Accident proneness, Accident proneness  A personal psychological issue w...

Accident proneness  A personal psychological issue which affects the individual's probability of suffering the accident. The concept has been studied statistically under the num

Inverse cumulative distribution function, The Null Hypothesis - H0: β0 = ...

The Null Hypothesis - H0: β0 = 0, H0: β 1 = 0, H0: β 2 = 0, Β i = 0 The Alternative Hypothesis - H1: β0 ≠ 0, H0: β 1 ≠ 0, H0: β 2 ≠ 0, Β i ≠ 0      i =0, 1, 2, 3

Main effects and interactions, what is the independent variable in how ener...

what is the independent variable in how energetic do people feel after drinking different types of soft drints?

mathematical anxiety, A study was designed to investigate the effects of t...

A study was designed to investigate the effects of two variables - (1) a student's level of mathematical anxiety and (2) teaching method - on a student's achievement in a mathemati

Data project, Choose any published database from the internet or Bethel lib...

Choose any published database from the internet or Bethel library (such as those from the Census Bureau or any financial sites). You may opt to use one of the data files provided b

Evaluate gross reproduction rate, Evaluate Gross Reproduction Rate: Fr...

Evaluate Gross Reproduction Rate: From the data given below compute : i)   General  Fertility  Rate ii)  Specific  Fertility  Rate iii)  Total  Fertility  Rate iv)

Use of calculators in statistics, In recent years a number of calculators a...

In recent years a number of calculators are available for doing statistical calculations over and above the usual addition, subtraction, multiplication and division. The fx-82 mode

Statistical procedures - estimation of a mean, Old Faithful Geyser in Yello...

Old Faithful Geyser in Yellowstone National Park derives its names and fame from the regularity (and beauty) of its eruptions. Rangers usually post the predicted times of eruptions

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