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

Vital statistics, How vital statistics are affects on our human life

How vital statistics are affects on our human life

Statistical process control, Statistical Process Control The variabilit...

Statistical Process Control The variability present in manufacturing process can either be eliminated completely or minimized to the extent possible. Eliminating the variabilit

Perform a one-way anova, The Tastee Bakery Company supplies a bakery produc...

The Tastee Bakery Company supplies a bakery product to many supermarkets in a metropolitan area. The company wishes to study the effect of shelf display height employed by the supe

Multivariate statistical methods, As one of the oldest multivariate stati...

As one of the oldest multivariate statistical methods of data reduction, Principal Component Analysis (PCA)simplifies a dataset by producing a small number of derived

Number of principal components, While there are p original variables the n...

While there are p original variables the number of principal components is m such that m

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 ..

Simple regression, Simple Regression: The Teacher Preparation Researc...

Simple Regression: The Teacher Preparation Research Team conducted a study of college students who took the Praxis II-a teacher certification examination. Some variables from

Production took place, Scenario: To fundraise for middle school camp the ye...

Scenario: To fundraise for middle school camp the year 3 and 4 syndicate designed and produced chocolate treats to sell to the year 1 and 2, and year 5 and 6 students at morning te

Problem on standard deviation, Your organization purchases bottles of ...

Your organization purchases bottles of a popular commercial solvent for resale.  Each bottle is labeled as containing 32 fluid ounces of the solvent.  Your cont

Help!, in a normal distribution with a mean of 85 and a STD of 5, what is t...

in a normal distribution with a mean of 85 and a STD of 5, what is the percentage of scores between 75 and 90?

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