good afternoon, i need the answer of this question (excel way, with formulas)
Posted: Wed May 11, 2022 11:19 am
good afternoon, i need the answer of this question (excel way, with formulas)
Extra credit question - Maximum 12 point bonus. VII. The data below show real estate sales for houses in a neighborhood in Biloxi, Mississippi a. What is the multiple regression equation explaining the selling price of homes based upon square footage and age? b. What are the slopes and vertical intercept value in your equation. c. Explain which of the coefficients in your estimated regression equation are statistically significant at the 5% level. Price (1000s) Square Footage Age 261 1712 30 279 1840 40 280 1339 25 288 2300 18 293 2234 294 1670 30 311 2311 19 328 2377 7 335 2736 10 350 2500 1 376 2500 3 399 2479 3 405 2400 1 418 3124 0 344 2580 2 455 4060 10 477 3900 3 30
Extra credit question - Maximum 12 point bonus. VII. The data below show real estate sales for houses in a neighborhood in Biloxi, Mississippi a. What is the multiple regression equation explaining the selling price of homes based upon square footage and age? b. What are the slopes and vertical intercept value in your equation. c. Explain which of the coefficients in your estimated regression equation are statistically significant at the 5% level. Price (1000s) Square Footage Age 261 1712 30 279 1840 40 280 1339 25 288 2300 18 293 2234 294 1670 30 311 2311 19 328 2377 7 335 2736 10 350 2500 1 376 2500 3 399 2479 3 405 2400 1 418 3124 0 344 2580 2 455 4060 10 477 3900 3 30