(Solved): please help with all thanks!  Based on the data shown below, calculate the correlation coeffici ...

Based on the data shown below, calculate the correlation coefficient (rounded to three decimal places) X 5 6 7 8 9 10 11 12 13 14 15 y 29.15 30.8 31.85 34.2 35.25 38.1 38.75 41.1 44.85 48.2 50.05 Based on the data shown below, calculate the regression line (each value to at least two decimal places) y = X 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 y 41.05 42.26 38.57 34.28 31.69 30.9 27.11 25.62 22.43 22.64 19.75 17.06 14.17 10.68 9.39 7.7 X + A regression was run to determine if there is a relationship between hours of TV watched per day (x) and number of situps a person can do (y). The results of the regression were: y=ax+b a=-0.685 b=24.606 r²=0.942841 r=-0.971 Use this to predict the number of situps a person who watches 3.5 hours of TV can do (to one decimal place) You generate a scatter plot using Excel. You then have Excel plot the trend line and report the equation and the ² value. The regression equation is reported as y = 70.86x + 85.07 and the r² = 0.9025. What is the correlation coefficient for this data set? Here is a bivariate data set. X 46.5 51 35.6 36.9 22.1 20.8 51.1 20.9 24.6 43.4 37.2 40.2 58.5 11.1 66.9 34.7 40.2 28.4 36.3 y 13.6 40.7 38.3 50.8 25.9 27.3 114 9.7 10.9 50.9 41.6 35.4 73.4 -26.2 105.3 8.5 47.3 -35 18.8 This data can be downloaded as a *.csv file with this link: Download CSV 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² = % The line of best fit through a set of data is y = 13.0713.453x - According to this equation, what is the predicted value of the dependent variable when the independent variable has value 140? y place. Round to 1 decimal