A local real estate agent argues that house prices in Pittsburgh are related to the number of rooms in a house. You collect a random sample of 190 houses and run a simple regression using House Price (measured in dollars) as the dependent variable and Rooms (measured as the number of rooms in a house) as the independent variable. Given below is the Excel output of the regression results. (a) Construct the 99.7% confidence interval for the slope of the regression line. (b) Consider a house with 5 room. What is the probability that the house will sell for more than $270,245? (c) A savvy real estate investor, Noah, owns a house in Pittsburgh that he is planning to sell. Based on the regression put, Noah decides to destroy some walls to reduce the number of rooms in the house, hoping to increase the house selling price. Based on the regression output, do you think this is a good decision? Justify your comment.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

A local real estate agent argues that house prices in Pittsburgh are related to
the number of rooms in a house. You collect a random sample of 190 houses and run a
simple regression using House Price (measured in dollars) as the dependent variable
and Rooms (measured as the number of rooms in a house) as the independent
variable. Given below is the Excel output of the regression results.

(a) Construct the 99.7% confidence interval for the slope of the regression
line.
(b) Consider a house with 5 room. What is the probability that the house
will sell for more than $270,245?
(c) A savvy real estate investor, Noah, owns a house in Pittsburgh that
he is planning to sell. Based on the regression put, Noah decides to destroy some
walls to reduce the number of rooms in the house, hoping to increase the house
selling price. Based on the regression output, do you think this is a good decision?
Justify your comment.

 

Dependent Variable:
Independent Variable:
Regression Statistics
Summary Table
Variable
Intercept
Rooms
Fcst#1
Fcst#2
Fcst#3
House Price
Rooms
R Square
0.003
Forecasted: House Price
Coeff.
245870
-539
Rooms
1
5
10
Adj.RSqr
0.000
Std.Err.
5810
760
Forecast
245331
243175
240480
Std.Err.
26950
t Stat.
42.318
-0.709
StErrFst
27430
27070
27210
# Cases
190
P-value
0.000
0.478
Transcribed Image Text:Dependent Variable: Independent Variable: Regression Statistics Summary Table Variable Intercept Rooms Fcst#1 Fcst#2 Fcst#3 House Price Rooms R Square 0.003 Forecasted: House Price Coeff. 245870 -539 Rooms 1 5 10 Adj.RSqr 0.000 Std.Err. 5810 760 Forecast 245331 243175 240480 Std.Err. 26950 t Stat. 42.318 -0.709 StErrFst 27430 27070 27210 # Cases 190 P-value 0.000 0.478
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman