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

Caveat, Caveat We must be careful when interpreting the meaning of asso...

Caveat We must be careful when interpreting the meaning of association. Although two variables may be associated, this association does not imply that variation in the independ

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

STATISTICS, Ask 3. Precision Manufacturing has a government contract to pro...

Ask 3. Precision Manufacturing has a government contract to produce stainless steel rods for use in military aircraft. Each rod is required to be 20 millimeters in diameter. Each

Admissibility, Admissibility A very common concept which is applicable ...

Admissibility A very common concept which is applicable to any procedure of the statistical inference. The underlying notion is that the procedure/method is admissible if and o

Inverse market demand, There are two types of drivers, high-risk drivers wi...

There are two types of drivers, high-risk drivers with an accident probability of 2=3 and low risk drivers with an accident probability of 1=3. In case of an accident the driver su

Level process control lab, Based on the following graphs (next page) you sh...

Based on the following graphs (next page) you should write a discussion report (2 pages) on: 1. Determination of whether the open-loop system response is consistent with a 1st o

Population variance, Examining the Population Variance Business decisio...

Examining the Population Variance Business decision making does not limit itself to setting up the hypothesis to test for the equality of more than two means or proportions sim

Estimation error on apparent arbitrage, This question explores the effect o...

This question explores the effect of estimation error on apparent arbitrage opportunities in a controlled simulation setting. We simulate returns for N = 10 assets over T = 30 year

Draw a network diagram for this problem, The project of building a backyard...

The project of building a backyard swimming pool consists of eight major activities and has to be completed within 19 weeks. The activities and related data are given in the follow

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