Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course in General Relativity

Authors: Bernard Schutz

2nd edition

521887054, 978-0521887052

More Books

Students also viewed these Mathematics questions

Question

Explain why it is not wise to accept a null hypothesis.

Answered: 1 week ago

Question

What are your daily activities in this position?

Answered: 1 week ago