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

Time series analysis., how is a free hand graph secular trend method plotte...

how is a free hand graph secular trend method plotted

Determine the effects of stopping smoking on weight gain, Determine the Eff...

Determine the Effects of Stopping Smoking On Weight Gain As part of a study to determine the effects of stopping smoking on weight gain, nine females were weighed on the day t

Redundancy analysis, In reduced rank regression (RRR), the dependent var...

In reduced rank regression (RRR), the dependent variables are first submitted to a PCA and the scores of the units are then used as dependent variables in a series of

X-bar charts when the mean and standard deviation not known , Charts when t...

Charts when the Mean and the Standard Deviation are not known We consider the data corresponding to the example of Piston India Limited. Since we do not know population mean a

Simple linear regression, We are interested in assessing the effects of tem...

We are interested in assessing the effects of temperature (low, medium, and high) and technical configuration on the amount of waste output for a manufacturing plant. Suppose that

Calculate the maximum weight of the engine, Determine the maximum weight in...

Determine the maximum weight in kN to one decimal point (1 DP) of the engine that can be supported without exceeding the tension given in  Parameter 1 (P1) in chain AB or 1.1 x P1

Simple linear regression, Simple Linear Regression   While correlati...

Simple Linear Regression   While correlation analysis determines the degree to which the variables are related, regression analysis develops the relationship between the var

Geometric mean, Geometric Mean The geometric mean   of numbers is defin...

Geometric Mean The geometric mean   of numbers is defined as the th root of the product of numbers .It is obtained by multiplying all the values of a variable and then extracti

Determine the compressive force, The weight of the engine in kN is given in...

The weight of the engine in kN is given in P2 and is suspended from a vertical chain at A. A second chain round the engine is attached at A, with a spreader bar between B and C. Th

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

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

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