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

Level process control lab, Based on the following graphs (next page) you sh...

Based on the following graphs (next page) you should write a discussion report (2 pages) on: 1. Determination of whether the open-loop system response is consistent with a 1st o

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

Null and alternative hypothesis, 1) Suppose you want to test a hypothesis t...

1) Suppose you want to test a hypothesis that two treatments, A and B, are equivalent against the alternative that the response for A tend to be larger than those of B. You plan to

Empirical mode, Empirical Mode Where mode is ill-defined, its value may...

Empirical Mode Where mode is ill-defined, its value may be ascertained by the following formula based upon the empirical relationship between Mean, Median and Mode: Mode = 3

Comparison of the principal averages-mean, Comparison of the Principal Aver...

Comparison of the Principal Averages-Mean, Median and Mode The mean, median, and mode are located at the same point in a symmetrical frequency distri

Problem set for logistic regression, (1) What values can the response varia...

(1) What values can the response variable Y take in logistic regression, and hence what statistical distribution does Y follow? The response variable can take the value of either

Sequential sampling, Sequential Sampling Under this method, a number of...

Sequential Sampling Under this method, a number of sample lots are drawn one after another from a universe depending on the results of the earlier samples. Such sampling is gen

Ashland MultiComm Services, Suppose that in the actual survey of 50 prospec...

Suppose that in the actual survey of 50 prospective customers, 6 subscribe to the 3 for all offer, what does this tell you about the previous estimate of the proportion of customer

Appropriate statistical test, I would like to know what the appropriate sta...

I would like to know what the appropriate statistical test is for investigating an association between a nominal variable and an ordinal variable assuming normal distribution? It''

Measurement errors models, How can we analyse data with four bilateral resp...

How can we analyse data with four bilateral response variables measured with errors and three covariated measured without errors?

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