Reference no: EM132163856
Econometrics and Business Statistics Assignment -
All questions should be answered clearly and in your own words.
The data file House.xlsx contains data on 1080 house prices and some other variables that may influence of house prices.
The variables are defined as follows:
price = house price, dollars.
sqmt = total living area in square meter (m2)
bdrms = number of bedrooms
age = age of house in years
Questions -
(a) Provide a scatter plot between the variables price (Y axis) and sqmt (X axis) and comment on your plot.
(b) Estimate the following linear regression model and interpret the estimate of β2? Provide your regression output.
pricei = β1 + β2sqmti + ei
(c) Does an increase in the total living area by one square meter increases the expected price of a house by more than 900 dollars? Test the hypothesis at the 1% significance level.
(d) Construct a 99% confidence interval for the coefficient of sqmt. Interpret this interval.
(e) Estimate the following regression model using Eviews and write down the regression equation including standard errors, t-statistics, R-squared, F-statistics and the sample size.
pricei = α1 + α2 sqmt + α3 age + α4 bdrms + ∈i
(f) Write down the coefficient of determination and interpret it.
(g) Interpret the estimates of α3 and α4. Are the signs of these two estimates consistent with your expectation? Why/Why not?
(h) Test if each coefficient is significantly different from zero. Use the 5% significance level. (Critical value from EXCEL = T.INV.2T(0.05,1076)).
(i) Using the 5% significance level test the overall significance of the model. (=F.INV(0.95,3,1076)).
(j) Compute and interpret the elasticity of price with respect to sqmt for a home that is 250 square meters large, 15 years old, and has two bedrooms.
(k) At a 5% significance level test for the existence of heteroskedasticity using a White test (no cross terms). State all steps in conducting a hypothesis test for heteroskedasticity and attach your Eviews output.
(l) Re-estimate your model in question (e) with white consistent standard errors and provide your output. What changes would you notice when compare with the regression output you obtained in question (e).
(m) Compare the two models you estimated in question (b) and question (e). Choose a preferred model. Explain why?
Attachment:- Assignment & Data File.rar