An empirical study is done on estimating the value of the houses in a city based on the following underlying factors: Price= Value of the house (in *1000 Dollars) otsize=Size of the property lot (in acres) Bedroom3 Unit number of bedrooms of a house Bathroom= Unit number of bathrooms in a house Driveway= A binary variable specifying if "Driveway=1" the house has a driveway, and if "Driveway=0" otherwise Garage= A binary variable specifying if "Garage=1" the house has a single-door garage, and if "Garage=0" otherwise A statistician has reviewed a database of 1000 records of houses sold in the city, and has come up with the following regression equation, to try to find a elationship among variables: Price(i)=B0 + B1[Lotsize(i)] + B2[Bedroom(i)] + B3[Bathroom(i)] + B4[Driveway(i)] + B5[Garage(i)] +u(i) A. By reviewing the result of GRETL outcomes in the attachment, perform a hypothesis test to verify the validity of all slope coefficients, collectively. Show the teps of the deployed hypothesis method. 3. Test if both Driveway & Garage need to be jointly included in the model as important variables in estimating the price of the houses in the city. Make sure ye vrite down all necessary equations & steps required. Show your calculations.

ENGR.ECONOMIC ANALYSIS
14th Edition
ISBN:9780190931919
Author:NEWNAN
Publisher:NEWNAN
Chapter1: Making Economics Decisions
Section: Chapter Questions
Problem 1QTC
icon
Related questions
Question

3) 

