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

QHA, Your employer, Quick Hit Agency (QHA), is a debt collections agency. T...

Your employer, Quick Hit Agency (QHA), is a debt collections agency. The company specializes in collecting small accounts. QHA does not deal in large accounts and does not take on

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

Cartogram or mapograph, Cartogram or Mapograph:   Statistical maps are a...

Cartogram or Mapograph:   Statistical maps are also used to represent data like density of population indifferent states in the country or different countries in the world or th

Correlation matrix table, A.    Do the correlation matrix table. B.    W...

A.    Do the correlation matrix table. B.    Which variable (s) has the largest correlation coeffieient which is not a perfect correlation? C.    Which variable (s) has the s

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-

Asymmetric proximity matrices, Asymmetric proximity matrices Immediacy...

Asymmetric proximity matrices Immediacy matrices in which the off-diagonal elements which are, in the i th row and j th column and the j th row and i th column, are not essent

Prediction interval, Prediction Inte rval We would like to construct a...

Prediction Inte rval We would like to construct a prediction interval around    which would contain the actual Y. If n  ≥  30,     ± Zs e  would be the interval, where Z

Arithmetic average or mean, Arithmetic Average or Mean The arithmetic m...

Arithmetic Average or Mean The arithmetic mean is the most widely and the most generally understandable of all the averages. This is clear from the reason that when the term

Different analyses of recurrent events data, Different analyses of recurren...

Different analyses of recurrent events data: The bladder cancer data listed in Wei, Lin, and Weissfeld (1989) is used in Example 54.8/49.8 of SAS to  illustrate different anal

Level process control lab, Based on the following graphs (next page) you sh...

Based on the following graphs (next page) you should write a discussion report (2 pages) on: 1. Determination of whether the open-loop system response is consistent with a 1st o

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