really confused please help I have included the data table that is needed to help solve the problems
A B D E 1 Real Estate Sales Price 2 Sales Price Home Size Rating 4 Y X1 X2 5 180 23 5 6 98.1 11 2 173.1 20 9 8 136.5 17 9 141 15 10 165.9 21 11 N V O V A OO W C 193.5 24 12 127.8 13 13 163.5 19 14 172.5 25 15 16 17 18 19 20 21 22 23 24 25 26 Sheet1 10THE REAL ESTATE SALES PRICE CASE A real estate agency collects the data concerning y = sales price of a house (in thousands of dollars) x1 = home size (in hundreds of square feet) x2 = rating (an overall "niceness rating" for the house expressed on a scale from 1 [worst] to 10 [best], and provided by the real estate agency) Scatter plots of y versus x1 and y versus x2 are as follows: Price Price Size, X1 Rating, X2 Click here for the data. 1. What is b1 and b2 2. Calculate a point estimate of the mean sales price of all houses having 2,000 square feet and a rating of 8: , and a point prediction of the sales price of a single house having 2,000 square feet and a rating of 8: 3. What is the total variation , unexplained variation ], and explained variation 4. What is the adjusted R2. 5. Use the F(model) statistic and the appropriate critical value to test the significance of the linear regression model under consideration by setting a equal to .05. (1) What are the F(model) statistic and the F critical value (2) Reject or do not reject HO (Click to select) (3) Is the model significant? (Click to select) ) 6. Find the p-value related to F(model) on the output . Using the p-value, test the significance of the linear regression model by setting a = .001. Reject or do not reject HO (Click to select)) 875 7. Using the t statistic and appropriate critical values, test the significance of B1 by setting a equal to .01. 516 (1) What are the t value and the positve t critical value (2) Reject or do not reject HO (Click to select) (3) Is B1 significant? (Click to select) 8. Using the t statistic and appropriate critical values, test the significance of B2 by setting a equal to .01. (1) What are the t value and the positive t critical value (2) Reject or do not reject HO (Click to select) (3) Is B2 significant? (Click to select) 9. Calculate the 99 percent confidence interval for B1? Lowerl limit ], Upper limit MAY 20 67 10 ... W tv MacBook Pro Save to: De & W # 4