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

Multi stage or cluster random sampling, Multi stage or Cluster Random sampl...

Multi stage or Cluster Random sampling  Under this method, the random selection is made of primary, intermediate and final units from a given population. The area of investigat

Disadvantages of median, Disadvantages For calculating median it is ...

Disadvantages For calculating median it is necessary to arrange the data; other averages do not need any arrangement. Since it is a positional average, its value is not d

Harmonic mean, Harmonic Mean  The harmonic mean  also called harmonic  ...

Harmonic Mean  The harmonic mean  also called harmonic  average, in the total numbers of items of variable divided by the sum of r reciprocals of the values of the variable. In

Prediction, Differentiate between prediction, projection and forecasting.

Differentiate between prediction, projection and forecasting.

Appropriate statistical test, I would like to know what the appropriate sta...

I would like to know what the appropriate statistical test is for investigating an association between a nominal variable and an ordinal variable assuming normal distribution? It''

Types of correlation, Type of Correlation 1.      Positive and Negat...

Type of Correlation 1.      Positive and Negative Correlation: 2.      Simple Partial and Multiple Correlations. 3.      Linear and  Non linear or Correlations

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

Regression Analysis, Question 3 25 marks Your employer, Quick Hit Agency ...

Question 3 25 marks Your employer, Quick Hit Agency (QHA), is a debt collections agency. The company specializes in collecting small accounts. QHA does not deal in large accounts

Statistics, Theories of Business forecasting

Theories of Business forecasting

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