Difference between revisions of "ISSS608 2016-17 T1 Assign2 XI QIUYUN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
=Abstract= | =Abstract= | ||
We all know that US stock market is one of the biggest markets in the world. In that market, there are many companies, of course, it will have better companies and terrible companies. So we can observe these listed companies from their financial index or fundamental value. Based on these data, analyse these data, find some interesting things and finally we can have some conclusions about US listed companies. | We all know that US stock market is one of the biggest markets in the world. In that market, there are many companies, of course, it will have better companies and terrible companies. So we can observe these listed companies from their financial index or fundamental value. Based on these data, analyse these data, find some interesting things and finally we can have some conclusions about US listed companies. | ||
| − | Problem | + | =Problem= |
| + | *What’s the most important or common indicators of a company? | ||
| + | *What’s the correlation between those common indicators? | ||
| + | *How the values of common indicators changed in different years? | ||
| + | *What’s the difference among companies with the same indicators? | ||
| + | *Are there existing some unique companies? | ||
| + | =Approaches= | ||
| + | ===Data preparation=== | ||
| + | Through splitting the original table, I split “indicators” row to columns by every year. Then calculate the number of indicators of every company in each year. | ||
Revision as of 20:13, 25 September 2016
Abstract
We all know that US stock market is one of the biggest markets in the world. In that market, there are many companies, of course, it will have better companies and terrible companies. So we can observe these listed companies from their financial index or fundamental value. Based on these data, analyse these data, find some interesting things and finally we can have some conclusions about US listed companies.
Problem
- What’s the most important or common indicators of a company?
- What’s the correlation between those common indicators?
- How the values of common indicators changed in different years?
- What’s the difference among companies with the same indicators?
- Are there existing some unique companies?
Approaches
Data preparation
Through splitting the original table, I split “indicators” row to columns by every year. Then calculate the number of indicators of every company in each year.
