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

Number of principal components, While there are p original variables the n...

While there are p original variables the number of principal components is m such that m

Utility index , If the economy does well, the investor's wealth is 2 and if...

If the economy does well, the investor's wealth is 2 and if the economy does poorly the investor's wealth is 1. Both outcomes are equally likely. The investor is offered to invest

Multivariate analysis, Multivariate analysis involves a set of techniques t...

Multivariate analysis involves a set of techniques to analyse data sets on more than one variable. Many of these techniques are modern and often involve quite sophisticated use of

Confidence interval, a) List down several measures of central tendency and ...

a) List down several measures of central tendency and define the difference among them? b) What do you mean by confidence interval, and why it is useful? What is a confidence lev

Pie diagram, Circles or Pie Diagram: Circles or pie diagrams are alter...

Circles or Pie Diagram: Circles or pie diagrams are alternative to squares. These are used  for the same purpose i.e. when  the values are differing  widely in their magnitude

Descriptive statistics for every stock, Simple Linear Regression One ca...

Simple Linear Regression One calculate of the risk or volatility of an individual stock is the standard deviation of the total return (capital appreciation plus dividends) over

Classification of universe, Classification of Universe The universe may...

Classification of Universe The universe may be classified either on the basis of number of units and on the basis   of existence of units as is clear from the following chart :

Dominant strategy equilibrium, Consider the following game: (a) If ...

Consider the following game: (a) If (top, left) is a Weakly Dominant Strategy Equilibrium, then what inequalities must hold among (a, ..., h)? (b) If (top, left) is a Na

Uses of arithmetic mean, Uses Arithmetic mean is widely used beca...

Uses Arithmetic mean is widely used because of the following reasons: Mean is the simplest average to understand and easy to compute. It

Arithmetic mean, Arithmetic Mean   The process of computing Arithmetic M...

Arithmetic Mean   The process of computing Arithmetic Mean in the case of individual observations is to take the sum of the values of the variable and then divide by the number

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