Home / Questions / 1) The following data give the selling price, square footage, number of bedrooms, and age of houses
1) The following data give the
selling price, square footage, number of bedrooms, and age of houses that have
sold in a neighborhood in the past 6 months. Develop
three regression models (in excel) to predict the selling price based upon each
of the other factors individually. Which of these is best?
SELLING PRICE ($)
SQUARE FOOTAGE
BEDROOMS
AGE (YEARS)
84,000
1,670
2
30
79,000
1,339
2
25
91,500
1,712
3
30
120,000
1,840
3
40
127,500
2,300
3
18
132,500
2,234
3
30
145,000
2,311
3
19
164,000
2,377
3
7
155,000
2,736
4
10
168,000
2,500
3
1
172,500
2,500
4
3
174,000
2,479
3
3
175,000
2,400
3
1
177,500
3,124
4
0
184,000
2,500
3
2
195,500
4,062
4
10
195,000
2,854
3
3
2) Use the data in Problem 1 and develop a regression model to predict selling price based on
the square footage and number of bedrooms. Use
this to predict the selling price of a 2,000-square-foot house with 3 bedrooms.
Compare this model with the models in Problem 1. Should the number of bedrooms
be included in the model? Why or why not?
Apr 27 2020 View more View Less
Timberland From Bootmaker to EarthkeeperAn iconic American brand for sixty years, Timberland has built a reputation for creating simple, durable footwear and outdoor acce...
Jul 18 2020A steel rod 2cm diameter passes through a tube 2.5cm in internal diameter and 3.5cm in external diameter the tube is 80cm long and closed on both ends by rigid washers ,...
May 16 2020Using the graph of the probability density function of an underlying population presented in Figure 5.19, determine(a) The percent probability that one randomly selected ...
Jul 26 2020Estimate the limiting bit rate for a 60-km single-mode fiber link at 1.3- and 1.55- µm wavelengths assuming transform-limited, 50-ps (FWHM) input pulses. Assume that β2 =...
Jul 29 2020Managing performance is an important—yet delicate—process for managers to undertake. They need to make tough calls at times regarding who is performing well or not. Also,...
May 13 2020Which obe of the following is not a stage develpment process of new product?A. idea sceeningB. testing cinceptC. commercializationD. gnerating
Nov 08 2017You are playing a board game with some friends in which each turn begins with rolling two dice In this game, rolling “doubles” (same number on both dice) is especially be...
May 02 2020A soil specimen has a water content of 18% and a wet unit weight of 118.5 lb/ft3. The specific gravity of solids is found to be 2.72. Find the dry unit weight, void ratio...
Aug 06 2020A Treasury STRIPS is quoted at 57.001 and has 11 years until maturity. What is the yield to maturity?
Aug 29 2020Questions - Engineering - Civil engineering - class homework assignment - set 63 Question – 1 For a rigid pile cap with vertical piles at the middle and raking piles at...
May 24 2020