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

Advantages of sampling, Advantages of Sampling Why should we settle on ...

Advantages of Sampling Why should we settle on a sample instead of studying the entire population?  Sampling has the following advantages over a census (study of the entire pop

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

Expected utility maximizer, The investor has constant wealth 1 and is o?ere...

The investor has constant wealth 1 and is o?ered to invest in shares of a project that either gains 3=2 or loses 1 with equal probabilities. Therefore, if the investor obtains sha

ANOVA, Your company operates a machine shop, and, having heard you had expe...

Your company operates a machine shop, and, having heard you had experience in statistics and design of experiments, consulted you for your opinion on an experiment they want to run

Probability distribution and sampling distribution , a 100 squash balls are...

a 100 squash balls are bounce from height of 100 inches with average height 30 inch with standard deviation 3/4 inch. a ball is fast if bounce above 32 inch. what is chance of gett

Determine probability that the person tested has the disease, There are two...

There are two diagnostic tests for a disease. Among those who have the disease, 10% give negative results on the first test, and independently of this, 5% give negative results on

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

Problem set for logistic regression, (1) What values can the response varia...

(1) What values can the response variable Y take in logistic regression, and hence what statistical distribution does Y follow? The response variable can take the value of either

Explain graph theory, For each of the following scenarios, explain how grap...

For each of the following scenarios, explain how graph theory could be used to model the problem described and what a solution to the problem corresponds to in your graph model.

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