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

CERTIFICATE OF AIRWORTHINESS FOR EXPORT, CERTIFICATE OF AIRWORTHINESS FOR E...

CERTIFICATE OF AIRWORTHINESS FOR EXPORT When aircraft manufacturers go into series production of a new type of aircraft, then obviously they are hopeful of world wide sales. Sim

Evaluate the probability, "MagTek" electronics has developed a smart phone ...

"MagTek" electronics has developed a smart phone that does things that no other phone yetreleased into the market-place will do. The marketing department is planning to demonstrate

Correlation coefficients, What type of correlation coefficient would you us...

What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A. Re

Find the probability that a lift will weigh, Lifts usually have signs indic...

Lifts usually have signs indicating their maximum capacity. Consider a sign in a lift that reads "maximum capacity 1400kg or 20 persons". Suppose that the weights of lift-users are

Melissa Bakery, Melissa Bakery is preparing for the coming thanksgiving fes...

Melissa Bakery is preparing for the coming thanksgiving festival. The bakery plans to bake and sell its favourite cookies; butter cookies, chocolate cookies and almond cookies. A k

Simplex method, #questionMaximize Z= 3x1 + 2X2 Subject to the constraints: ...

#questionMaximize Z= 3x1 + 2X2 Subject to the constraints: X1+ X2 = 4 X1 - X2 = 2 X1, X2 = 0..

Simple random sampling, Simple Random Sampling In Simple Random Sampli...

Simple Random Sampling In Simple Random Sampling each possible sample has an equal chance of being selected. Further, each item in the entire population also has an equal chan

#vital statistics, # I have to make assignment on vital statistics so kindl...

# I have to make assignment on vital statistics so kindly guide me how to make and get good marks

Probability distribution and sampling distribution , a 100 squash balls are...

a 100 squash balls are bounce from height of 100 inches with average height 30 inch with standard deviation 3/4 inch. a ball is fast if bounce above 32 inch. what is chance of gett

Spatial ability test, What would be the cutoff score to indicate a score th...

What would be the cutoff score to indicate a score that is in the top 15% of the scores on a test with a mean of 100 and a standard deviation of 15? This question has multiple p

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