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

Chi-square analysis, Chi-square analysis can be used with both Goodness-of-...

Chi-square analysis can be used with both Goodness-of-Fit Tests and with Tests for Independence. There are specific instances when each test should be used based on the information

Applied, Question 1 Suppose that you have 150 observations on production (...

Question 1 Suppose that you have 150 observations on production (yt) and investment (it), and you have estimated the following ADL(3,2) model: (1 – 0.5L – 0.1L2 – 0.05L3)yt = 0.7

WEDGE FRICTION, Ask question #MinimumA wedge is small piece of material hav...

Ask question #MinimumA wedge is small piece of material having two of their opposite faces not parallel. To lift block of weight W, it is pushed by horizontal force P which lifts t

Central tendency, Definition of Central Tendency The central tendency o...

Definition of Central Tendency The central tendency of a variable means a typical value around which other values tend to concentrate which can be measured. Such concentration

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

Harmonic mean, Harmonic Mean  The harmonic mean  also called harmonic  ...

Harmonic Mean  The harmonic mean  also called harmonic  average, in the total numbers of items of variable divided by the sum of r reciprocals of the values of the variable. In

Uses of arithmetic mean, Uses Arithmetic mean is widely used beca...

Uses Arithmetic mean is widely used because of the following reasons: Mean is the simplest average to understand and easy to compute. It

Anova, how do you find if two way or one way

how do you find if two way or one way

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

Use of calculators in statistics, In recent years a number of calculators a...

In recent years a number of calculators are available for doing statistical calculations over and above the usual addition, subtraction, multiplication and division. The fx-82 mode

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