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

Conduct a hypothesis testing, Celia is a nurse in a geriatric ward.  She no...

Celia is a nurse in a geriatric ward.  She noticed that older persons in her care are having problems sleeping at night.  She decided to introduce non-pharmocologic ways of relaxat

Calculate the normal loss and abnormal loss, Chemical processors manufactur...

Chemical processors manufacture wondercool using two processes- mixing and distillation. The following details relate to the distillation process for a period. No opening work i

Corelation regrassion, the two regrassion line will pass through the point ...

the two regrassion line will pass through the point (x,y)

Probability, 1 A penny is tossed 5 times. a. Find the chance that the 5th t...

1 A penny is tossed 5 times. a. Find the chance that the 5th toss is a head b. Find the chance that the 5th toss is a head, given the first 4 are tails.

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

Mean deviation, First Moment of Dispersion or Mean Deviation Mean devia...

First Moment of Dispersion or Mean Deviation Mean deviation or the average deviation is the measure if dispersion which   is based upon all the items in a variable .It is the a

Sample, types of sampling method

types of sampling method

Explain survey development process, Problem: A survey usually originate...

Problem: A survey usually originates when an individual or an institution is confronted with an information need and the existing data are  insufficient. Planning the questionn

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

Regression analysis, Meaning and Definitions of Regression The dictiona...

Meaning and Definitions of Regression The dictionary meaning of regression is just opposite the meaning of progression. Progression means to move forward while regression means

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