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

Calculate the mle estimate for mean, Each section of the SAT test is suppos...

Each section of the SAT test is supposed to be distributed normally with a mean of 500 and a standard deviation of 100. Suppose 5 students in a class took the SAT math test. They r

Ogive graphs, how many types of ogive are there

how many types of ogive are there

Explain ridge regression, Using log(x1), log(x2) and log(x3) as the predict...

Using log(x1), log(x2) and log(x3) as the predictors, do pair wise scatterplots of all pairs of variables (including the response) and comment (use the pairs function). Do you thin

Statistical definition of probability, Statistical Definition of probabilit...

Statistical Definition of probability: Ques: (a) (i)  Distinguish Statistical Definition of probability from the Classical Definition.                  (ii) State the A

Box plot of income, The box plot displays the diversity of data for the inc...

The box plot displays the diversity of data for the income; the data ranges from 20 being the minimum value and 1110 being the maximum value. The box plot is positively skewed at 4

Calculate the seasonal indexes , The total number of overtime hours (in 100...

The total number of overtime hours (in 1000s) worked in a large steel mill was recorded for 16 quarters, as shown below. Year Quarter Overtime hour

Evaluate the p - value, Use the given information to find the P-value. T...

Use the given information to find the P-value. The test statistic in a two-tailed test is z = 1.49 P-value = (round to four decimal places as needed)

Steps in anova, Steps in ANOVA The three steps which constitute the ana...

Steps in ANOVA The three steps which constitute the analysis of variance are as follows: To determine an estimate of the population variance from the variance that exi

Enumerate the set, Grid is the set of pairs {1, 2, 3, 4} x {1, 2, 3, 4}. ...

Grid is the set of pairs {1, 2, 3, 4} x {1, 2, 3, 4}. Image is the power set of Grid. An element of Image is a subset of Grid and can be represented by a diagram on a 4 by 4

Physics, fixed capacitor and variable capacitor

fixed capacitor and variable capacitor

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