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

Ask an Expert

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

Write your message here..

Related Questions

Chi-square test, Consider the following linear regression model:      a)... 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, Applications of Standard Error   ... 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

Which average is to be used to describe statistical data?, There ar... 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

SPSS Program, I have 5 observations that i must plug into spss. I need an e... 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

Determine the lower and upper fences, To study the physical fitness of a sa... 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

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

Test for equality of two means, Let X 1  and X 2  be two independent po... 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

Calculate the line of best fit, The manager of Pizza Hut provides a deliver... 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

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.

Choose the correct null hypotheses, For the following claim, find the null ... 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