ISSS608 2016-17 T1 Assign2 Agrim Gairola

ISSS608 2016-17 T1 Assign1_Agrim Gairola

Abstract

The assignment involves study of data based on a survey conducted among the faculty of two Spanish Universities on various aspects of Wikipedia. A set of 44 questions were asked from 913 members of the University on 13 different subjects of perception. The task at hand is to identify interesting patterns revealed in the survey regarding the perception of Wikipedia

Motivation

The assignment would enable us to gather interesting insights and patterns into the perception of people on Wikipedia based on its use, image, ease and several other factors.

Tools Used

• Tableau version 10.0
  
• JMP Pro
  
• Treemaps HCI
  
• Microsoft Office
  

Data Preparation

The following steps were carried out to prepare the data for effective analysis:

Approaches

• Sales trend:In order to analyse the sales trends, we plot a area chart indicating sales quarter by quarter for 2015 and first half of 2016
  
• Understanding the data:On analysis of the trend, we notice that the sales peak during the second quarter of 2015 as well as 2016. On a more general note, we also notice that the end of 2015 saw a fall in the sales of flats. However, 2016 saw an increase in the sales.
  

• Sales Trends by location: On analyzing the sales trends by locations, we notice that most of the locations follow a trend similar to the general trend.
  

• On deep-diving into this graph, we notice that the downtown Area does not follow the general trend.
  

Results

From the above graphs, the following conclusions can be made:

• We notice the highest sales of flats happens in Q2 of 2015 and the same trend is seen in 2016. Ear end bonus recieved at the financial year could be the reason behind this trend.
  
  
• The market appears to be going down at the end of the year 2015 however the overall trend shows that the market picks up in the Q2 of 2016 after seeing a drop in Q1 of 2016.
  
  

Approaches

• Geographic distribution of prices: Below is the map of Singapore with color gradients indicating the median prices. It shows the prices based on geographical location.It can be observed that most expensive flats are located in the area around the downtown area
  
  

• Relation of Resale price with Number of Stories: As can be seen from the graphic, as the number of stories go higher, the prices appear to increase. On isolating the Downtown area, it can be noted almost all high storied expensive flats are located in Downtown Core.
  

• Relation of price with flat type: As can be observed form the below figure, the highest price is garnered by Multi-generation housing. This is closely followed by Executive housing and then 5 room housing.
  

Results

From the above graphs, the following conclusions can be made:

• The most expensive flats are located around the Central Business District area. These high prices could be the reason for the sales dropping in Q2 2016 in the downtown core area as discussed in the previous section.
  
• Flats situated at higher stories garner higher prices. Most of these High storied expensive flats are located in Downtown area.
  
• The highest prices are garnered by Multi-generation housing. This is closely followed by Executive housing and then 5 room housing.
  

Approaches

• Share of Sale of Flat by number of Rooms: A large population of Singapore seems to believe that a 4 bedroom HDB suits their needs the best.
  

• Share of flat type by Location: The highest number of sales appear to be in the extreme east (Tampines) and extreme west (Jurong West) of Singapore. On cross referencing the below figure with the map in the previous section, we notice that the sale is higher in areas farther away from the downtown area.
  

• Share of property by number of stories: Contrary to the popular belief, flats at higher floors are not very popular. Most people prefer to buy flats in stories between 3-12. This could be because of the direct relation between the number of story and the prices.
  

Results

From the above graphs, the following conclusions can be made:

• 4 Room flats are the most popular types of houses among Singaporeans.
  
• The highest sales take place in Jurong west and Tampines. This is closely followed by Woodlands. We can conclude that the sales are higher in areas where the prices are lower(referring to the map in section 2) ie away from downtown area.
  
• Most Singaporeans prefer to buy flats on stories between 3-12.