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

Correlation, Correlation The correlation is commonly used and a useful...

Correlation The correlation is commonly used and a useful statistic used to describe the degree of the relationships between two or more variables. Pearson's correlation refle

Collaboration policy,  Each question, by default, should be solved INDIVID...

 Each question, by default, should be solved INDIVIDUALLY, unless marked as \collaborative". Questions marked as \collaborative" implies that for those questions you are encourage

Correlation coefficient, Consider three stocks A, B and C costing $100 each...

Consider three stocks A, B and C costing $100 each. The annual returns on the three stocks have mean $5 and variance $10. a. Suppose that the returns on the three stocks are i.i

Chi-square test, Consider the following linear regression model:      a)...

Consider the following linear regression model:      a) What does y and x 1 , x 2 , . . . . x k represent?      b) What does β o , β 1 , β 2 , . . . . β k represent?

Probability, .1 Modern hotels and certain establishments make use of an ele...

.1 Modern hotels and certain establishments make use of an electronic door lock system. To open a door an electronic card is inserted into a slot. A green light indicates that the

Probability and expectation, Ten balls are put in 6 slots at random.Then ex...

Ten balls are put in 6 slots at random.Then expected total number of balls in the two extreme slots

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

Financial payments technology, Suppose the money supply process is now repr...

Suppose the money supply process is now represented by the following function: where m measures the sensitivity of money supply with respect to the interest rate. (i) Us

Frequency distribution, Frequency distribution A frequency distribution...

Frequency distribution A frequency distribution is a series where a number of items with similar values are put in separate groups or bunches. In other words a frequency distri

Quantitative Models, Consider the following new business venture. An agent ...

Consider the following new business venture. An agent is considering investment in one of three real estate parcels: • Option 1: multiunit rentals • Option 2: commercial building

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