ISSS608 2016-17 T1 Assign1 Ong Han Ying

why are you here
don't touch my page. i am watching you.

Abstract

As of Oct 2015 [1], over 80% of Singapore’s resident population lived in public housing of Singapore. In all, there are mainly 2 methods to buy a flat in Singapore, either buying a new flat, or a resale flat. Resales flats are highly sought after, due to availability at any locations, and purchases are allowed from the open market anytime. As such, prices of resales flat are highly subjected to the changes in the demand & supply in the resales market. In this analysis, we will create infographics that highlights the key trends between Q1 & 2 of 2015 and 2016 in the resales market in Singapore – to help the stakeholders to make related decisions.

Problem and Motivation

Analytical Questions

In all, this analysis will provide the answer to the following questions;

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

Infographic

In all, 2 versions of infographic are created for 2 distinct group of readers; (1) High-Level Overview : For readers who want to have a quick overview on the general trend of the re-sales flat marketss (2) :For readers who required more analysis in the re-sales flat markets to guide them to make a decision.

Version 1 : High Level Overview

To have a bigger view of the file, please click on the following thumbnail.

[[1]]

Approaches

Dataset

About the Dataset

The sources of the data are;

1. Resales Flat Price from data.gov.sg [[2]]
2. Number of Resale Applications Registered by Flat from data.gov.sg [[3]]
3. Median Resale Prices for Registered Applications by Town and Flat Type from data.gov.sg [[4]]
4. Resales Statistics from hdb.gov.sg [[5]]
5. Planning Areas of Singapore from Wikipedia [[6]]

Tools Utilised

The tools are that used are (1) Tableau 10, and (2) Microsoft Excel 2013

Reference

1. Public Housing - Singapore's Icon [[7]]