Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following model you wish to estimate by using the OLS, Price = ? + ? sqrft + ?, where price is the house

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.

image text in transcribed
SUMMARY OUTPUT Regression Statistics Multiple R 0.787906548 R Square Adjusted R Square 0.616387387 Standard Error 63.61708058 Observations 88 ANOVA SS MS F Significance F Regression 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 11.20414482 24.74260761 0.452827972 0.651812965 -37.98253022 60.39081986 X Variable 1 (sqrft) 0. 140210977 0.011816643 11.86555064 8.42341E-20 0. 116720269 0. 163701686

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

Step: 3

blur-text-image

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

Functional Analysis And The Feynman Operator Calculus

Authors: Tepper L Gill, Woodford W Zachary, Zachary Woodford

1st Edition

331927595X, 9783319275956

More Books

Students also viewed these Mathematics questions