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

Factor analysis, Factor analysis (FA) explains variability among observed r...

Factor analysis (FA) explains variability among observed random variables in terms of fewer unobserved random variables called factors. The observed variables are expressed in

Standard deviation and variance, Explanation of standard deviation and vari...

Explanation of standard deviation and variance Describe the importance of standard deviation and variance, what they calculate and why they are required. Importance of char

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

Calculate the current ratio and quick ratio, You were recently hired by E&T...

You were recently hired by E&T Boats, Inc. to assist the company with its financial planning and to evaluate the company's performance.  E&T Boats, Inc. builds and sells boats to o

Regression lines, Regression Lines It has already been discussed that t...

Regression Lines It has already been discussed that there are two regression lines and they show mutual relationship between two variable . The regression line Yon X gives   th

Coefficient of determination, Coefficient of Determination The c...

Coefficient of Determination The coefficient of determination is given by r 2 i.e., the square of the correlation coefficient. It explains to what extent the variation

Correlation - cause and effect, Cause and Effect Even a highly signifi...

Cause and Effect Even a highly significant correlation does not necessarily mean that a cause and effect relationship exists between the two variables. Thus, correlation does

Practice-Based Evidence, how to analyzePractice-Based Evidence Back to the ...

how to analyzePractice-Based Evidence Back to the Future

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

Evaluate the probability, "MagTek" electronics has developed a smart phone ...

"MagTek" electronics has developed a smart phone that does things that no other phone yetreleased into the market-place will do. The marketing department is planning to demonstrate

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