Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Question

Question

Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Here is a bivariate data set.

x	y
56.5	70
63.2	34.5
75.3	20.2
69.4	22
33.7	141
44.5	112.3
52.2	81.6
58.6	58.2
58.2	57.6
66.9	40.6
68.8	37.5

Find the correlation coefficient and report it accurate to three decimal places.
r =

What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage accurate to one decimal place.
r² = %

math Statistics-And-Probability

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Here'the answer to the question. Please don't hesitate to give a "thumbs up" in case you're satisfied with the answer

We have the =CORREL formula in Excel to take out the r or the correlation

Rsquare/r^2 is basically the square of the correlation.

Values of correlation (r) and R-square(r^2) are in red.

Correlation -0.983 Use the formula -CORREL(L5:L15,M5:M15)) to get the answer This is just the square of correlation 70 34.5 20.2 56.5 63.2 75.3 69.4 33.7 44.5 52.2 58.6 58.2 66.9 68.8 96.7% 141 112.3 81.6 58.2 57.6 40.6 37.5

Add a comment

Answer 2

Similar Homework Help Questions

Run a regression analysis on the following bivariate set of data with y as the response...

Run a regression analysis on the following bivariate set of data with y as the response variable. data: x, y 27.9, 61.5 35.9, 40.6 53.6, -25.3 15.5, 68.5 32.7 14.4 12.4, 89.4 37.7, 17.3 30.3, 48.6 46.7, -6.3 14.4, 55.5 16.9, 55.3 24.8, 62.1 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a...
Here is a bivariate data set. x y 44.1 57.5 28.1 30.4 19.3 21.1 19.4 7.6...

Here is a bivariate data set. x y 44.1 57.5 28.1 30.4 19.3 21.1 19.4 7.6 23.9 22.7 23.6 25.6 36.5 43.3 47.5 56 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage accurate to one decimal place. r² = %
Here is a bivariate data set. x y 97 45.2 33.2 95.3 58.3 59.5 58.3 84.2...

Here is a bivariate data set. x y 97 45.2 33.2 95.3 58.3 59.5 58.3 84.2 61.9 41.8 50.1 73.2 47.5 97.5 24.8 70.7 9.5 115.9 52.1 68.1 52.4 84.6 18 93.6 65.8 76.5 60.4 40.4 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer as a percentage accurate to one decimal place. r² =...

Here is a bivariate data set. x y 24.1 117.6 27.7 117.8 43.3 57.5 26.1 97.5...

Here is a bivariate data set. x y 24.1 117.6 27.7 117.8 43.3 57.5 26.1 97.5 33.5 79.6 43.2 59.4 17.5 127 11 112.5 25.9 86.2 43.2 48.4 21.8 69.7 27.9 83 10.4 101.3 24.4 80.7 51.8 -6.1 36.6 74.7 37.1 73.4 44.6 54.4 14.2 136.5 30.8 97.5 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x?...
Here is a bivariate data set. x y 63 50 66 57 67 48 59 55...

Here is a bivariate data set. x y 63 50 66 57 67 48 59 55 68 44 68 40 62 37 45 70 Find the correlation coefficient and report it accurate to four decimal places. r =
Here is a bivariate data set. x y 17 118 35 167 67 48 26 146...

Here is a bivariate data set. x y 17 118 35 167 67 48 26 146 48 6 61 97 48 -117 53 -3 31 115 31 29 Find the correlation coefficient and report it accurate to four decimal places. r =

Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5...

Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5 77.4 68.2 -5.9 41.1 -83 61.4 -2.5 87.1 39.4 Find the correlation coefficient and report it accurate to three decimal places. r = What proportion of the variation in y can be explained by the variation in the values of x? Report answer...

Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Homework Answers

Add Answer to:
Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Post as a guest

Earn Coins

Run a regression analysis on the following bivariate set of data with y as the response...

Here is a bivariate data set. x y 44.1 57.5 28.1 30.4 19.3 21.1 19.4 7.6...

Here is a bivariate data set. x y 97 45.2 33.2 95.3 58.3 59.5 58.3 84.2...

Here is a bivariate data set. x y 24.1 117.6 27.7 117.8 43.3 57.5 26.1 97.5...

Here is a bivariate data set. x y 63 50 66 57 67 48 59 55...

Here is a bivariate data set. x y 17 118 35 167 67 48 26 146...

Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5...

Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Homework Answers

Add Answer to: Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...

Post as a guest

Earn Coins

Run a regression analysis on the following bivariate set of data with y as the response...

Here is a bivariate data set. x y 44.1 57.5 28.1 30.4 19.3 21.1 19.4 7.6...

Here is a bivariate data set. x y 97 45.2 33.2 95.3 58.3 59.5 58.3 84.2...

Here is a bivariate data set. x y 24.1 117.6 27.7 117.8 43.3 57.5 26.1 97.5...

Here is a bivariate data set. x y 63 50 66 57 67 48 59 55...

Here is a bivariate data set. x y 17 118 35 167 67 48 26 146...

Using your calculator, run a regression analysis on the following bivariate set of data with y as the response variable. x y 71.2 23.1 90.8 122.9 88.8 82.9 57.7 18.3 71.4 8.6 60.4 25.9 60.2 -43.1 88.5...

Add Answer to:
Here is a bivariate data set. x y 56.5 70 63.2 34.5 75.3 20.2 69.4 22...