A B C 1 ID Sqft Price 2 68 1171 159924! 3 69 2805 340502 4 70 2589 324599 5 71 2960 367292 6 72 2324 312953 73 2857 422240 8 74 2208 294719 9 75 1823 2123301 10 76 1423 185994 11 77 1957 226444Using an Excel spreadsheet calculate the following: 1. x = y = Ex? = Ex,y. = 2212 284700 2 . Consider the regression equation y; = Bo + Bix; tu, i=1,...,N. The slope coefficient can be derived as B, = Ex,y, - Nxy Ex , - NX and the intercept is derived as Bo = y - Box . What are the two estimators equal to? B, = Bo = 3. Using your estimates, estimate the price of a house that has square feet equal to the mean. Your answer= 4. Form another column in your spreadsheet and estimate the price of each house given the square feet in the house. The estimates are found as y; = B. + Bix;. 5. In another column of your spreadsheet calculate the residuals for each observation: u; = y: - y; and then in another column calculate u, . SSR 6. The variance of the residuals is given as oz N- 2 , where SSR = Cu? . Determine the following: SSR = Of =