ISSS608 2016-17 T1 Assign1 WEI Jingxian

Abstract

Problem and Motivation

Public housing is an icon of Singapore, and HDB flats are home to over 80% of Singapore's resident population (ref). However, sometime it is not easy for resident to apply flats due to financial or other problems. The resale flat is a good choice for these resident. We purpose to provide a clear view of resale flats for residents who are interested in resale flats and help them in making decisions. The dataset we used is from HDB. resale-flat-price

There are two key variables related to resale flats market, including supply and price. For people who want to buy a flat, the essential factor they concern about is price. Also, apart from price, people would also care about locations of flats. Therefore, we would like to show insights for following three aspects.

How many resale flats are selling in 2015?: 1. The supply for different flat types; 2. The supply for different flat model; 3. The supply in different location; 4. The trend of supply in 2015

What is resale flats price in 2015?: 1. Price distribution; 2. Price and floor area for different flat type; 3. Price in different locations; 4. Price fluctuation by locations

Comparison between the first-half of 2016 and 2015.: 1. Supply of resale flats; 2. Supply changes by flat types; 3. Price distribution by flat types; 4. Price changes by locations

Approaches

Data Preparation

There are ten variables in the dataset, including registration date, flat information, and flat price. The sample data has shown below. Noticed that the date variable Month is treated as string in Tableau, so we need to use the formula below to calculate a new variable Date, which is in date format in Tableau, so that we can use the variable to do further analysis.

The time period of the dataset is from March 2012 to March 2016. But we only focus on the 2015 and 2016. Thus, before our analysis, we need to filter out the data before 2015.

Supply of Resale Flats in 2015

First of all, we check the overall supply of different flat types in 2015. There are seven types of flats, including 1 to 5 room, executive and multi-generation. The top three types, which have higher supply, are 4 room, 3 room and 5 room. The percentage of supply for 4 room and 3 room already exceeds half of total resale flats supply. In addition, the total amount of these three types account for 91.52%.

Based on the types of flat, there is a more specific category called flat model. The following chart shows the percentage of flat models in each flat type.

For 1 room, there is only one model called Improved available. Also for multi-generation, there is only one model. For 2 room, almost half of the model is Standard, while the main model for 3 room is New generation. More than half of the 4 room supply is Model A. The most concentrated model distribution appears in 5 room, and 71.6% of 5 room supply is Improved model.