ISSS608 2016-17 T1 Assign1 Frandy Eddy
Contents
Abstract
This project aims to answer the questions regarding resale flat prices in order to get some insights from the data. Some key points from the analysis:
- The sales in 2015 are dominated by 3-room, 4-room, and 5-room flat type, taking up to more than 90% of all sales.
- The distribution of price of resale public housing in 2015 is right-skewed with most observations (~25%) ranging between 350K and 400K. The lowest price is 195K and the highest price is 1088K.
- Comparing the shares of the first-half of 2015 and 2016, it is found that there is a slight increase in 4-room flat type and a slight decrease in 3-room flat type, while other types are constant.
Problem and Motivation
Having sufficient knowledge about resale flat prices, the trend, and the factors affecting the price is important for someone who wants to buy or sell a flat. Some of the key points that need to be answered includes the following:
- What are the shares of the resale public housing supply in 2015?
- What are the distribution of the resale public housing prices in 2015?
- Compare the patterns of the first-half of 2016 with the patterns of 2015
Approaches
Data Preparation
The data can be obtained from https://data.gov.sg/dataset/resale-flat-prices. As we are more interested to analyze the resale flat price in 2015 and 2016, we will use the dataset from March 2012 onwards. After connecting the data to Tableau, we need to create a calculated field to transform the "Month" from text to date format. This can be done by using DATE(LEFT([Month],4)+"-"+RIGHT([Month],2)+"-01").
Data Analysis
The analysis done are mainly focused on observing the shares of the resale public housing supply and the distribution of prices in 2015. With reference to the findings, we will then compare the patterns of 2015 with the patterns of the first-half of 2016.
Tools Utilized
Tableau is the only tool used for data preparation and analysis
Results
The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town.
By Flat Type
The sales in 2015 are dominated by 3-room, 4-room, and 5-room flat type, taking up to more than 90% of all sales.
By Flat Model
Out of all 18 flat models sales, more than 80% are from 4 flat models (Model A, Improved, New Generation, Premium Apartment).
By Flat Model and Type
4-room Model A, 5-room Improved, and 3-room New Generation are the combinations of flat type and flat model with the most number of sales in 2015.
By Town
The share of resale public housing supply is spread quite evenly among the different towns without any clear dominant towns. The highest share is only 8.1% in Jurong West.
Distribution of Resale Public Housing Prices in 2015
Price Distribution
The distribution of price of resale public housing in 2015 is right-skewed with most observations (~25%) ranging between 350K and 400K. The lowest price is 195K and the highest price is 1088K.
By Flat Model
Looking at the flat model, Type S2, Type S1, and Terrace are the models with the highest resale prices. Model A2 seems to be in the range of low resale price, while other models have quite a wide spread of range of price.
By Town
The range of resale price in most towns are widely spread. Central Area and Kallang/Whampoa has the widest spread of resale price.
First Half of 2016 vs 2015
After knowing the shares and distribution of flat prices in 2015, we also need to compare the patterns with the patterns of the first-half of 2016 to know about the trend in 2016 better. Understanding the trend could help the decision makers to make better decisions. As we only have the data for the first-half of 2016, we will do the comparison against only the first-half of 2015.
By Flat Type
There is a slight increase in 4-room flat type and a slight decrease in 3-room flat type, while other types are more or less the same.
By Town
Woodlands increased the share from 6.25% to 7.45% while Bedok decreased the share from 6.89% to 6.14%. For other towns, the share of supply didn't change a lot.
Infographic
