Questions

Q1. How many observations are there in the raw dataset? How many variables are there?

Q2. Produce a table of summary statistics for all the variables included in the raw dataset. For the two variables, area per square meter and distance in km to the CBD, what are their means and standard deviations?

Q3. Produce a table of correlation coefficients for all the variables in the raw dataset. What is the correlation between the area per square meter and the transaction price? Produce a scatter plot for these two variables. What is the correlation between the area per square meter and the number of units? Also produce a scatter plot for these two variables. Provide some brief reasoning to rationalize the correlations; there are no definite answers—you earn points as long as your arguments make logical sense.

Q4. Take 1995 as the base year. Create 6 dummy variables for properties transacted in the years 1996, 1997, 1998, 1999, 2000, and 2001, respectively. Provide summary statistics for these 6 variables. How many % of transactions occurred in 1998?

Q5. Run a standard level-level regression. The regression model is Pit = Xitβ + εit, where the subscripts t and I indicate the transaction year and individual property, respectively. Interpret the coefficient estimates of floor area and freehold.

Q6. Run a standard semi-log regression. The regression model is ln(Pit) = Xitβ + εit, where the subscripts t and I indicate the year and individual property, respectively. Interpret the coefficient estimates of floor level and distance to MRT. What is the R2 value? What is the adjusted R2 value?

Q7. Repeat the regression in Q6, but this time, include the 6-year dummy variables in the regression function. What is the R2 value? What is the adjusted R2? Is it worthwhile to include these year dummy variables in the regression function, for the purpose of improving goodness of fit? Interpret the coefficient estimates of the year 1998 dummy variable. Did Asian Financial Crisis strike Singapore’s private housing market?

Q8. Create a period dummy variable “Period 2” whose value is one if the property was sold between 1998-2001 and zero if it was transacted during 1995-1997. Create the interaction term between Period 2 and distance in CBD. Repeat the regression in Q6, but this time, include the Period 2 dummy variable and the interaction term as the additional explanatory variables in the regression. Also, interpret the property value with respect to the distance to CBD during 1998-2001. Was the price gradient of CBD in 1998-2001 flatter than that in 1995-1997?

Take professional academic assistance & Get 100% Plagiarism free papers
Get A Free Quote

QUALITY: 100% ORIGINAL – NO PLAGIARISM

(USA, AUS, UK & CA PhD. Writers)

CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS

The Best Custom Essay Writing Service

About Our Service

We are an online academic writing company that connects talented freelance writers with students in need of their services. Unlike other writing companies, our team is made up of native English speakers from countries such as the USA, UK, Canada, Australia, Ireland, and New Zealand.

Qualified Writers

Our Guarantees:

CLICK TO SUBMIT YOUR ORDER