Compute a correlation coefficient, Applied Statistics

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

Posted Date: 3/11/2013 6:03:59 AM | Location : United States







Related Discussions:- Compute a correlation coefficient, Assignment Help, Ask Question on Compute a correlation coefficient, Get Answer, Expert's Help, Compute a correlation coefficient Discussions

Write discussion on Compute a correlation coefficient
Your posts are moderated
Related Questions
10. If a set of scores has a sample mean of 25 and a sample variance of 4, find the following: a. the z-score for a raw score of 31 b. the z-score for a raw score of 18 c. the raw

Theories of Business forecasting

To use Linear Programming for solving the following inequalities. Following Twin Conditions (as mandated by the Indian Regulatory Authority) Twin Condition I for TV Broadcasters

Types of cost-reimbursable contracts are:   Cost Plus Fixed Fee contract (CPPF): Compensation is based on a fixed sum independent of the final project cost. The customer a

Create the Venn diagram: A   - you work for an insurance company.  80% of your company's staff is sales force and 70% of your company's sales is force is male. in your company

Problem : A company supplying electrical products, places a rush order for electric wires. Consignments of wires are to be sent immediately when they are available. Previous

A salesperson visits from house to house to sell her knives. The probability that she makes a sale at a random house is .3. Given that she makes a sale, the sale is worth $100 with

There may be two values which occur with the same maximum frequency. The distribution is then called bimodal. In a bimodal distribution, the value of mode cannot be determined with

The following data on calcium content of wheat are consistent with summary quantities that appeared in the article “Mineral Contents of Cereal Grains as Affected by Storage and Ins

Mathematical Properties The sum of deviations of the items from the arithmetic mean (taking signs into account) is always zero, i.e.      = 0. The sum of