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

Two methods of isolating trend values in a time series, a) What is meant by...

a) What is meant by secular trend? Discuss any two methods of isolating trend values in a time series.

Dominant strategy equilibrium, Consider the following game: (a) If ...

Consider the following game: (a) If (top, left) is a Weakly Dominant Strategy Equilibrium, then what inequalities must hold among (a, ..., h)? (b) If (top, left) is a Na

Classical and modern regression, The data in the data frame asset are from ...

The data in the data frame asset are from Myers (1990), \Classical and Modern Regression with Applications (Second Edition)," Duxbury. The response y here is rm return on assets f

Example of discrete random variable, Example of discrete random variable: ...

Example of discrete random variable: 1. What is a discrete random variable? Give three examples from the field of business. 2. Of 1000 items produced in a day at XYZ Manufa

Calculate unbiased estimate of the variance, This question has two parts wi...

This question has two parts with multiple items to answer. You are a psychologist who has collected the subjective well-being scores of a number of elderly people aged 90 or abo

student is chosen randomly, In a management class of 100 childerns' 3 lang...

In a management class of 100 childerns' 3 languages are offered as an additional subject viz. Hindi, English and Kannada. There are 28 childrens taking Hindi, 26 taking Hindi and 1

Measurement errors models, How can we analyse data with four bilateral resp...

How can we analyse data with four bilateral response variables measured with errors and three covariated measured without errors?

Standard error, Standard Error The measure of reliability of the estima...

Standard Error The measure of reliability of the estimating equation that we have developed is given by standard error of estimate. The standard error of estimate represented b

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.

Show the hypothesis test, The file Midterm Data.xls has a tab labeled "Inc...

The file Midterm Data.xls has a tab labeled "Income Data 2009". This data is collected income data from a sample of 400 people in 2009. Use a hypothesis test to see whether the av

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