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

Stk, The mean tax-return preparation fee H&R Block charged retail customers...

The mean tax-return preparation fee H&R Block charged retail customers in 2012 was $183 (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume t

Bienayme-chebyshev rule, This probability rule determined by the research o...

This probability rule determined by the research of the two mathematicians Bienayme' and Chebyshev, explains the variability of data about its mean when the distribution of the dat

Modified distribution mathod, a b c d e supply p 3 4 6 8 8 20 q 2 6 0 5 8...

a b c d e supply p 3 4 6 8 8 20 q 2 6 0 5 8 30 r 7 11 20 40 3 15 s 1 0 9 14 6 13 d 15 3 12 10 20

QHA, Your employer, Quick Hit Agency (QHA), is a debt collections agency. T...

Your employer, Quick Hit Agency (QHA), is a debt collections agency. The company specializes in collecting small accounts. QHA does not deal in large accounts and does not take on

Explain survey development process, Problem: A survey usually originate...

Problem: A survey usually originates when an individual or an institution is confronted with an information need and the existing data are  insufficient. Planning the questionn

Principles of data analysis, For the data analysis project, you will addres...

For the data analysis project, you will address some questions that interest you with the statistical methodology we are learning in class.   You choose the questions; you decide h

Statistical generalisations, From the information given, what seems to be t...

From the information given, what seems to be the main flaw in each of the following statistical generalisations? (i) Banking industry employees are facing a crisis, if their

Decision making ., it is said that management is equivalent to decision mak...

it is said that management is equivalent to decision making? do you agree? explain

Find probability of remaining paint free - ball duel, In a three-cornered p...

In a three-cornered paint ball duel, A, B, and C successively take shots at each other until only one of them remains paint free. Once hit, a player is out of the game and gets no

Econometrics, implications of multicollinearity

implications of multicollinearity

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