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

The cost of living index, The cost of living index number on a some data wa...

The cost of living index number on a some data was 200. From the base period, the percentage enhances in prices were-Rent Rs 60, clothing Rs 250, Fuel and Light Rs 150 and Miscella

Scatter diagram - correlation analysis, Scatter Diagram The first step ...

Scatter Diagram The first step in correlation analysis is to visualize the relationship. For each unit of observation in correlation analysis there is a pair of numerical value

Pattie-lynns utility function, Pattie-Lynn's utility function for total as...

Pattie-Lynn's utility function for total assets is, in which A represents total assets in thousands of dollars. (a) Graph Pattie-Lynn's utility function. How would y

Correlation coefficients, What type of correlation coefficient would you us...

What type of correlation coefficient would you use to examine the relationship between the following variables? Explain why you have selected the correlation coefficients. A. Re

Sample standard deviation, Sample Standard Deviation So far, we discu...

Sample Standard Deviation So far, we discussed the population standard deviation. Now, let us switch to sample standard deviation(s) that is analogous to the population stand

Correlation, Definition of Correlation According  to prof, king correla...

Definition of Correlation According  to prof, king correlation means that between two series or group  of data  there  exists  some casual connection  prof, king  has also  exp

Confirmatory factor analysis, Confirmatory factor analysis (CFA) seeks to d...

Confirmatory factor analysis (CFA) seeks to determine whether the number of factors and the loadings of measured (indicator) variables on them conform to what is expected on the ba

Stk, The mean tax-return preparation fee H&R Block charged retail customers...

The mean tax-return preparation fee H&R Block charged retail customers in 2012 was $183 (The Wall Street Journal, March 7, 2012). Use this price as the population mean and assume t

Find the relation between two substance, Find the Relation between two subs...

Find the Relation between two substance: The following table shows the results obtained in experiments aimed to determine how solubility of water in benzene depends on tempera

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