ISSS608 2016-17 T1 Assign1 Franky Eddy

Abstract

Place to stay is one of basic human needs. HDB is one of the most frequently chosen place to stay. In considering which flat they wanted to buy, there are few questions that usually comes to their minds:

• What are the shares of resale public housing supply?
• How is the distribution of resale public housing prices?
• How is the comparison between patterns of this year and last year?

To answer these questions, data visualization is used to get insights:

• 3-room, 4-room, and 5-room flat made up more than 90% of all sales
• Most of the flats' price are from 300k to 450k
• Decrease in percentage of sales of 3-room flat from 2015 to 2016

Problem and Motivation

For someone who wanted to buy or sell a flat, there are several things that they usually wanted to know. The following are the questions that usually comes to their minds when considering to buy or sell a flat:

• What are the shares of the resale public housing supply in 2015?
• What are the distribution of the resale public housing prices in 2015?
• With reference to the findings, compare the patterns of the first-half of 2016 with the patterns of 2015.

Approaches

Getting the Data

The first thing to do is getting the data. The data is downloaded from data.gov.sg, the national data portal of Singapore. The data that will be used is Resale Flat Prices data from March 2012 onwards. https://data.gov.sg/dataset/resale-flat-prices

Data Preparation

After getting the data, the next step is exploring and preparing the data so that further analysis can be done. After exploring the data, it is known that the variable month is in text format instead of number. Therefore, a new formula is created to change the month from text to number. The formula for changing the month is DATE(LEFT([Month],4)+"-"+RIGHT([Month],2)+"-01"). Other variables are already in correct format. Therefore, no changes made to other variables.

Analysis

After exploring and preparing the data, analysis of the data can be done by using Tableau 10.0. The analysis mainly consists of 3 parts which are answering the questions that usually comes to their minds when considering to buy or sell a flat.

Tools Utilized

The only tool used is Tableau 10.0.

Results

There are 3 results from the analysis:

Shares of The Resale Public Housing Supply in 2015

Flat Model

From the graph, it can be seen that out of 18 different flat models, there are 4 flat models that contributes to up to 80% of all sales. They are: Model A (29.35%), Improved (26.15%), New Generation (17.51%), and Premium Apartment (8.91%).

Flat Type

Based on the graph, it can be seen that 3 room (28.02%), 4 room (40.16%), and 5 room (23.34%) flat type made up more than 90% of all sales.

Distribution of Area

From the distribution of area, it is known that Jurong West (8.102%) and Tampines (7.366%) are the area with most sales while Bukit Timah is the lowest sales area with only less than 1% of all sales.

Distribution of The Resale Public Housing Prices in 2015

Resale Price Distribution in 2015

From the distribution of the resale price, it can be seen that most of the flats' price are ranging from 300k to 450k.

Resale Price by Flat Type in 2015

From this graph, it can be seen that the resale price of 1 room and 2 room flat type is very low (<300k) compared to other flat types while Executive type's resale price is the highest (400k to 1000k). It can also be seen that the 3 room flat type has widest range of price (from 200k to 1050k).

Resale Price by Flat Model in 2015

It can be seen from the graph that Type S1, Type S2, and Terrace are the flat model with highest resale price. The standard and Improved flat model have a wide range of price (from 200k to >900k). Model A2 and Simplified model has the lowest resale price.

Comparison of The Patterns of The First-Half of 2016 with The Patterns of 2015

Comparison of Flat Type

From this graph, it can be seen that the sales of the flat type from 2015 to 2016 is quite similar with 4 room flat type still dominating the market with more than 40% of all sales. It can also be seen from the graph that for 3 room flat type, there is a decrease in percentage of sales from 2015 to 2016.

Comparison of Flat Model

From the comparison graph, it can be seen that Model A has the most sales in 2015 and 2016. Model A even increases about 2.5% in terms of percentage of sales from 2015 to 2016.

Infographic

The infographic that summarizes all the results and findings can be seen below.