Quantitative Methods (M), (UAC) & (H) Semester 2, 2023
Quantitative Methods (M), (UAC) & (H) Semester 2, 2023
Major Project
Project Instructions
The project is separated into 3 interrelated tasks. All 3 tasks are due at the same time and should be prepared as a single report. You have a one-month duration to finish this major assignment. The deadline for the final report is Monday, 6th November, at 5pm Adelaide time (GMT +09:30). For students with an access plan, the extended deadline is Saturday, 11th November, at 5pm Adelaide time (GMT +09:30).
Please submit your reports online via MyUni by uploading a single file in Microsoft Word format (either .doc or .docx) through the Assignments tab and associated link. If your assignment is late, please email it to Xiaohui (xiaohui.liu@adelaide.edu.au) and Ethan (ethanloyalty@gmail.com) personally Do not submit via MyUni if your assignment is late.
Tasks 1, 2 and 3 most closely relate to Topics 2, 8 and 9 as detailed in the course outline.
This is an individual project (you can discuss it with other students but everyone needs to make an individual report submission).
The project comprises 50% of your final Quantitative Methods (M) grade. The Grading Rubric is also available on MyUni, giving additional detail on the assessment breakdown:
Headline Regression Model Derivation10%
Task 1: Data Summary20%
Task 2: Regression Model Build and Use40%
Task 3: Regression Model Evaluation20%
Report Structure and Written Presentation Quality10%
Your final report will be processed through Turnitin (including Turnitins AI writing indicator) as a check for plagiarism so please ensure that you only present your own work. In addition, your final report needs to meet all of the following criteria:
Font:Times New Roman
Font size:12 point
Page margins:2.54cm all around (Normal)
Page Limit:8 pages only (A4, single sided). The page limit should not be exceeded for any reason (i.e., not for appendices, raw data, STATA coding)
Appropriate font, font size, page margins, and page limit are all graded against Report Structure and Written Presentation Quality (10%).
Further Advice:
In total, your title, table of contents, and a short introduction should take 1 page (max).
Ensure your report is free from spelling and grammatical errors.
Ensure your report is clear and well-structured.
Ensure your report is written in context and answers questions in context.
Make sure it is clear which model is your Headline Regression Model (Final answer)
Junction is a small town with two suburbs. The data file Major Project Data Set contains data on 535 houses sold in Junction between 2018 and 2023. This data includes the price at which the house was sold, which of two agents sold the house: Big Block (B&B) or Rapid Realty (R&R) (all houses are sold through an agent by law), the year in which the house was sold as well as data on various characteristics of each house sold (age, size, number of stories etc.). These characteristics serve as possible explanatory variables of sale price.
Data definitions follow:
OBS = observation
AGE = age of house in years
SHOPS = 1 if house is close to a shopping precinct, 0 otherwise
CRIME = crime rate of the suburb within which the house is located
TOWN = distance in kilometres to the town centre
STORIES = number of dwelling stories
OCEAN = 1 if house has an ocean view, 0 otherwise
POOL = 1 if house has a pool, 0 otherwise
PRICE = price at which the house was sold (in dollars)
AGENT = selling agent B&B (0) or R&R (1)
SIZE = size of the house in square metres
SUBURB = Mayfair (0) or Claygate (1)
TENNIS = 1 if house has a tennis court, 0 otherwiseSTUDY = 1 if house has a separate study room, 0 otherwise
SOLD = year of last sale (2018 to 2023)
Your tasks
Task 1 20% of project grade (recommended length: 2 pages)
You are required to provide a comprehensive summary of the data set contained in the Major Project Data Set file. How you choose to do this is entirely at your discretion. However, it is recommended that you consider using both summary statistic and graphical methods while also noting any peculiarities within the data set.
Task 2 (including Headline Regression Model) 50% of project grade (recommended length: 3 pages)
You have been hired by Jessica, the wealthy owner of a house on Elm Street in Junction (not included in the data set) to predict the price at which her house will sell. Her house has two stories, is in Mayfair, is 172 square metres large, is not near a shopping precinct and is 16 km from the town centre. She estimates that the house is about 8 years old and in a low crime area according to her experiences. Jessica inherited the house from her uncle and is therefore unsure when it was last sold. Some other features of the property can be seen below:
You are expected to build a regression model of house prices. In doing so, make sure that you use an appropriate number of predictors to develop your estimates. Once you have constructed an appropriate model, use it to obtain and provide for Jessicas house:
A point prediction of the sales price which it can be expected to fetch
Find and interpret a 95% prediction interval for this sale price
An estimate of the marginal effect of house size on this sale price
Financial advice on whether Jessica should use B&B or R&R to sell her house. B&B charges a commission of 2.4% whereas R&R charges a commission of 3.1% of the final sale price.
Jessica, who claims to have some knowledge of regression analysis, has stressed that she thinks you should use a regression model with an R2 of at least 88%.
Note: Task 1 directed you to take note of any peculiarities in the data set. There are other additional errors in the data set that you may not have picked up on in Task 1. These will only become clear to you once you start working on Task 2. Several problems can result if you fail to handle these issues correctly, so be mindful to address them, both in your regression application as well as your final report. If resolving any of the errors in the dataset requires you to make assumptions, make sure to clearly state your reasoning and approach in your report.
Task 3 20% of project grade (recommended length: 2 pages)
Please provide a reflective discussion on how you executed Task 2 of the project above. Specifically consider the following:
Verify that your regression model does not suffer from any misspecification errors and provide the relevant regression diagnostics which support your findings.
If you found that your model is in fact partially misspecified in part (1) of Task 3 above, explain what you did to ensure that the misspecification only has a minimal impact on your results in Task 2 above. That is, explain how you corrected any misspecifications that occurred during your modelling.
Were there any other oddities in the data set or your model? Explain.
Is there anything else worth mentioning which is relevant to your work or to your results for Jessica?
