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

Cluster analysis, Cluster Analysis could be also represented more formally ...

Cluster Analysis could be also represented more formally as optimization procedure, which tries to minimize the Residual Sum of Squares objective function: where μ(ωk) - is a centr

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

Standard deviation , Standard Deviation  The concept of standard deviat...

Standard Deviation  The concept of standard deviation was first introduced by Karl Pearson in 1893. The standard deviation is the most important and the popular measure of disp

Chi square test for more than two rows, Using Chi Square Test when more tha...

Using Chi Square Test when more than two Rows are Present   To understand this, let us consider the contingency table shown below. It gives us the information about the stage

Harmonic mean, The Harmonic Mean is based on the reciprocals of numbers ave...

The Harmonic Mean is based on the reciprocals of numbers averaged. It is defined as the reciprocal of the arithmetic mean of the reciprocal of the given individual observations. Th

Perform a dimensional analysis for the quantities, Show how the Normal bin ...

Show how the Normal bin width rule can be modi ed if f is skewed or kurtotic. Examine the eff ect of bimodality. Compare your rules to Doane's (1976) extensions of Sturges' rule.

E-mail messages should be answered quickly, Do people of different age grou...

Do people of different age groups differ in their response to e-mail messages? A survey by the Cent of the Digital Future of the University of Southern California reported that 70.

Explain the central tendency, Explain what central tendency and variability...

Explain what central tendency and variability are. In your answer define what the mean, median, mode, variance, and standard deviation are. What is the difference between the descr

Statistical definition of probability, Statistical Definition of probabilit...

Statistical Definition of probability: Ques: (a) (i)  Distinguish Statistical Definition of probability from the Classical Definition.                  (ii) State the A

Median, introduction of median

introduction of median

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