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

#title. .explanatory factor analysis, how to compute reliability coefficien...

how to compute reliability coefficient for extracted factors in factor analysis?

Mathematical properties of arithmetic mean, Mathematical Properties ...

Mathematical Properties The sum of deviations of the items from the arithmetic mean (taking signs into account) is always zero, i.e.      = 0. The sum of

Transformation of data, PCA is a linear transformation that transforms the ...

PCA is a linear transformation that transforms the data to a new coordinate system such that the greatest variance by any projection of the data comes to lie on the first coordinat

Primary and secondary data, Primary and Secondary Data: Primary Data: ...

Primary and Secondary Data: Primary Data: These data are those are collected for the first time. Thus primary data are original in character and gathered   by actual observat

Spatial ability test, What would be the cutoff score to indicate a score th...

What would be the cutoff score to indicate a score that is in the top 15% of the scores on a test with a mean of 100 and a standard deviation of 15? This question has multiple p

Logistic regression model, A marketing research firm was engaged by an auto...

A marketing research firm was engaged by an automobile manufacturer to conduct a pilot study to examine the feasibility of using logistic regression for ascertaining the likelihood

Postneonatal mortality rate, Mid year population 440000 Late fatal death...

Mid year population 440000 Late fatal death          29 No. of live birth           5200 No. of infant death      423 No. of maternal death 89 No. of infant deaths i

Gcnnv, Ask questiovdgngddndgdngngngngn #Minimum 100 words accepted#

Ask questiovdgngddndgdngngngngn #Minimum 100 words accepted#

Index number of price for paasche’s method, Construct index numbers of pri...

Construct index numbers of price for the following data by applying: i)      Laspeyre’s method ii)     Paasche’s method iii)    Fisher’s Ideal Index number

Communaiities, The cornlnunalities h j represent the fraction of the tota...

The cornlnunalities h j represent the fraction of the total variance' 'accounted for of variabie j. Ry calculating the communalities we can keep track of how much of-the orig

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