ISSS608 2016-17 T1 Assign1 Abhinav Ghildiyal

Abstract

Singapore has a land mass of 719.1 square km with over 6 million people, and this is the reason why Singapore is one of the worlds most expensive housing market. Singapore residential property falls into 2 categories : Public housing (HDB flats) and Private Housing (Condominiums, Landed property and Executive Condominiums). In this write up we will discuss over the resale pricing of the Public Housing and we will try to analyse the price variation over the years based on different underlying factors such as flat type, month, flat model etc.

Problem and Motivation

This write-up will be a help for buyers/sellers to observe, analyse and decide the following concerns:

1. When to buy/sell the property?
2. Which flat type to buy/sell?
3. Which flat model to buy/sell?

Tools Used

Tableau
JMP Pro
MS Excel

Approach

I have taken the data from the data.gov.sg website (the government`s one stop portal to its publicly-available data sets from 70 public agencies) and used different visualsing tools to make the infograhics and deduce the concerns mentioned above. The first step here is to determine whether there is any significant difference between the means of the different flat types, because here I am using the sample of flat type and the number of resale application to analyse the variation.

Notice that the flat_types do not spread uniformly across the horizontal axis. The dot plot of flat_types = 4 - room indicates that there are many more no_of_resale_applications than the other 5 flat_types, whereas the dot plot of flat_types = 1 – room indicates that it has the lowest no_of_resale_applications.