Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need to know how to do it on excel. Thank you Selling Price Baths Sq Ft Beds 160000 1,5 1776 3 170000 2 1768
I need to know how to do it on excel.
Thank you
Selling Price Baths Sq Ft Beds 160000 1,5 1776 3 170000 2 1768 3 178000 1 1219 3 182500 1 1568 2 195100 212500 245900 250000 255000 258000 267000 5223222 1,5 1125 3 1196 2 2128 3 1280 3 1596 3 2374 4 2439 3 268000 2 1470 4 275000 2 1678 4 295000 2,5 1860 3 325000 3 2056 4 325000 3,5 2776 4 328400 2 1408 4 331000 1,5 1972 3 344500 2,5 1736 3 365000 2,5 1990 4 385000 2,5 3640 4 395000 2,5 1918 4 399000 2 2108 3 430000 2 2462 4 430000 2 2615 4 454000 3,5 3700 4 House Prices. Spring is a peak time for selling houses. The file SpringHouses contains the selling price, number of bathrooms, square footage, and number of bedrooms of 26 homes sold in Ft. Thomas, Kentucky, in spring 2018 (realtor.com website). a. Develop scatter plots of selling price versus number of bathrooms, selling price versus square footage, and selling price versus number of bedrooms. Comment on the relationship between selling price and these three variables. b. Develop an estimated regression equation that can be used to predict the selling price given the three independent variables (number of baths, square footage, and number of bedrooms). c. It is argued that we do not need both number of baths and number of bedrooms. Develop an estimated regression equation that can be used to predict selling price given square footage and the number of bedrooms. d. Suppose your house has four bedrooms and is 2650 square feet. What is the predicted selling price using the model developed in part c. e. Use the F test to determine the overall significance of the relationship. What is your conclusion at the .05 level of significance? f. Use the t test to determine the significance of each independent variable. What is your conclusion at the .05 level of significance?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started