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

WEDGE FRICTION, Ask question #MinimumA wedge is small piece of material hav...

Ask question #MinimumA wedge is small piece of material having two of their opposite faces not parallel. To lift block of weight W, it is pushed by horizontal force P which lifts t

Non-sampling errors, Statistics Can Lead to Errors The use of st...

Statistics Can Lead to Errors The use of statistics can often lead to wrong conclusions or wrong estimates. For example, we may want to find out the average savings by i

Accelerated failure time model, Accelerated Failure Time Model A basic m...

Accelerated Failure Time Model A basic model for the data comprising of survival times, in which the explanatory variables measured on an individual are supposed to act multipli

Estimate a linear probability model, Estimate a linear probability model: ...

Estimate a linear probability model: Consider the multiple regression model: y = β 0 +β 1 x 1 +.....+β k x k +u Suppose that assumptions MLR.1-MLR4 hold, but not assump

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

Standard deviation , Standard Deviation  The concept of standard deviat...

Standard Deviation  The concept of standard deviation was first introduced by Karl Pearson in 1893. The standard deviation is the most important and the popular measure of disp

Utility function, The decision maker ranks lotteries according to the utili...

The decision maker ranks lotteries according to the utility function (i) State the independence assumption. Does this decision maker satisfy it? (ii) Is this decision ma

Luxury goods higher for men than for women, According to a recent study, wh...

According to a recent study, when shopping online for luxury goods, men spend a mean of $2,401, whereas women spend a mean of $1,527. Suppose that the study was based on a sample o

Large sample test for mean, Large Sample Test for Mean A random sample ...

Large Sample Test for Mean A random sample of size n (n > 30) has a sample mean    . To test the hypothesis that the population mean μ has a specified value  μ 0  let us formu

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