Group12 Overview
|
|
|
|
|
|
Contents
Background
Stock Market
China Stock Market
Motivation
With the background knowledge in mind, our team would like to create an exploratory model that showcases these complex relationships of Singapore's CPI, exchange rates, import and export pricing throughout the years (1990-2017) visualized on the world map. Time-series visualization techniques would also be adopted to look for hidden data trends for analysis.
There are several reasons why we found this project interesting:
- Closer to our daily standards of living, we wanted to understand what are the existing factors that can impact a country's CPI and subsequently its impact on its citizens.
- One of the potential factors that impact CPI, we wanted to look at how exchange rates work in Singapore's context and how they are used to Singapore's advantage when trading with the country's trading partners.
- Since Singapore is heavily dependent on its imported consumer goods, we also wanted to investigate how import and export pricing works as a whole, as well as its involvement as a moving part of a country's full economic system.
- As an overall conclusion, we know that the above economic indicators are highly related and would like to combine them to receive any data insights in terms of time period trends.
Even though Singapore is a relatively young country, it is able to provide rich data to help us explore these interesting observations.
Objectives
1. Provide interactive platform to illustrate the relationship between Singapore's exchange rate information, Consumer Price Index and Import and Export markets.
2. Discover data insights using visualization and interactivity that cannot be easily represented using raw data.
3. Make use of freely available Singapore economic data to arouse the interests of potential viewers and increase their curiosity on our trading relationships with the country's important trading partners.
Data Source
The consumer price index data is extracted from data.gov.sg in a monthly format which reveals the figures from January, 1961 to August,2017, while the index reference period is 2014. The data has overall index represents changes in the price level of the whole basket with all items considered, and can also be drilled down to sub-indices and sub-sub-indices for different categories and sub-categories of goods and services.
The COE data can be gained from a third-party website which contains the COE bidding price since 1990, and showcases the premiums in each month by different categories of vehicles.
Singapore MAS Exchange Rate Data can be retrieved from Singapore MAS website, and showcases denominations of S$ per 100 of selected foreign currencies. The data set can be obtained in weekly and monthly format from the year 1988-2017.
Singapore import/export statistic dataset is downloaded from CEIC database and sourced by International Enterprise Singapore & Department of Statistics. The dataset contains monthly import & export value by commodity section from 1964 to 2017.
In order to align with other datasets used in this project, the data before 1990 will be excluded from the list.
Analysis Methods
Exploratory Analysis
We will explore the different trends of time-series data provided by the various economic data sets (Period cyclicity and seasonality). Different interactions of identified attributes might provide certain data insights that we can use for our analysis.
Explanatory Analysis
Relationships between our data will be explained based on our understanding of possible real-world events or causes. For example, we might be able to explain the difference in import and export prices between the months of June and December due to the holiday seasons causing an increase of demand for turkey in December.
Predictive Analysis
Due to the repeating nature of cyclic and seasonal time-series data, we can use the identified trends to predict the various CPI index values for future dates.
Application
References
2. https://secure.mas.gov.sg/msb/ExchangeRates.aspx
3. https://insights-ceicdata-com.libproxy.smu.edu.sg/Untitled-insight/views
