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

Data project, Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel...

Dr. Jim Mirabella UNIT EIGHT: DATA ANALYSIS PROJECT All Excel output should be copied into a single Word document where you must enter all of your responses to the questions below.

Evaluate the probability, "MagTek" electronics has developed a smart phone ...

"MagTek" electronics has developed a smart phone that does things that no other phone yetreleased into the market-place will do. The marketing department is planning to demonstrate

Simple linear regression, For each of the following situations choose the s...

For each of the following situations choose the statistical model that you find to be the most appropriate. Justify your choice. a) We are interested in assessing the effects of

Types of sampling, Given a certain population there are various ways in whi...

Given a certain population there are various ways in which a sample may be drawn from it. The chart below illustrates this point: Figure 1 In  Judgem

Business statistics, Betting on sporting events is big business both in the...

Betting on sporting events is big business both in the US and abroad. Consider, for instance, next winter’s American football tournament known as the Superbowl. Billions of dollars

BIVARIATE FREQUENCY , MARKS IN LAW :10 11 10 11 11 14 12 12 13 10 MARKS IN ...

MARKS IN LAW :10 11 10 11 11 14 12 12 13 10 MARKS IN STATISTICS :20 21 22 21 23 23 22 21 24 23 MARKS IN LAW:13 12 11 12 10 14 14 12 13 10 MARKS IN STATISTICS:24 23 22 23 22 22 24 2

Utility function, The decision maker ranks lotteries according to the utili...

The decision maker ranks lotteries according to the utility function (i) State the independence assumption. Does this decision maker satisfy it? (ii) Is this decision ma

The weekly treatment , A researcher is interested in comparing the effectiv...

A researcher is interested in comparing the effectiveness of three different parts of therapy for anger problems. 8 participants are randomly assigned to 3 treatment conditions: Co

Association of attributes, In an examination 600 candidates appeared, boys ...

In an examination 600 candidates appeared, boys outnumbered girls by 16% of all candidates. number of passed candidates exceeded the number of failed candidates by 310. Boys failin

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