ISSS608 2016-17 T1 Assign1 Franky Eddy

Abstract

Abstract

Problem and Motivation

The following are the questions that are needed to be answered:

• What are the shares of the resale public housing supply in 2015 (at least three observation),
• What are the distribution of the resale public housing prices in 2015 (at least three observation), and
• 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.

Analysis

After exploring and preparing the data, analysis of the data can be done by using Tableau 10.0.

Tools Utilized

The only tool used is Tableau 10.0.

Results

There are 3 results:

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 there are 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)

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

Comparison of Flat Type

Comparison of Flat Model