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

Econometrics, Ask question From the household budget survey of 1980 of the...

Ask question From the household budget survey of 1980 of the Dutch Central Bureau of Statistics, J. S. Cramer obtained the following logit model based on a sample of 2820 househol

Estimation error on apparent arbitrage, This question explores the effect o...

This question explores the effect of estimation error on apparent arbitrage opportunities in a controlled simulation setting. We simulate returns for N = 10 assets over T = 30 year

Weighted arithmetic mean, Weighted Arithmetic Mean Another aspect...

Weighted Arithmetic Mean Another aspect to be considered is the importance we assign to each observation. The arithmetic mean as we calculated it so far gives equal

Find the backward induction equilibrium, A rightist incumbent (player I) an...

A rightist incumbent (player I) and a leftist challenger (player C) run for senate. Each candidate chooses among two possible political platforms: Left or Right. The rules of the g

Find the optimal order quantity, The Maju Supermarket stocks Munchies Cerea...

The Maju Supermarket stocks Munchies Cereal. Demand for Munchies is 4,000 boxes per year and the super market is open throughout the year. Each box costs $4 and it costs the store

Geometric mean, Geometric Mean The geometric mean   of numbers is defin...

Geometric Mean The geometric mean   of numbers is defined as the th root of the product of numbers .It is obtained by multiplying all the values of a variable and then extracti

Measures of dispersion, Other Measures of Dispersion In this section, ...

Other Measures of Dispersion In this section, we look at relatively less used measures of dispersion like fractiles, deciles, percentiles, quartiles, interquartile range and f

Standard cost method, Under the standard cost method which is also referred...

Under the standard cost method which is also referred as the standard cost method ,stock receipts are assigned a standard cost. Any variations between the actual cost and standard

Calculate the damping ratio for each system, (i) Plot the step responses of...

(i) Plot the step responses of the following second order systems and state the nature of each system. For each case, find the poles and plot the location of the poles in the compl

Postneonatal mortality rate, Mid year population 440000 Late fatal death...

Mid year population 440000 Late fatal death          29 No. of live birth           5200 No. of infant death      423 No. of maternal death 89 No. of infant deaths i

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