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

Measurement error models., how can we use measurement error method with eig...

how can we use measurement error method with eight responses variables (we do not have explanatory variable in the data )?.the data analyse 521 leaves ..

Genmod procedure, The following dataset is from a study of the effects of s...

The following dataset is from a study of the effects of second hand smoking in Baltimore, MD, and Washington, DC. For the 25 children involved in this study the outcome variable is

T test, What is an example of a real life situation when I would use each o...

What is an example of a real life situation when I would use each of these test

Multiple regressions, A sample of 43 houses that were purchased in the Sout...

A sample of 43 houses that were purchased in the Southern California town Monrovia within a month was collected. We are interested in the study of the relationships between Price a

Standard error, Standard Error The measure of reliability of the estima...

Standard Error The measure of reliability of the estimating equation that we have developed is given by standard error of estimate. The standard error of estimate represented b

Sensitivity and Specificity tests, The prevalence of undetected diabetes in...

The prevalence of undetected diabetes in a population to be screened is approximately 1.5% and it is assumed that 10,000 persons will be screened. The screening test will measure

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

Types of averages, The following are the various types of common averages u...

The following are the various types of common averages used in statistical analysis given in the form of a chart. Figure 1

Explain ridge regression, Using log(x1), log(x2) and log(x3) as the predict...

Using log(x1), log(x2) and log(x3) as the predictors, do pair wise scatterplots of all pairs of variables (including the response) and comment (use the pairs function). Do you thin

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

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