Difference between revisions of "ISSS608 2016-17 T1 Assign1 Frandy Eddy"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 24: Line 24:
  
 
= Results =
 
= Results =
Text
 
 
== Share of Resale Public Housing Supply in 2015 ==
 
== Share of Resale Public Housing Supply in 2015 ==
 
The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town.
 
The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town.
Line 30: Line 29:
 
[[File:2015 Flat Type.jpg]]
 
[[File:2015 Flat Type.jpg]]
  
The sales in 2015 are dominated by 3-room, 4-room, and 5-room 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 ===
 
=== By Flat Model ===
 
[[File:Flat Model.jpg]]
 
[[File:Flat Model.jpg]]
  
Out of all 18 flat models sales, more than 80% are from 4 flat models (Model A, Improved, New Generation, Premium Apartment)
+
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 ===
 
=== By Flat Model and Type ===
Line 45: Line 44:
 
[[File:Town.jpg]]
 
[[File:Town.jpg]]
  
Text
+
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 ==
 
== Distribution of Resale Public Housing Prices in 2015 ==
Line 52: Line 51:
 
[[File:Resale Price Distribution.jpg]]
 
[[File:Resale Price Distribution.jpg]]
  
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
+
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 ===
 
=== By Flat Model ===
 
[[File:Resale Price by Flat Model.jpg]]
 
[[File:Resale Price by Flat Model.jpg]]
  
Text
+
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 ===
 
=== By Town ===
 
[[File:Resale Price by Town.jpg]]
 
[[File:Resale Price by Town.jpg]]
  
Text
+
The range of resale price in most towns are widely spread.
  
 
== First Half of 2016 vs 2015 ==
 
== First Half of 2016 vs 2015 ==

Revision as of 03:01, 29 August 2016

Abstract

Abstract


Problem and Motivation

Knowing sufficient information 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 comparing the patterns of 2015 with the patterns of the first-half of 2016.


Tools Utilized

Tableau is used for data preparation and analysis


Results

Share of Resale Public Housing Supply in 2015

The share of resale public housing supply in 2015 can be observed by flat type, flat model, or town.

By Flat Type

2015 Flat Type.jpg

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

Flat Model.jpg

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

Flat Model & Type.jpg

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

Town.jpg

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

Resale Price Distribution.jpg

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

Resale Price by Flat Model.jpg

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

Resale Price by Town.jpg

The range of resale price in most towns are widely spread.

First Half of 2016 vs 2015

Text

By Flat Type

Flat Type 2015 vs 2016.jpg

Text

By Town

Town 2015 vs 2016.jpg

Text