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

Introduction to multiple regression, In simple regression the dependent var...

In simple regression the dependent variable Y was assumed to be linearly related to a single variable X. In real life, however, we often find that a dependent variable may depend o

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

Systematic sampling, Systematic Sampling In Systematic Sampling ...

Systematic Sampling In Systematic Sampling each element has an equal chance of being selected, but each sample does not have the same chance of being selected. Here,

Calculate the seasonal indexes , The total number of overtime hours (in 100...

The total number of overtime hours (in 1000s) worked in a large steel mill was recorded for 16 quarters, as shown below. Year Quarter Overtime hour

Non-sampling errors, Statistics Can Lead to Errors The use of st...

Statistics Can Lead to Errors The use of statistics can often lead to wrong conclusions or wrong estimates. For example, we may want to find out the average savings by i

Eliminate all of the insignificant variables, The file Midterm Data.xls ha...

The file Midterm Data.xls has a tab labeled "Many vs. S&P" which presents historical price data for several assets, a volatility condition (VIDX = 1 if the NYSE volatility is grea

Measures of dispersion, calculate variance and standard deviation of the f...

calculate variance and standard deviation of the following sample 12,22,32,13,12,23,34,52,56,23,44,32,11,11

Confidence interval for a proportion, The quick method for a confidence int...

The quick method for a confidence interval for a proportion uses as an approximation for a 95% confidence interval.  The margin of error in this case is slightly larger tha

Assignment 1: Testing Hypotheses for Means, Review the Learning Resources a...

Review the Learning Resources and the media programs related to t tests. For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Buil

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