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

To find first quartile, how to find 1st quartile from the graph of more tha...

how to find 1st quartile from the graph of more than ogive type, please reply me with an example

Least squares analysis, Least squares method of fitting a line ( the line o...

Least squares method of fitting a line ( the line of best fit or the regression line) through the scatter diagram is a method which minimizes the sum of squared vertical deviations

Find the p-value of the test hypothesis , It is known that the average heig...

It is known that the average height of a man residing in the Canada is 174 cm and the standard deviation is 8 cm. Assume the heights are normally distributed. To test the hypothesi

Probability, jay can remember only the first 4 digits of his friends phone ...

jay can remember only the first 4 digits of his friends phone number. he also knows that the number has 7 digits and the last digit is not a zero. if jay were to dial all of the po

Analysis and interpretation business report, Case Study. Using the data, pr...

Case Study. Using the data, prepare a report that analyses the profitability, liquidity and solvency of a Accessorize Pty Ltd and help the owner to decided whether to purchase the

Substitution and income effects , Managers are very interested in how ...

Managers are very interested in how a consumer makes choice among alternatives. In this exercise, we ask you to consider the price of gasoline you may purchase to operate

Actual velocity, A boat is heading across a river at a velocity of 25 mph. ...

A boat is heading across a river at a velocity of 25 mph. The river is flowing downstream at 10 mph. What is the actual velocity of the boat?

Accounting cases, Hi I just want to know if you many be able to solve thes...

Hi I just want to know if you many be able to solve these three cases for intermediate accounting class! Thank you

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