{"id":16970,"date":"2019-10-08T12:33:21","date_gmt":"2019-10-08T16:33:21","guid":{"rendered":"http:\/\/studentwork.prattsi.org\/infovis\/?p=16970"},"modified":"2019-10-08T12:39:23","modified_gmt":"2019-10-08T16:39:23","slug":"temporal-statistical-lab-economic-events","status":"publish","type":"post","link":"https:\/\/studentwork.prattsi.org\/infovis\/visualization\/temporal-statistical-lab-economic-events\/","title":{"rendered":"GLobal Economic events, q1\/q2 2019"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

INTRODUCTION<\/strong><\/strong><\/h3>\n\n\n\n

Statistics, more often than not, play a major role in generating useful insights from data. Regardless of the level of complexity, this mathematical discipline will come in handy. In the case of working with temporal data, i.e. data which is collected over certain periods of time, we can combine statistics with various temporal visualizations in order to generate interesting stories.<\/p>\n\n\n\n

This lab report presents four statistical and temporal visualizations aimed to provide insight into some economic events which occurred during the two opening quarters of 2019.<\/p>\n\n\n\n

Inspiration<\/strong><\/h4>\n\n\n\n

My first visualization was inspired by the several treemaps that I have seen on the Reddit subforum r\/dataisbeautiful<\/a>, which is a social space for users to share data visualizations. I believe that the treemap is an efficient way of displaying size and share proportions, given that the differences are large enough to visually distinguish.<\/p>\n\n\n\n

Stephen Few\u2019s, Now You See It (2009), is the main source of inspiration for my other visualizations, such as my bar chart for displaying prediction accuracy. As pointed out by Few (Now You See It, p. 38), bar charts are often superior when it comes to presenting comparisons. Few (2009) also inspired my time-series graph and the choice of using groups to clearly detect relevant patterns in the data. <\/p>\n\n\n\n

Materials<\/strong><\/h4>\n\n\n\n

My dataset was retrieved from Keggle.com<\/a>, where it had been uploaded by a user who had extracted information from the financial website Investing.com<\/a>. The data consists of economic events that took place during Q1 and Q2 of 2019. Each row represents an event, with a brief description, along with information on how the events were expected to impact peculiar variables, such as price indexes or currencies, as well as actual and previous values of those values. <\/p>\n\n\n\n

Tableau Public<\/a> was the main software tool used for this project. Additionally, I used Microsoft Excel and Google Refine for minor dataset manipulation tasks. <\/p>\n\n\n\n

Methods<\/strong><\/h4>\n\n\n\n

Prior to\nimporting my dataset to Public Tableau, I used Microsoft Excel and Google Refine\nto improve the quality of the data. Excel was utilized to add column headers,\nwhich were missing from the original dataset. I also changed the format of\nrelevant columns, such as transforming one variable from \u201cGeneral\u201d to \u201cTime\u201d. Google\nRefine was used for minor data cleaning, such as removing faulty values, as\nwell as transforming additional values.<\/p>\n\n\n\n

The work process\nin Tableau Public started out with testing several visualizations in order to\ndetermine what would be the most interesting to present. I decided to keep the\nvisualizations simple rather simple, drawing on inspiration from Edward Tufte\u2019s\nreasoning about overplotting.<\/p>\n\n\n\n

RESULTS AND\nINTERPRETATION<\/strong><\/h3>\n\n\n\n

Click here<\/a> to view visualizations in Tableau<\/p>\n\n\n\n

Share of events per country<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n

This treemap presents the share of total events per country, grouped by continents. The share of events is dominated by the United States (23%), not too much of a surprise considering it is the largest economy in the world. However, what is rather more surprising is that the second-largest economy, China, is found in 6th<\/sup> place with 5% of the total events. Despite this seemingly surprising result, it is important to note that the underlying data is not a representation of all the economic events of the time period. Also, since the data was cleaned prior to the analysis, we run the risk of having disregarded some events.<\/p>\n\n\n\n

Prediction accuracy<\/h4>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n
\"\"<\/figure>\n\n\n\n

This faceted\nbar chart displays the accuracy of analyst predictions based on what volatility\nwhat was expected for each event. I color mapped the bars so that each color\nwould reflect the \u201cfeeling\u201d of that bar, red being negative, and green positive.\nFor all levels of expected volatility, the actual result turned out worse than\nthe prediction, implying on impact underestimation. <\/p>\n\n\n\n

If we wanted\nto further investigate the accuracy of the analyst predictions, we would have to\nincrease the use of statistics. <\/p>\n\n\n\n

Regional monthly volatility<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n

This line graph shows the average volatility over a 6-month period for three grouped regions, \u201cUS\u201d (United States), \u201cChina\u201d (China and Hong Kong), and \u201cRoW\u201d (rest of countries). I colored the lines to represent the color of each region’s flag and made the RoW-line grey. Spikes in volatility in April show that this period was volatile for all regions, led by China. In July, the US suffered a relatively strong increase in volatility compared to China and RoW.<\/p>\n\n\n\n

While this\ngraph shows detailed snapshots of volatility per month, if we rather wanted to present\nthe volatility trend, we could change the measure to a moving average (Few, 2009).<\/p>\n\n\n\n

Event per hour<\/h4>\n\n\n\n
\"\"<\/figure>\n\n\n\n

The fourth graph\nin this lab report is another line graph, which presents the average frequency\nof events over the period of one day, measured within time zone GMT -4. There\nare three prolific spikes in the data at 4 AM, 8 AM and 7 PM. I decided to shade\nthe graph to make the high frequency areas stand out. I also added percentages\nof the total for the three top peaks, in order to make the diagram more explanatory.\n<\/p>\n\n\n\n

When analyzing\nthe peaks of the graph, I found that they are likely to be connected to the beginning\nof the day in various time zones, as seen by the labels. One possible takeaway\nfrom this is that economic events are often registered during the early hours\nwhen markets open. However, this does not mean that the actual events took\nplace during those hours. <\/p>\n\n\n\n

REFLECTION\n& FURTHER DIRECTIONS <\/strong><\/h3>\n\n\n\n

I found this lab very educational, especially since the\nproject involved all steps from finding, cleaning and organizing data, to the\nmain objective of this lab; visualizing it.<\/p>\n\n\n\n

For further directions, I would suggest performing similar analysis and visualizations for larger economic event datasets, to study e.g. how the proportions of events would differ compared to this rather limited dataset.<\/p>\n\n\n\n

Regarding the aesthetics of the visualizations, I would also\nfurther work on the dashboard to improve the project overview.<\/p>\n","protected":false},"excerpt":{"rendered":"

INTRODUCTION Statistics, more often than not, play a major role in generating useful insights from data. Regardless of the level of complexity, this mathematical discipline will come in handy. In the case of working with temporal data, i.e. data which is collected over certain periods of time, we can combine statistics with various temporal visualizations…<\/p>\n","protected":false},"author":633,"featured_media":16985,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[485,94],"coauthors":[463],"class_list":["post-16970","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-visualization","tag-temporal","tag-visualization"],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2019\/10\/Treemap.jpg?fit=1982%2C1333&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paBdcV-4pI","_links":{"self":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16970","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/users\/633"}],"replies":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/comments?post=16970"}],"version-history":[{"count":10,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16970\/revisions"}],"predecessor-version":[{"id":16999,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/posts\/16970\/revisions\/16999"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media\/16985"}],"wp:attachment":[{"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/media?parent=16970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/categories?post=16970"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/tags?post=16970"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/studentwork.prattsi.org\/infovis\/wp-json\/wp\/v2\/coauthors?post=16970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}