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

Angle count method, Angle Count method The method for estimating the pr...

Angle Count method The method for estimating the proportion of the area of a forest which is in fact covered by the bases of trees. An observer goes to each of the number of po

Evaluate the standard deviation, Use only the rare event rule, and make sub...

Use only the rare event rule, and make subjective estimates to determine whether events are likely. For example, if the claim is that a coin favors heads and sample results consis

Analysis of covariance (ancova), Analysis of covariance (ANCOVA) It is ...

Analysis of covariance (ANCOVA) It is initially used for an expansion of the analysis of variance which permits to the possible effects of continuous concomitant variables (suc

Statistics, Theories of Business forecasting

Theories of Business forecasting

Descriptive statistics, find the average rate of increase in population whi...

find the average rate of increase in population which in the first decade has increased 20%.in the second 25% and in the third 44%

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???

Regression analysis , The data used is from a statistical software Minitab;...

The data used is from a statistical software Minitab; London.MPJ is the file that consists of 1519 households drawn from 1980 - 1982 British Family Expenditure Surveys. Data that i

Optimal number of cluster, Try different numbers of clusters in your progra...

Try different numbers of clusters in your program (K=2...15) and build a plot that shows the dependency between number K and value of RSS function on the last iteration. What is th

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