Provide a scatter plot between the variables price and sqmt

Assignment Help Econometrics
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

Reference no: EM132163856

Questions Cloud

What opportunities could help improve healthcare : Research the relationship between economic growth in Saudi Arabia and how this growth is related to providing the population a higher-quality of healthcare.
Develop an madm table with the raw data : Convert the raw data to utilities (scaled on 0 to 1). Show the utility weights in a second table.
Determine increasing marginal costs in the short run : Explain how the law of diminishing returns determine increasing marginal costs in the short run.
What is the increase in the country surplus : If the world price is $1, what is the increase in the country's surplus when it trades compared to autarky?
Provide a scatter plot between the variables price and sqmt : ECON634 Econometrics and Business Statistics Assignment, Macquarie University, Australia. Provide a scatter plot between the variables price and sqmt
Identify the employee network groups at whirlpool : Like many organizations, one of Whirlpool's strategies for creating a culture of pluralism is encouraging the formation of employee network groups.
Globalization impacting income and employment in the develop : 1. How does one see the global economy and globalization impacting income and employment in the developed world? What is the justification?
What research is required to strengthen these points : What are three arguments you could construct to prove your point? How will you prove these issues within a broader context
Does the business idea need to be changed significantly : Based on your assessment, does the business idea need to be modified, changed significantly, or abandoned?

Reviews

len2163856

11/11/2018 10:44:26 PM

This assignment is worth 30% of your ECON634 ?nal mark. You should submit this test in both print and electronic copies in week 14 by 4pm, Thursday15th. Assignment that are submitted only in one form WILL NOT be marked. You must include the signed assignment coversheet (available from iLearn). Please provide all relevant information including your name and student ID on the assignment coversheet. Use the econometric software, Eviews to obtain relevant regression outputs. All questions should be answered clearly and in your own words. All relevant working must be shown.

len2163856

11/11/2018 10:44:21 PM

Your assignment should be typed using a word-processing program (e.g. Microsoft Word) or a typesetting language (e.g. LaTeX) and saved as a PDF file. It is intended that students will work on the assignments independently. Students who submit an assignment that is substantially copied from another source may receive a mark of zero, and may be referred to the Faculty for further action. You must keep a copy of your assignment. Answer all questions clearly and in your own words. No extensions will be granted. There will be a deduction of 10% of the total available marks made from the total awarded mark for each 24 hour period or part thereof that the submission is late (for example, 25 hours late in submission – 20% penalty). This penalty does not apply for cases in which an application for Special Consideration (SC) is made and approved. Total marks [65 marks].

Write a Review

Econometrics Questions & Answers

  Design a simple econometric research project

Design a simple econometric research project

  Multiplicative decomposition method

Multiplicative decomposition method

  Market for cigarettes

The Australian government administers two programs that affect the market for cigarettes.

  Solve the forecast model

Solve the forecast model

  What are the marginal abatement cost functions

What are the marginal abatement cost functions for each of the two areas? Calculate the loss in the two areas due to over-control (for the rural area) and under-control (for the urban area).

  Write the t statistic for testing the null hypothesis

Explain why this model violates the assumption of no perfect collinearity.  Write the t statistic for testing the null hypothesis

  What is economics system

What is economics system? What are the types of economics system? Briefly explain each type of economics system by giving examples of nations that are close to each type

  Multiple choice questions related to market concentration

Determine when a competitively produced product generates negative externalities in production, the industry will,

  Calculating number of units produced by firm

Assume a company has the following production function: Q = 100 K.5 L1 . Currently, the company hires 1,000 workers and employs 100 units of capital.

  Question about mobile commerce

M-commerce also known as mobile commerce is being lumped in with several strategic internet plans. Explain some of the industries that are likely to use mobile commerce and how it is working for them.

  Calculating the average days past due and average flow time

Auto Data manufactures custom engineering testing machine. The following 5-orders are currently in the design department:

  Mechanism of an english auction and second price auction

Briefly discuss the difference between mechanism of an oral or English auction and a Vickrey or second price auction.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd