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

Simulation - analytical approach, Analytical Approach We will illustra...

Analytical Approach We will illustrate this through an example. Example 1 A firm sells a product in a market with a few competitors. The average price charged by the

Determine the regression equation, The file Midterm  Data.xls has a tab lab...

The file Midterm  Data.xls has a tab labeled "National Grid vs. Alcoa" which presents historical price data for two stocks.  Using the National Grid price as the X-value and the Al

Aviation legislation - SUPPLEMENTAL TYPE CERTIFICATION, JAR 21 SUPPLEMENTAL...

JAR 21 SUPPLEMENTAL TYPE CERTIFICATION JAR 21 Part E introduces the need for Supplemental Type Certification when a manufacturer wishes to make major changes to the Type Desig

Correlation coefficients, What type of correlation coefficient would you us...

What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A. Re

Calculation for discrete series or ungrouped data , Calculation for Discre...

Calculation for Discrete Series or Ungrouped Data The formula for computing mean is = where,          f  = fr

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.

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

Advantages of median, Advantages It is especially useful in c...

Advantages It is especially useful in case of open-end classes since only the position and not the values of items must be known. The median is also recommended if th

Measures of dispersion, Measures of Dispersion ...

Measures of Dispersion Box 3: Food vs. Oil Below are the figures for foodgrain procurement   and cr

Calculate the one year interest rate, A.The coupon rate of Erie-Chicago Rai...

A.The coupon rate of Erie-Chicago Rail is 7%. The interest rate of Florida municipal bond with equal risk is 6%.  At what tax rate the two bonds are as good as each other B.Supp

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