Consider the following model you wish to estimate by using the OLS, Price = α + β sqrft + ε, where price is the house price in thousands of dollars and sqrft is size of house in square feet. The OLS result from Excel is as follows (see below). Suppose the house in the sample has sqrft=3,500. Find the predicted selling price for this house from the OLS regression estimation.

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
icon
Concept explainers
Question

Consider the following model you wish to estimate by using
the OLS,
Price = α + β sqrft + ε,
where price is the house price in thousands of dollars and sqrft is size of house in square feet. The OLS result from Excel is as follows (see below).

Suppose the house in the sample has sqrft=3,500. Find the predicted selling price for this house from the OLS regression estimation.

 

SUMMARY OUTPUT
Regression Statistics
Multiple R
R Square
Adjusted R Square
0.787906548
0.616387387
Standard Error
63.61708058
Observations
88
ANOVA
df
S
MS
Significance F
Regression
1
569801.0753
569801.0753
140.7912919
8.42341E-20
Residual
86
348053.433
4047.132941
Total
87
917854.5083
Coefficients
Standard Error
t Stat
P-value
Lower 95%
Upper 95%
Intercept
X Variable 1 (sqrft)
11.20414482
24.74260761
0.452827972
0.651812965
-37.98253022
60.39081986
0.140210977
0.011816643
11.86555064
8.42341E-20
0.116720269
0.163701686
Transcribed Image Text:SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square 0.787906548 0.616387387 Standard Error 63.61708058 Observations 88 ANOVA df S MS Significance F Regression 1 569801.0753 569801.0753 140.7912919 8.42341E-20 Residual 86 348053.433 4047.132941 Total 87 917854.5083 Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Intercept X Variable 1 (sqrft) 11.20414482 24.74260761 0.452827972 0.651812965 -37.98253022 60.39081986 0.140210977 0.011816643 11.86555064 8.42341E-20 0.116720269 0.163701686
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Correlation, Regression, and Association
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE 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