An empirical study is done on estimating the value of the houses in a city based on the following underlying factors:
Price= Value of the house (in *1000 Dollars)
Lotsize=Size of the property lot (in acres)
Bedroom= Unit number of bedrooms of a house
Bathroom= Unit number of bathrooms in a house
Driveway= A binary variable specifying if "Driveway=1" the house has a driveway, and if "Driveway=0" otherwise
Garage= A binary variable specifying if "Garage=1" the house has a single-door garage, and if "Garage=0" otherwise
A statistician has reviewed a database of 1000 records of houses sold in the city, and has come up with the following regression equation, to try to find a
relationship among variables:
Price(i)=B0 + B1[Lotsize(i)] + B2[Bedroom(i)] + B3[Bathroom(i)] + B4[Driveway(i)] + B5[Garage(i)] +u(i)
A. By reviewing the result of GRETL outcomes in the attachment, perform a hypothesis test to verify the validity of all slope coefficients, collectively. Show the
steps of the deployed hypothesis method.
B. Test if both Driveway & Garage need to be jointly included in the model as important variables in estimating the price of the houses in the city. Make sure you
write down all necessary equations & steps required. Show your calculations.
Transcribed Image Text:An empirical study is done on estimating the value of the houses in a city based on the following underlying factors: Price= Value of the house (in *1000 Dollars) Lotsize=Size of the property lot (in acres) Bedroom= Unit number of bedrooms of a house Bathroom= Unit number of bathrooms in a house Driveway= A binary variable specifying if "Driveway=1" the house has a driveway, and if "Driveway=0" otherwise Garage= A binary variable specifying if "Garage=1" the house has a single-door garage, and if "Garage=0" otherwise A statistician has reviewed a database of 1000 records of houses sold in the city, and has come up with the following regression equation, to try to find a relationship among variables: Price(i)=B0 + B1[Lotsize(i)] + B2[Bedroom(i)] + B3[Bathroom(i)] + B4[Driveway(i)] + B5[Garage(i)] +u(i) A. By reviewing the result of GRETL outcomes in the attachment, perform a hypothesis test to verify the validity of all slope coefficients, collectively. Show the steps of the deployed hypothesis method. B. Test if both Driveway & Garage need to be jointly included in the model as important variables in estimating the price of the houses in the city. Make sure you write down all necessary equations & steps required. Show your calculations.
Model 1: OLS, using observations 1-1000
Dependent variable: Price
Coefficient
220.811
р-value
<0.0001
Std. Error
t-ratio
const
20.7986
10.62
***
Lotsize
25.4680
3.39600
7.499
<0.0001
***
Bedroom
71.6632
6.23813
11.49
<0.0001
***
Bathroom
107.263
29.9542
3.581
0.0004
***
Driveway
Garage
56.0177
4.30062
13.03
<0.0001
***
129.560
14.7707
8.771
<0.0001
***
Mean dependent var
Sum squared resid
R-squared
F(5, 994)
Log-likelihood
Schwarz criterion
S.D. dependent var
S.E. of regression
Adjusted R-squared
P-value(F)
Akaike criterion
214.3293
172.0604
607.1195
29427162
0.358761
0.355536
111.2249
2.22e-93
-6563.775
13139.55
13169.00
Hannan-Quinn
13150.74
Model 2: OLS, using observations 1-1000
Dependent variable: Price
Coefficient
354.158
р-value
<0.0001
Std. Error
t-ratio
const
20.8757
16.97
***
Lotsize
17.2130
3.76947
4.566
<0.0001
***
Bedroom
84.2032
6.97121
12.08
<0.0001
***
Bathroom
140.918
33.2109
4.243
<0.0001
***
Mean dependent var
Sum squared resid
R-squared
F(3, 996)
Log-likelihood
Schwarz criterion
S.D. dependent var
S.E. of regression
Adjusted R-squared
P-value(F)
Akaike criterion
607.1195
214.3293
37387258
193.7457
0.185305
0.182851
75.51446
5.16e-44
-6683.481
13374.96
13394.59
Hannan-Quinn
13382.42
SSRUnrestricted)/q
(SSRrestricted
SSRunrestricted/(n
F =
kunrestricted
1)
Or:
(R²,
R² restricted)/9
unrestricted
(1 – R².
unrestricted)/(n – kunrestricted
- 1)
Transcribed Image Text:Model 1: OLS, using observations 1-1000 Dependent variable: Price Coefficient 220.811 р-value <0.0001 Std. Error t-ratio const 20.7986 10.62 *** Lotsize 25.4680 3.39600 7.499 <0.0001 *** Bedroom 71.6632 6.23813 11.49 <0.0001 *** Bathroom 107.263 29.9542 3.581 0.0004 *** Driveway Garage 56.0177 4.30062 13.03 <0.0001 *** 129.560 14.7707 8.771 <0.0001 *** Mean dependent var Sum squared resid R-squared F(5, 994) Log-likelihood Schwarz criterion S.D. dependent var S.E. of regression Adjusted R-squared P-value(F) Akaike criterion 214.3293 172.0604 607.1195 29427162 0.358761 0.355536 111.2249 2.22e-93 -6563.775 13139.55 13169.00 Hannan-Quinn 13150.74 Model 2: OLS, using observations 1-1000 Dependent variable: Price Coefficient 354.158 р-value <0.0001 Std. Error t-ratio const 20.8757 16.97 *** Lotsize 17.2130 3.76947 4.566 <0.0001 *** Bedroom 84.2032 6.97121 12.08 <0.0001 *** Bathroom 140.918 33.2109 4.243 <0.0001 *** Mean dependent var Sum squared resid R-squared F(3, 996) Log-likelihood Schwarz criterion S.D. dependent var S.E. of regression Adjusted R-squared P-value(F) Akaike criterion 607.1195 214.3293 37387258 193.7457 0.185305 0.182851 75.51446 5.16e-44 -6683.481 13374.96 13394.59 Hannan-Quinn 13382.42 SSRUnrestricted)/q (SSRrestricted SSRunrestricted/(n F = kunrestricted 1) Or: (R², R² restricted)/9 unrestricted (1 – R². unrestricted)/(n – kunrestricted - 1)
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Multiple Equilibria
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
ENGR.ECONOMIC ANALYSIS
ENGR.ECONOMIC ANALYSIS
Economics
ISBN:
9780190931919
Author:
NEWNAN
Publisher:
Oxford University Press
Principles of Economics (12th Edition)
Principles of Economics (12th Edition)
Economics
ISBN:
9780134078779
Author:
Karl E. Case, Ray C. Fair, Sharon E. Oster
Publisher:
PEARSON
Engineering Economy (17th Edition)
Engineering Economy (17th Edition)
Economics
ISBN:
9780134870069
Author:
William G. Sullivan, Elin M. Wicks, C. Patrick Koelling
Publisher:
PEARSON
Principles of Economics (MindTap Course List)
Principles of Economics (MindTap Course List)
Economics
ISBN:
9781305585126
Author:
N. Gregory Mankiw
Publisher:
Cengage Learning
Managerial Economics: A Problem Solving Approach
Managerial Economics: A Problem Solving Approach
Economics
ISBN:
9781337106665
Author:
Luke M. Froeb, Brian T. McCann, Michael R. Ward, Mike Shor
Publisher:
Cengage Learning
Managerial Economics & Business Strategy (Mcgraw-…
Managerial Economics & Business Strategy (Mcgraw-…
Economics
ISBN:
9781259290619
Author:
Michael Baye, Jeff Prince
Publisher:
McGraw-Hill Education