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

Poisson distribution, Poisson Distribution The poisson Distribution  wa...

Poisson Distribution The poisson Distribution  was discovered  by French mathematician simon  denis  poisson. It is a discrete probability distribution. Meaning : In bi

Atmospheric circulation and precipitation, (a) Elevation (m)...

(a) Elevation (m) 0 400 800 1200 1600 2000 2400 2800 3200 4000 480

Use event rule ot estimates the claim, Make a decision about the given clai...

Make a decision about the given claim. Use only the rare event rule, and make subjective estimates to determine whether events are likely. For example, if the claim is that a coi

Weibull distribution, slope parameter of 1.4 and scale parameter of 550.cal...

slope parameter of 1.4 and scale parameter of 550.calculate Reliability, MTTF, Variance, Design life for R of 95%

Calculate the maximum charge current, For the circuit shown below; Wr...

For the circuit shown below; Write a KCL equation for Node A, Node B, Node C and Node D. Write a KVL equation for Loop 1, Loop 2 and Loop 3.   A simple circ

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

Assignment 1: Testing Hypotheses for Means, Review the Learning Resources a...

Review the Learning Resources and the media programs related to t tests. For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Buil

Find the conditional distribution of turning diameter, 1. Assume the random...

1. Assume the random vector (Trunk Space, Length, Turning diameter) of Japanese car is normally distributed and the unbiased estimators for its mean and variance are the truth. For

#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

Types of correlation, Type of Correlation 1.      Positive and Negat...

Type of Correlation 1.      Positive and Negative Correlation: 2.      Simple Partial and Multiple Correlations. 3.      Linear and  Non linear or Correlations

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