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

Significance of correlation, Significance of Correlation The study of c...

Significance of Correlation The study of correlation is of immense use in practical life. Correlation analysis contributes to the understanding of economic behavior, aids in lo

#title. .explanatory factor analysis, how to compute reliability coefficien...

how to compute reliability coefficient for extracted factors in factor analysis?

Research tool, what are the characteristics of research tool?

what are the characteristics of research tool?

Evaluate central tendency and variability, Why are graphs and tables useful...

Why are graphs and tables useful when examining data? A researcher is comparing two middle school 7th grade classes. One class at one school has participated in an arts program

Canonical correlation analysis, Canonical correlation analysis (CC) allows ...

Canonical correlation analysis (CC) allows the investigation of the relationship between two ,sets of variables. For example, a sociologist may want to investigate the Relationship

Null and alternative hypothesis, 1) Suppose you want to test a hypothesis t...

1) Suppose you want to test a hypothesis that two treatments, A and B, are equivalent against the alternative that the response for A tend to be larger than those of B. You plan to

Optimal number of cluster, Try different numbers of clusters in your progra...

Try different numbers of clusters in your program (K=2...15) and build a plot that shows the dependency between number K and value of RSS function on the last iteration. What is th

business forecasting, Explain the characteristics of business forecasting

Explain the characteristics of business forecasting.

Test for equality of proportions, Test for Equality of Proportions For...

Test for Equality of Proportions For example, we may want to test whether the percentage of smokers (p 1 ) among the males equals the percentage of female smokers (p 2 ). W

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