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

Scatter diagram - correlation analysis, Scatter Diagram The first step ...

Scatter Diagram The first step in correlation analysis is to visualize the relationship. For each unit of observation in correlation analysis there is a pair of numerical value

Interpolation and extrapolation, Meaning of Interpolation and Extrapolation...

Meaning of Interpolation and Extrapolation Interpolation is a method of estimating the most probable  missing figure on  the basis of given data under certain assumptions. On t

B) Distinguish between:, X 110 120 130 120 140 135 155 160 165 155 ...

X 110 120 130 120 140 135 155 160 165 155 Y 12 18 20 15 25 30 35 20 25 10

Liner programming , Solve the following Linear Programming Problem using S...

Solve the following Linear Programming Problem using Simple method. Maximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0

Index number, give a elementary example for characterstics of index number

give a elementary example for characterstics of index number

Frequency distribution, mark number of student 0-10 4 10-20 8 ...

mark number of student 0-10 4 10-20 8 20-30 11 30-40 15 40-50 12 50-60 6 calculate frequency distribution

Probability function, Among the students doing a given course, there are fo...

Among the students doing a given course, there are four boys enrolled in the ordinary version of the course, six girls enrolled in the ordinary version of the course,and six boys e

Create the venn diagram, Create the Venn diagram: A   - you work for a...

Create the Venn diagram: A   - you work for an insurance company.  80% of your company's staff is sales force and 70% of your company's sales is force is male. in your company

Multivariate analysis of variance, Multivariate analysis of variance (MANOV...

Multivariate analysis of variance (MANOVA) is a technique to assess group differences across multiple metric dependent variables simultaneously, based on a set of categorical (non-

Comparison of the principal averages-mean, Comparison of the Principal Aver...

Comparison of the Principal Averages-Mean, Median and Mode The mean, median, and mode are located at the same point in a symmetrical frequency distri

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