Determine the coefficient of determination, Basic Statistics

Assignment Help:

1. 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 scatter plot 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:- Determine the coefficient of determination

Co-efficient of covariance., solution of problems based on coefficient of c...

solution of problems based on coefficient of covariance

Ogive, When we use upper or lower class boundaries during calculation of og...

When we use upper or lower class boundaries during calculation of ogive graph?

Confidence Intervals, In each of the following cases, compute 95 percent, 9...

In each of the following cases, compute 95 percent, 98 percent, and 99 percent confidence intervals for the population proportion p. p=.1, n=30, p = .1, n = 100, p = .5, n = 50, p

Balance sheet, how to write and assignment on the balance sheet?

how to write and assignment on the balance sheet?

Create a spreadsheet model and determine linear regression, 1. MMC's CEO, D...

1. MMC's CEO, Dr. Warren A. Beatty (Not the actor) believes that the demand trend for MMC is essentially linear. Thus, he wishes to determine if linear regression would be an effec

develop simulation model-compute average amount, Bob Smith recently comple...

Bob Smith recently completed his MBA and accepted a job with a computer company. To ensure that his retirement is comfortable, he intends to invest $3,000 of his salary into a tax

Average Speed in Various Cases, Define Average Speed in Various Cases (a) ...

Define Average Speed in Various Cases (a) Particles covering different distances in different times say a particle covers s1 distance in time t1 ,s2 in time t2, s3 in time t3 and

Probablity, a fair die is thrown 3 times. Let X1,X2,X3 denote the results o...

a fair die is thrown 3 times. Let X1,X2,X3 denote the results of 3 throws. What is the probablity that p[X1>X2+X3]

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