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

Measures of dispersion, Measures of Dispersion ...

Measures of Dispersion Box 3: Food vs. Oil Below are the figures for foodgrain procurement   and cr

Importance and application of probability, Importance and Application of pr...

Importance and Application of probability: Importance of probability theory  is in all those areas where event are not  certain to take place as same  as starting with games of

Statistical quality control assinment, how to get statistical quality contr...

how to get statistical quality control assignment in brief?

Probability, HOW WOULD YOU INTERPRET THIS PROBABILITY:P(a)=1.05

HOW WOULD YOU INTERPRET THIS PROBABILITY:P(a)=1.05

What are the hypotheses, Assume that a simple random sample has been select...

Assume that a simple random sample has been selected from a normally distribute population and test the given claim. Identify the null and alternative hypotheses, test statistic,

Che, Chebychev inequality

Chebychev inequality

Correlation coefficient test, 1. If you are calculating a correlation coeff...

1. If you are calculating a correlation coefficient testing the relationship between height and weight, state the null and alternative hypotheses. 2. What kind of relationship d

The cost of living index, The cost of living index number on a some data wa...

The cost of living index number on a some data was 200. From the base period, the percentage enhances in prices were-Rent Rs 60, clothing Rs 250, Fuel and Light Rs 150 and Miscella

Multivariate analysis of variance, Multivariate analysis of variance (MANOV...

Multivariate analysis of variance (MANOVA) is a technique to assess group differences across multiple metric dependent variables simultaneously, based on a set of categorical (non-

Estimate the standard deviation of the process, Estimate the standard devia...

Estimate the standard deviation of the process: Draw the X (bar) and R charts for the data given and give your comments about the process under study. Estimate the standard de

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