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

Caveat, Caveat We must be careful when interpreting the meaning of asso...

Caveat We must be careful when interpreting the meaning of association. Although two variables may be associated, this association does not imply that variation in the independ

Iterative convergence of the method, You are given the differential equatio...

You are given the differential equation dy/dx = y' = f(x, y) with initial condition y(0 ) 1 = . The following numerical method is also given: where  f n = f( x n , y n )

business forecasting, Explain the characteristics of business forecasting

Explain the characteristics of business forecasting.

Sampling error , Sampling Error  It is the difference between the value...

Sampling Error  It is the difference between the value of the actual population parameter and the sample statistic. Samples are used to arrive at conclusions regarding the p

Distribution of sample means, 1. Use the concepts of sampling error and z-s...

1. Use the concepts of sampling error and z-scores to explain the concept of distribution of sample means. 2. Describe the distribution of sample means shape for samples of n=36

Find the conditional distribution of turning diameter, 1. Assume the random...

1. Assume the random vector (Trunk Space, Length, Turning diameter) of Japanese car is normally distributed and the unbiased estimators for its mean and variance are the truth. For

Determine the maximum process variability, You are going to purchase a part...

You are going to purchase a part from a specialty vendor.  Your company needs a C p of at least 1.67 on a critical dimension of the part.  The dimensional specification for this p

Hydraulic actuator design matrix, The range of actuator design parameters h...

The range of actuator design parameters have been provisionally assessed and are presented in Table (3). You are required to determine the following parameters: The circumfer

Multiple regressions, A sample of 43 houses that were purchased in the Sout...

A sample of 43 houses that were purchased in the Southern California town Monrovia within a month was collected. We are interested in the study of the relationships between Price a

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