SOLUTION: Based on the data shown below, calculate the correlation coefficient (to three decimal places) independent dependent 4 17.22 5 20.8 6 20.48 7 25.96 8 27.44 9 27.62 10 29 1

Question 1196761: Based on the data shown below, calculate the correlation coefficient (to three decimal places)
independent dependent
4 17.22
5 20.8
6 20.48
7 25.96
8 27.44
9 27.62
10 29
11 34.28
12 33.96
13 35.44
14 39.92

Answer by ewatrrr(24785) (Show Source): You can put this solution on YOUR website!


Hi
Using Excel Spreadsheet, entering Data is 2 Columns and using the CORREL function:
=CORREL(x's, y's)
5	20.8
6	20.48
7	25..96
8	27.44
9	27.62
10	29
11	34.28
12	33.96
13	35.44
14	39.9
	
r = 0.986183776  0r r = .986 	(to three decimal places)

Wish You the Best in your Studies.

RELATED QUESTIONS
Please help me out with this questions. I appreciate thanks. Based on the data shown... (answered by ewatrrr)

Use the given set of bivariate data. (3, 7) (5, 9) (2, 7) (1, 6) (4, 8)... (answered by ikleyn)

Based on the data shown below, calculate the regression line (each value to two decimal... (answered by ikleyn,MathLover1)

You are given the following sample data for variables x and y: X (independent) | Y... (answered by CPhill)

Use the given set of bivariate data. x 1 2 3 4 5 6 y 5.7 4.7 4.6 3.8 3.3 2.8 Calculate (answered by ikleyn)

A realtor studies the relationship between the size of a house (in square feet) and the... (answered by ikleyn)

Find the correlation coefficient for the line of best fit of the set of data below. Round (answered by venugopalramana)

Construct a scatter plot using excel for the given data. Determine whether there is a... (answered by Fombitz)