b) (2.0 POINTS) Perform the linear regression calculation and provide the linear regression equation that describes the relationship between Y (number of air conditioning units sold) and X (outside temperature in degrees Fahrenheit. Calculate: Coefficient of determination (r?) and the coefficient of correlation (r). SST, SSE and SSR for this linear regression. Estimate for the variance (02) and the standard deviation for the linear regression model you have developed Guidance: Follow the steps presented on Table 4.2 and 4.3 of textbook and show that your calculations followed that method. Do NOT present the resolution using MS Excel, because it will not count for this item. I'I 2 Y (9 - 7) 6 1.563 8 0 9 Table 4.3 Sum of Squares for Triple A Construction Y (v - Y) 3 (6 - 7)? = 1 2 +1.25 (3) = 5.75 0.0625 4 (8-7)2 = 1 2 +1.25 (4) = 7.00 1 6 (9 - 7)2 = 4 2 +1.25 (6) = 9.50 0.25 4 (5 7) = 4 2 +1.25 (4) = 7.00 4 2 (4.5 7)2 = 6.25 2 +1.25 (2) = 4.50 0 6.25 5 (9.5 7)2 = 6.25 2 +1.25 (5) = 8.25 1.5625 Y = 7 E(Y - Y) 22.5 (Y ) = 6.875 s(- Y) 6.25 5 0 4.5 9.5 1.563 2 2 2 = 15.625 SST 22.5 SSE 6.875 SSR 15.625 Y 12 9 = 2 + 1.25 x 10 Y- TY- Y 12 3 = 2 + 1.25 x 10 Y- Y- 00 Y Y Sales ($100,000s) 4 N 1 2 1 3 4 5 Payroll ($100,000,000s) 6 7 8 X 00 Figure 4.2 Deviations from the Regression Line and from the Mean