UNSW Business School/ Economics ECON2206
Major project: House Valuations Stage Term 1, 2020 Response to request for further data
The Head of the Housing Group at CHS Consulting has responded to the request for further data. The following has been extracted from their reply:
“Housing Group thanks Management Services for assisting them to refine our project. The discussions with your staff have helped us considerably in deciding what needs to be done given the data we have available for analysis. While several of the approaches you have suggested would no doubt provide useful information, we are constrained by data availability. As such it is possible to supply some, but unfortunately not all, of the extra data that was requested by Management Services.
We have decided to undertake a pilot study using recent data for Melbourne, Victoria. As you correctly noted, there is likely to be differences across real estate markets and across different types of dwellings. But we feel that an investigation using the Melbourne data, concentrating on free standing houses is likely to provide a template for a methodology that will be transferable across markets and dwelling types. The data represent a sample of sales of houses in the Melbourne Metropolitan area during 2016. The data includes many house characteristics and importantly a selection of the largest real estate agents. By supplying these largest agents, the data includes most sales and facilitates reliable analysis by individual agents if required.
The discussion between Housing Group and Management Services recognized that valuations are not provided to the public for all houses that are put up for sale and we have complied with your request to provide data that includes all sales irrespective of whether the valuation information was available or not.
Importantly, we confirm that there are three central questions to be addressed using these data:
The Housing Group looks forward to receiving your report.”
The following steps will assist you in your approach to the project.
These data are realistic but fictious having been constructed for the sole purpose of use in teaching. Data is provided in a Stata file stored on the course webpage in the Assessment Section under Project Stage 2: valuations.dta
inner west east north stheast size carspace bathrms bedrms built cbd AA AB AC AD AE v_yes vbase pbase id Obs: 1678
A description file, valuations.des provides descriptions of each of these variables. Also, in the Project Stage 2 section is a template .do file named valtemp.do . This includes instructions on how to read the data and to produce a group-specific data file. Most of the data will be identical for everyone in the class but several key variables will be generated in valtemp.do . Extra variables price, value and accuracy will be generated by you as a function of pbase and vbase and will be specific to the group. This will mean that key regression results will vary across groups even if they perform identical analyses involving these three variables.
While this provides examiners a plagiarism check this is not the primary reason for providing the data in this form. Instead, it is an opportunity for students across groups to discuss common modelling issues without necessarily coming to the same conclusion.
Naturally you should consult your tutor or lecturer at any other time should you have any other questions regarding the project. This is best done through the online Q&A sessions or by posting a Discussion Topic.
This guided task is a key component in helping students gain some appreciation of what is involved in undertaking a basic econometric analysis.
You are only expected to use the techniques developed in lectures up until the end of week 7.
As a guide your project should be no longer than 2000 words, excluding tables and graphs. Total length including all discussion, tables and graphs should not exceed 12 pages. This is a guide and there will be no penalty for minor discrepancies. You must attach a copy of the FIRST page of your Stata log-file (do-file and relevant output) as an appendix. This first page should include the edited version of the commands in valtemp.do. where you generated your groups’ data. This page will not be included in the word or page count but failure to include this material will result in a zero grade.
Students may work in groups to conduct their analysis and complete the project. Students can choose their own groups and so there is no requirement for group members to belong to the same tutorial. Groups may be up to a maximum of 4 students and students may decide to work alone.
Attach the project assessment sheet provided in Project Stage 2 section as your first page. Check that the names and student IDs for your group members have been completed.
The project will be allocated 25 marks and will constitute 25% of the total grade for the course. The marking criteria are as follows:
ANALYSIS (14 marks)
Motivation for proposed econometric approach & models (3 marks) Characterizing key features of the data (4 marks)
Production and evaluation of econometric results (7 marks)
DISCUSSION (6 marks)
Justification of main conclusions (3 marks) Executive summary (3 marks)
MECHANICS (5 marks)
Presentation (5 marks)
For solution, connect with our online professionals.