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

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

Flow chart for confidence interval, Flow Chart for Confidence Interval ...

Flow Chart for Confidence Interval We can now prepare a flow chart for estimating a confidence interval for μ, the population parameter. Figure

Binomial and continuous model, Exercise: (Binomial and Continuous Model.) C...

Exercise: (Binomial and Continuous Model.) Consider a binomial model of a risky asset with the parameters r = 0:06, u = 0:059, d =  0:0562, S0 = 100, T = 1, 4t = 1=12. Note that u

Effect in frequency domain, A) The three images shown below were blurred us...

A) The three images shown below were blurred using square masks of sizes n=23, 25, and 45, respectively. The vertical bars on the le_ lower part of (a) and (c) are blurred, but a c

Random sampling method, Random Sampling Method In this method the units...

Random Sampling Method In this method the units are selected in such a way that every item in the whole universe has an equal chance of being included. In the words of croxton

Classical and modern regression, The data in the data frame asset are from ...

The data in the data frame asset are from Myers (1990), \Classical and Modern Regression with Applications (Second Edition)," Duxbury. The response y here is rm return on assets f

Latin Square design, what is the the Latin Square design? What is its appli...

what is the the Latin Square design? What is its application in research? please explain this term with very simple but with detailed explanation for effective understanding. I hav

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

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

Draw a cumulative frequency polygon, The following data give the repair cos...

The following data give the repair costs (in RM) for 30 randomly selected cars from a list of cars involved in collisions. a)  By using RM 1 as the lower limit of the first

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