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

Coefficient of determination, Coefficient of Determination The c...

Coefficient of Determination The coefficient of determination is given by r 2 i.e., the square of the correlation coefficient. It explains to what extent the variation

Physics, fixed capacitor and variable capacitor

fixed capacitor and variable capacitor

Multiple regression analysis, Complete the multiple regression model using ...

Complete the multiple regression model using Y and your combined X variables.  State the equation.  Next, make sure that you evaluate overall model performance with the Anova table

#Probablility, #In planning the teaching assignments for next semester, Mr....

#In planning the teaching assignments for next semester, Mr. Hinton must have a teacher in each of the 7 grades during each of the 6 periods of the day. If he has 10 teachers to ch

Inverse cumulative distribution function, The Null Hypothesis - H0: β0 = ...

The Null Hypothesis - H0: β0 = 0, H0: β 1 = 0, H0: β 2 = 0, Β i = 0 The Alternative Hypothesis - H1: β0 ≠ 0, H0: β 1 ≠ 0, H0: β 2 ≠ 0, Β i ≠ 0      i =0, 1, 2, 3

Pneumatic actuator design matrix, Pneumatic Actuator Design Matrix: The ra...

Pneumatic Actuator Design Matrix: The range of actuator design parameters have been provisionally assessed and are presented in Table. You are required to determine the following

The weekly treatment , A researcher is interested in comparing the effectiv...

A researcher is interested in comparing the effectiveness of three different parts of therapy for anger problems. 8 participants are randomly assigned to 3 treatment conditions: Co

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.

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.

Age at first marrage, get a questionnaire that captured age at first marria...

get a questionnaire that captured age at first marriage

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