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

Questionnaire, Framing of Questionnaire: Questionnaire is a schedule of...

Framing of Questionnaire: Questionnaire is a schedule of questions which is sent to the respondents for filling in by them in their own handwriting together the information rel

Linear regression mode, The State Department of Taxation wishes to investig...

The State Department of Taxation wishes to investigate the effect of experience, x, on the amount of time, y, required to fill out Form ST 1040AVG, the state income-averaging form.

Correlation, Definition of Correlation According  to prof, king correla...

Definition of Correlation According  to prof, king correlation means that between two series or group  of data  there  exists  some casual connection  prof, king  has also  exp

Data project, Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel...

Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below.

Statistical errors, Statistical Errors              Statistical data ar...

Statistical Errors              Statistical data are obtained either by measurement or by observation. Hence to think of perfect accuracy is only a delusion or a myth, It is no

Compute a correlation coefficient, A researcher was interested lowering the...

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 th

Demand, A monopolist firm''s demand curve is given by P:100-2q. (a) Find it...

A monopolist firm''s demand curve is given by P:100-2q. (a) Find its marginal revenue function.

Coefficient of variation, Coefficient of Variation or C.V. To compare t...

Coefficient of Variation or C.V. To compare the variability between or more series, coeffiecnt of variation is used, it is relative measure of dispersion, it innovated and used

Measures of dispersion, Measures of Dispersion ...

Measures of Dispersion Box 3: Food vs. Oil Below are the figures for foodgrain procurement   and cr

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