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

Probability and expectation, Ten balls are put in 6 slots at random.Then ex...

Ten balls are put in 6 slots at random.Then expected total number of balls in the two extreme slots

Canonical correlation analysis, Canonical correlation analysis (CC) allows ...

Canonical correlation analysis (CC) allows the investigation of the relationship between two ,sets of variables. For example, a sociologist may want to investigate the Relationship

Stream flow gauging, (a) At a stream gauging station, the following dischar...

(a) At a stream gauging station, the following discharges and stage measurements were taken for the purpose of the rating curve at that section: Stage (m) 1

Inverse market demand, There are two types of drivers, high-risk drivers wi...

There are two types of drivers, high-risk drivers with an accident probability of 2=3 and low risk drivers with an accident probability of 1=3. In case of an accident the driver su

Circul;atory ststistics Lab, What statistics can be obtained from a circula...

What statistics can be obtained from a circulatory lab?

Index number, Index Number Meaning and Definitions of Index Number ...

Index Number Meaning and Definitions of Index Number The index numbers are the special type of averages which are presented in percentages and computed on certain base.

Time series, Measurement of trend , least square method

Measurement of trend , least square method

Research tool, what are the characteristics of research tool?

what are the characteristics of research tool?

Find the backward induction equilibrium, A rightist incumbent (player I) an...

A rightist incumbent (player I) and a leftist challenger (player C) run for senate. Each candidate chooses among two possible political platforms: Left or Right. The rules of the g

Central tendency and dispersion in statistics, Central Tendency and Dispers...

Central Tendency and Dispersion in Statistics: Write a note on the following : i)    What is the importance of Measures Of Central Tendency and Dispersion in Statistics ?

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