ISSS608 2016-17 T1 Assign1 Li Dan

ISSS608 2016-17 T1 Assign1 Li Dan

Abstract

This project presents the historical HDB resale price index showing a big picture of Singapore public housing resale market, and focuses on analyzing the market condition of 2015 and 2016 to give a general guidance to intended HDB flats buyers.

Problem and motivation

Housing and Development Board (HDB) makes homes affordable to everyone in Singapore. However, if a Singaporean or PR wants to buy HDB flats, the key fact and analysis information is not easily accessible as they spread cross websites such Data.gov.sg, SRX and propertyguru. This report aims to analyze and present key facts and statistic analysis of Singapore public housing resale market, which allows intended HDB flats buyers to gain a general idea of HDB flats resale market condition.

-
 

Tools Used

Tableau version 10.0

Approaches

• The big picture:
  

The Resale Price Index (RPI) is an indicator of overall price trend of HDB flats resale market. Previously, RPI is calculated using flat type, flat model as well as location. From 4th quarter of 2014 onwards, the computation method of RPI is modified to further include the attributes of flat structures (storey, height, age) and micro location (closeness to MRT/Plaza).

For the latest 10 years’ period, HDB RPI saw an increase from 74.9 to 149.4 before 2013 Q2, followed by a slip to 134.7 at 2016 Q1. Though with the drop in recent 3 years, there was an average of 1.6% increase each quarter for the whole plotted period. Also note that the RPI experienced less fluctuation in from 2012 to 2016.

• Understanding the data:
  

The various dimensions used in the data set needs to be recorded. This can be easily achieved with appropriate visualization tools. Then we make a note on the different parameters we wish to study and the suitable graphical representation for each case. For instance, Histograms and Box plots could be used to study the Distribution of continuous data types such as prices.

• Analysis:
  

The data set is imported to the tool and Visual infographics are extracted for each case. With this we note our key observations and compare patterns.