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

X-bar charts, First we look at these charts assuming that we know both the ...

First we look at these charts assuming that we know both the mean and the standard deviation of the process, that is  μ and  σ . These values represent the acceptable values (bench

Time series, merits and demerits of methods to determin trends

merits and demerits of methods to determin trends

Vector of a company, Suppose both the Repair record 1978 and Company headqu...

Suppose both the Repair record 1978 and Company headquarters are believed to be significant in explaining the vector (Price, Mileage, Weight). Here, because of the limited sample s

Standard deviation and variance, Explanation of standard deviation and vari...

Explanation of standard deviation and variance Describe the importance of standard deviation and variance, what they calculate and why they are required. Importance of char

Diversity of data , The box plot displays the diversity of data for the tot...

The box plot displays the diversity of data for the totexp; the data ranges from 30 being the minimum value and 390 being the maximum value. The box plot is positively skewed at 1.

Universe or population, Universe or Population The word universe as use...

Universe or Population The word universe as used in statistics denotes the aggregate from which a sample is to be taken. According to Simpson and Kafka, a universe or populatio

Example of discrete random variable, Example of discrete random variable: ...

Example of discrete random variable: 1. What is a discrete random variable? Give three examples from the field of business. 2. Of 1000 items produced in a day at XYZ Manufa

#regression, #regression line drawn as Y=C+1075x, when x was 2, and y was 2...

#regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Linear regression, Linear Regression Generally, in two mutually related...

Linear Regression Generally, in two mutually related statistical series, the regression analysis based on graphic method. Under graphic method the values  of X and Y variable

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