Question

Tall Buildings The stories and heights (in feet) of a sample of 10 buildings in Pittsburgh are shown. 40 31 44 42 39 40 Stories Height y Send data to Excel 64 741 54 625 45 515 41 420 535 516 482 435 411 385 The correlation coefficient for the data is r=0.788 and a =0.05. Should regression analysis be done? The regression analysis should not be done. The regression analysis should be done. Find the equation of the regression line. Round the coefficients to at least three decimal places. y' = a + bx a = b Find y' when x = 48. Round your answer to at least three decimal places. y' -

Answer 1

Sr. No. X Y 1 64 741 2 54 625 535 3 40 4 516 31 45 Сл 6 44 515 482 435 420 7 42 8 41 9 39 411 10 40 385 ra 0.788 =CORREL(B2:B11, C2:C11) t= 3.620091 =(SQRT(COUNT(B2:B11)-2)*B13)/SQRT(1-B13^2) p-value= 0.006782 =2*(1-T.DIST(B14, COUNT(B2:311)-2,1)) p-value<alpha=0.05 the we reject Ho The regression analysis should be done y'=a+bx 89.57 =ROUND(INTERCEPT(C2:C11,B2:B11),3) b= 9.476 =ROUND(SLOPE(C2:C11,B2:B11),3) a= y' when x=48 y'= 544.418 =B19+B20*48