someone please answer this fast

Excel Data Questions Use the Spring Houses data file from the chapter 15 data folder for the following questions. This data set contains data on a sample of home Selling Prices in dollars (dependent variable). The possible independent variables include home size in square feet (Sq Ft), the number of Baths, and the number of bedrooms (Beds). You will use this data to determine any possible relationship between home characteristics and selling price. Question 16 (1 point) Estimate a simple linear regression of the home selling price using the home square footage as the independent variable. Theoretically (meaning probably not in the real world), what does your model tell you a house would sell for if it had 0 square feet. $42,223.41 $0 $86.37 $124,796.84 Question 17 (1 point) Estimate a simple linear regression of the home selling price using the home square footage as the independent variable. How much of the variation in sales price does this model explain? 43% 86% 20% 57% Question 18 (1 point) Estimate a simple linear regression of the home selling price using the number of bedrooms as the independent variable. How much does your model predict a home would sell for that had 2 bedrooms? O $171,889.39 $178,072.73 $85,944.70 $92,128.03 Question 19 (1 point) Estimate a simple linear regression of the home selling price using the number of bathrooms as the independent variable. Which of the three models you just estimated, this one, the one with square feet, and the one with bedrooms, explains the most variation in the sales price? Square feet, post up! Bathrooms, turn up! Bedrooms, hold up! All three are the same. Question 20 (1 point) Estimate a simple linear regression of the home selling price using the home square footage as the independent variable. Which of the following is your estimated equation? = 8 = $42, 223.40 + $20. 13x y O $, y = $42, 223.40 - $86.37x O = $ 124, 796.84 + $86. 37x = O = $124, 796.84 $86.37x 23 A A1 X ft Selling Price B D E F Sq Ft Beds N Baths 1.5 2 1 1 1.5 2 2 3 2 3.5 2.5 2 2 2.5 3 3.5 2 1.5 2.5 2.5 2.5 2.5 2 2 2 3 3 3 2 3 2 3 3 3 4 3 4 NO NN Selling Price 2 160000 170000 178000 182500 195100 7 212500 8 245900 250000 20 255000 11 258000 12 267000 13 268000 14 275000 15 295000 16 325000 17 325000 18 328400 19 331000 20 344500 21 365000 22 385000 23 395000 24 399000 25 430000 26 430000 27 454000 28 29 30 31 1776 1768 1219 1568 1125 1196 2128 1280 1596 2374 2439 1470 1678 1860 2056 2776 1408 1972 1736 1990 3640 1918 2108 2462 2615 3700 4 3 4 3 4 4 3 3 4 4 4tion NNN 4 3 4 4 4 3.5