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
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?

Applications of Standard Error   Standard Error is used to test whether the difference between the sample statistic and the population parameter is significant or is d

There are situations where none of the three averages is fully satisfactory. For example, if the number of items in a series is very small, none of these av

I have 5 observations that i must plug into spss. I need an example of 1. I do not know if you are familiar with SPSS but I am going to ask anyway. Subject 1 is a Hispanic male who

To study the physical fitness of a sample of 28 people, the data below was collected representing the  number of sit-ups that a person could do in one minute.      10    12

Formation of Continuous Frequency Distribution:    Continuous frequency distribution is most popular in practice. With reference to the formation of this type of frequency distr

Let X 1  and X 2  be two independent populations with population means μ 1  and  μ 2  respectively. Two samples are taken, one from each population, of sizes n 1  and n 2  re

The manager of Pizza Hut provides a delivery service for customers who telephone in an order. The manager would like to give callers an idea of the time it will take to deliver an

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.

For the following claim, find the null and alternative hypotheses, test statistic, P-value, critical value and draw a conclusion. Assume that a simple random sample has been selec