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

QUARTILE DEVIATION, Examples of grouped, simple and frequency distribution ...

Examples of grouped, simple and frequency distribution data

Calculate the mle estimate for mean, Each section of the SAT test is suppos...

Each section of the SAT test is supposed to be distributed normally with a mean of 500 and a standard deviation of 100. Suppose 5 students in a class took the SAT math test. They r

Bionomial, The Quality Manager of a battery manufacturing plant reviewed th...

The Quality Manager of a battery manufacturing plant reviewed the warranty records within his department and found that 4% of the low maintenance batteries produced at the plant ov

Universe or population, Universe or Population The word universe as use...

Universe or Population The word universe as used in statistics denotes the aggregate from which a sample is to be taken. According to Simpson and Kafka, a universe or populatio

Factor loadings matrix, As we stated above, we start factor analysis with p...

As we stated above, we start factor analysis with principal component analysis, but we quickly diverge as we apply the a priori knowledge we brought to the problem. This knowled

Calculating 40th percentile in ogive graph, how do i determine the 40th per...

how do i determine the 40th percentile in an ogive graph

Types of cost-reimbursable contracts, Types of cost-reimbursable contracts ...

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

Show the hypothesis test, The file Midterm Data.xls has a tab labeled "Inc...

The file Midterm Data.xls has a tab labeled "Income Data 2009". This data is collected income data from a sample of 400 people in 2009. Use a hypothesis test to see whether the av

Draw a network diagram for this problem, The project of building a backyard...

The project of building a backyard swimming pool consists of eight major activities and has to be completed within 19 weeks. The activities and related data are given in the follow

Population variance, Examining the Population Variance Business decisio...

Examining the Population Variance Business decision making does not limit itself to setting up the hypothesis to test for the equality of more than two means or proportions sim

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