{"id":3181,"date":"2017-04-12T09:47:20","date_gmt":"2017-04-12T14:47:20","guid":{"rendered":"http:\/\/commons.trincoll.edu\/amst-data-driven\/?p=3181"},"modified":"2017-04-14T11:07:35","modified_gmt":"2017-04-14T16:07:35","slug":"lab-5-excel","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/amst-data-driven\/2017\/04\/12\/lab-5-excel\/","title":{"rendered":"lab 5: Excel"},"content":{"rendered":"<p>I have thirteen different languages, they include ca, de, en, fr, it, ja, nl, pt, ru, sv, tr, uk and zh-cn. Out of my 3,500 tweets, 3136 of them are in english, which is 89.6%.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-medium wp-image-3198\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.35.45-AM-300x181.png\" alt=\"Screen Shot 2017-04-12 at 10.35.45 AM\" width=\"300\" height=\"181\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.35.45-AM-300x181.png 300w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.35.45-AM.png 412w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><img loading=\"lazy\" class=\"alignnone size-medium wp-image-3204\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.44.08-AM-300x177.png\" alt=\"Screen Shot 2017-04-12 at 10.44.08 AM\" width=\"300\" height=\"177\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.44.08-AM-300x177.png 300w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Screen-Shot-2017-04-12-at-10.44.08-AM.png 355w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>My results continue to prove that #alternativefacts is most common in the United States. Almost all of the tweets are in English because it is predominately in America. When I changed the search to my specific dates, (January 5 and January 6) it showed all negative news articles on Trumps new decisions as newly elected President of the United States. The articles are include stories of Trump &#8220;fighting spies&#8221;, fighting democrats on healthcare and articles on Toyota in Mexico and Ford Motors.<\/p>\n<p>When I changed the date to January 6, the results change dramatically. Almost every article is about building the wall on the Mexican boarder, Russia, and who he had picked for his cabinet. When comparing the tweets and days, it is obvious that the second day, January 6, had many more tweets because the things being talked about that day were much more significant overall. They were more appealing to talk about than the topics on the first day.<\/p>\n<p>My mean and median show that there were many more tweets on the second day. My tweets do not necessarily stand out. They are unlike any other tweets though. There are many that are much larger and many that are much smaller but my numbers are much different than anyone else.<\/p>\n<p>Again, in comparison to the rest of the class, I am right in the middle. There are some much larger and some much smaller. I was surprised to see that #LGBT had only one tweet one day. Crazy! Also, #ObamaCare had very similar numbers to me regarding the range, min and min.<\/p>\n<p>This data set showed me how current events drastically change the data. If Trump does one thing opposed to another, the entire internet will be filled with data about it. If one decision is more impactful or controversial than another decision, there will be more tweets and data revolving around this issue.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have thirteen different languages, they include ca, de, en, fr, it, ja, nl, pt, ru, sv, tr, uk and zh-cn. Out of my 3,500 tweets, 3136 of them are in english, which is 89.6%. My results continue to prove that #alternativefacts is most common in the United States. Almost all of the tweets are&#8230;<\/p>\n","protected":false},"author":1776,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3181"}],"collection":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/users\/1776"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/comments?post=3181"}],"version-history":[{"count":3,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3181\/revisions"}],"predecessor-version":[{"id":3352,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3181\/revisions\/3352"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/media?parent=3181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/categories?post=3181"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/tags?post=3181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}