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

Calculate the frequency distribution, The Neatee Eatee Hamburger Joint spec...

The Neatee Eatee Hamburger Joint specializes in soyabean burgers. Customers arrive according to the following inter - arrival times between 11.00 am and 2.00 pm: Interval-arrival

Sequential sampling, Sequential Sampling Under this method, a number of...

Sequential Sampling Under this method, a number of sample lots are drawn one after another from a universe depending on the results of the earlier samples. Such sampling is gen

Sampling theory, difference between large sample test and small sample test...

difference between large sample test and small sample test

Correlation, Correlation The correlation is commonly used and a useful...

Correlation The correlation is commonly used and a useful statistic used to describe the degree of the relationships between two or more variables. Pearson's correlation refle

Linear regression mode, The State Department of Taxation wishes to investig...

The State Department of Taxation wishes to investigate the effect of experience, x, on the amount of time, y, required to fill out Form ST 1040AVG, the state income-averaging form.

Simple linear regression, For each of the following situations choose the s...

For each of the following situations choose the statistical model that you find to be the most appropriate. Justify your choice. a) We are interested in assessing the effects of

Statistics, Theories of Business forecasting

Theories of Business forecasting

Collaboration policy,  Each question, by default, should be solved INDIVID...

 Each question, by default, should be solved INDIVIDUALLY, unless marked as \collaborative". Questions marked as \collaborative" implies that for those questions you are encourage

Weight distribution, What does the confidence level of a confidence interva...

What does the confidence level of a confidence interval tell you? Suppose that a population has mean, µ, and standard deviation, σ.  What does the central limit theorem tell us

Regression analysis, Of the 6,325 kindergarten students who participated in...

Of the 6,325 kindergarten students who participated in the study, almost half or 3,052 were eligible for a free lunch program. The categorical variable sesk (1 == free lunch, 2 = n

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