ISSS608 2016-17 T1 Assign2 Kee Bei Jia

From Visual Analytics and Applications
Revision as of 22:52, 25 September 2016 by Beijia.kee.2015 (talk | contribs)
Jump to navigation Jump to search

The data set selected is the Stocks Data. And software used is JMP. I tried tableau but my laptop kept hanging as the data set is too big. The data consist of indicators from 2011 to 2016. Indicators ranges from: Cash-flow to profit and loss to stock equities.

First of all, the data is transposed to have the dates and values flipped from columns to rows and vice versa; using the stacked function. Then the data is removed of all null values from the value column. Next, the data is transposed again using the split function, to have the indicators ids and values.

  • DeleteData.jpg

    Caption1

  • Final data.jpg

    Caption2

Then, using graph builder the following graph is constructed.

From the box and whiskers plot, we can see that

Retrieved from ‘https://wiki.smu.edu.sg/1617t1ISSS608g1/index.php?title=ISSS608_2016-17_T1_Assign2_Kee_Bei_Jia&oldid=3012’