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

Analysis of variance (anova), Analysis of variance allows us to test whethe...

Analysis of variance allows us to test whether the differences among more than two sample means are significant or not. This technique overcomes the drawback of the method used in

Bernoulli''s theorem, Bernoulli's Theorem If a trial of an experiment c...

Bernoulli's Theorem If a trial of an experiment can result in success  with probability p and failure with probability q (i.e.1-p) the probability of exactly r success in n tri

Weighted arithmetic mean, Weighted Arithmetic Mean Another aspect...

Weighted Arithmetic Mean Another aspect to be considered is the importance we assign to each observation. The arithmetic mean as we calculated it so far gives equal

Calculate the length of the rope, The tension, T, in the tow rope pulling t...

The tension, T, in the tow rope pulling the car in Newtons is given in P8.  Determine the minimum length of the rope l, between A and B, so that the tension in either AB or AC equa

PERCENTAGES, CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 U...

CALCULATE THE PERCENTAGE OF REFUNDS EXPECTED TO EXCEED $1000 UNDER THE CURRENT WITHHOLDING GUIDELINES

Create the venn diagram, Create the Venn diagram: A   - you work for 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

X-bar charts when the mean and standard deviation not known , Charts when t...

Charts when the Mean and the Standard Deviation are not known We consider the data corresponding to the example of Piston India Limited. Since we do not know population mean a

Median, Median Median is a position average. It is the value of middle ...

Median Median is a position average. It is the value of middle item of a variable when the items are arranged according to their values either in ascending or descending order.

Uncertain demand, Consider a Cournot duopoly with two firms (fi rm 1 and f...

Consider a Cournot duopoly with two firms (fi rm 1 and fi rm 2) operating in a market with linear inverse Demand P(Q) = x Q where Q is the sum of the quantities produced by both

Simple linear regression, Simple Linear Regression   While correlati...

Simple Linear Regression   While correlation analysis determines the degree to which the variables are related, regression analysis develops the relationship between the var

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