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

Assignment 1: Testing Hypotheses for Means, Review the Learning Resources a...

Review the Learning Resources and the media programs related to t tests. For additional support, review the Skill Builder: Research Design and Statistical Design and the Skill Buil

Residual, regression line drawn as Y=C+1075x, when x was 2, and y was 239, ...

regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

Testing of hypothesis, Testing of Hypothesis One objective of sampling...

Testing of Hypothesis One objective of sampling theory is Hypothesis Testing. Hypothesis testing begins by making an assumption about the population parameter. Then we gather

Simulation - analytical approach, Analytical Approach We will illustra...

Analytical Approach We will illustrate this through an example. Example 1 A firm sells a product in a market with a few competitors. The average price charged by the

Construct a cumulative percentage polygon, 1. For each of the following var...

1. For each of the following variables: major, graduate GPA, and height: a. Determine whether the variable is categorical or numerical. b. If the variable is numerical, deter

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

Standard erro, practical application of standard error

practical application of standard error

business forecasting, Explain the characteristics of business forecasting

Explain the characteristics of business forecasting.

Distrbution., The score distribution shown in the table is for all students...

The score distribution shown in the table is for all students who took a yearly AP statistical exam. An AP statistics teacher had 59 students preparing to take the AP exam. Though

Regression, Regression line drawn as Y=C+1075x, when x was 2, and y was 239...

Regression line drawn as Y=C+1075x, when x was 2, and y was 239, given that y intercept was 11. calculate the residual

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