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

Determine nash equilibria, Two students are sitting in a lecture and consid...

Two students are sitting in a lecture and considering whether to ask a question from the professor (both of them are considering the same question). If they both ask, the questi

Compute the sample mean and sample standard deviation, We want to investiga...

We want to investigate the income data.  In the Excel file Midterm  Data.xls there is a tab labeled "Income Data 2006".  The data in the tab is the income reported by 400 people in

Artificial neural network, Normal 0 false false false E...

Normal 0 false false false EN-US X-NONE X-NONE

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

Calculate mean and standard deviation, Select and generate your assignment ...

Select and generate your assignment portfolio. The S&P/ASX 200 index is comprised of several sub-indices, including the following: 0) XPJ: The S&P/ASX 200 A-REIT Index 1) XDJ

Different analyses of recurrent events data, Different analyses of recurren...

Different analyses of recurrent events data: The bladder cancer data listed in Wei, Lin, and Weissfeld (1989) is used in Example 54.8/49.8 of SAS to  illustrate different anal

Canonical correlation analysis, Canonical correlation analysis (CC) allows ...

Canonical correlation analysis (CC) allows the investigation of the relationship between two ,sets of variables. For example, a sociologist may want to investigate the Relationship

Time series, what is the use of applied statistic in our daily routin life

what is the use of applied statistic in our daily routin life

Spatial ability test, What would be the cutoff score to indicate a score th...

What would be the cutoff score to indicate a score that is in the top 15% of the scores on a test with a mean of 100 and a standard deviation of 15? This question has multiple p

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