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

Evaluate the standard deviation, Use only the rare event rule, and make sub...

Use only the rare event rule, and make subjective estimates to determine whether events are likely. For example, if the claim is that a coin favors heads and sample results consis

Business staitistices- soltion to :, A file on DocDepot in the assignments ...

A file on DocDepot in the assignments folder on doc-depot called bmi.mtp contains data on the Body Mass Index (BMI) of a population of Ottawa residents. The first column identifies

Index number of price for paasche’s method, Construct index numbers of pri...

Construct index numbers of price for the following data by applying: i)      Laspeyre’s method ii)     Paasche’s method iii)    Fisher’s Ideal Index number

Estimate the values of the dependent variable, 1. Suppose you are estimatin...

1. Suppose you are estimating the imports (from both the U.S. mainland and foreign countries) of fuels and petroleum products in Hawaii (the dependent variable). The values of the

Find the relation between two substance, Find the Relation between two subs...

Find the Relation between two substance: The following table shows the results obtained in experiments aimed to determine how solubility of water in benzene depends on tempera

Correlation, prove that coefficient of correlation lies between -1 and+1

prove that coefficient of correlation lies between -1 and+1

Steps in anova, Steps in ANOVA The three steps which constitute the ana...

Steps in ANOVA The three steps which constitute the analysis of variance are as follows: To determine an estimate of the population variance from the variance that exi

QUARTILE DEVIATION, Examples of grouped, simple and frequency distribution ...

Examples of grouped, simple and frequency distribution data

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

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