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

Median, The median, as the name suggests, is the middle value of a series a...

The median, as the name suggests, is the middle value of a series arranged in any of the orders of magnitude i.e. ascending or descending order. As distinct from the arithmetic

The cost of living index, The cost of living index number on a some data wa...

The cost of living index number on a some data was 200. From the base period, the percentage enhances in prices were-Rent Rs 60, clothing Rs 250, Fuel and Light Rs 150 and Miscella

Collaboration policy,  Each question, by default, should be solved INDIVID...

 Each question, by default, should be solved INDIVIDUALLY, unless marked as \collaborative". Questions marked as \collaborative" implies that for those questions you are encourage

Central tendency and dispersion in statistics, Central Tendency and Dispers...

Central Tendency and Dispersion in Statistics: Write a note on the following : i)    What is the importance of Measures Of Central Tendency and Dispersion in Statistics ?

Principal components analysis, In the context of multivariate data analysis...

In the context of multivariate data analysis, one might be faced with a large number of v&iables that are correlated with each other, eventually acting as proxy of each other. This

What is the probability that they all hit the target, QUESTION ONE. (a) ...

QUESTION ONE. (a) The probability that, a bomber hits a target on a bombing mission is 0.70 Three bombers are sent to bomb a particular target. (i) What is the probability

Mathematical properties of arithmetic mean, Mathematical Properties ...

Mathematical Properties The sum of deviations of the items from the arithmetic mean (taking signs into account) is always zero, i.e.      = 0. The sum of

Regression analysis, Of the 6,325 kindergarten students who participated in...

Of the 6,325 kindergarten students who participated in the study, almost half or 3,052 were eligible for a free lunch program. The categorical variable sesk (1 == free lunch, 2 = n

Introduction to probability, Introduction to Probability A ...

Introduction to Probability A student is considering whether she should enroll in an MBA educational program offered by a well-known college. Among othe

Mode, Mode Mode is the value of the observation which occurs with the  ...

Mode Mode is the value of the observation which occurs with the   greatest  frequency and thus  it is the most fashionable value, Mode has been derived from French  word  La  m

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