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

Multiple correspondence analysis, Correspondence Analysis (CA) is a general...

Correspondence Analysis (CA) is a generalization of PCA to contingency tables. The factors of correspondence analysis give an orthogonal decomposi:ion of the Chi- square associated

Inverse market demand, There are two types of drivers, high-risk drivers wi...

There are two types of drivers, high-risk drivers with an accident probability of 2=3 and low risk drivers with an accident probability of 1=3. In case of an accident the driver su

Logistic regression model, A marketing research firm was engaged by an auto...

A marketing research firm was engaged by an automobile manufacturer to conduct a pilot study to examine the feasibility of using logistic regression for ascertaining the likelihood

Correlation, prove that coefficient of correlation lies between -1 and+1

prove that coefficient of correlation lies between -1 and+1

Methods of forecasting, Methods of Forecasting  Various techniques whic...

Methods of Forecasting  Various techniques which are generally used in business forecasting are as under: 1.      Forecasting  through the opinion of heads  of department

Find the optimal adaptive meshes for a skewed beta density, Show that the I...

Show that the ISB in a bin containing the origin of the double exponen-tial density, f(x) = exp(-|x|)/2, is O(h 3 ); hence, the discontinuity in the derivative of f does not have a

What are the hypotheses, Assume that a simple random sample has been select...

Assume that a simple random sample has been selected from a normally distribute population and test the given claim. Identify the null and alternative hypotheses, test statistic,

Correlation matrix table, A.    Do the correlation matrix table. B.    W...

A.    Do the correlation matrix table. B.    Which variable (s) has the largest correlation coeffieient which is not a perfect correlation? C.    Which variable (s) has the s

Bionomial, The Quality Manager of a battery manufacturing plant reviewed th...

The Quality Manager of a battery manufacturing plant reviewed the warranty records within his department and found that 4% of the low maintenance batteries produced at the plant ov

B) Distinguish between:, X 110 120 130 120 140 135 155 160 165 155 ...

X 110 120 130 120 140 135 155 160 165 155 Y 12 18 20 15 25 30 35 20 25 10

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