{"id":3187,"date":"2017-04-12T10:13:36","date_gmt":"2017-04-12T15:13:36","guid":{"rendered":"http:\/\/commons.trincoll.edu\/amst-data-driven\/?p=3187"},"modified":"2017-04-13T14:09:51","modified_gmt":"2017-04-13T19:09:51","slug":"pie-chart-lab-5","status":"publish","type":"post","link":"http:\/\/commons.trincoll.edu\/amst-data-driven\/2017\/04\/12\/pie-chart-lab-5\/","title":{"rendered":"Our Friend Excel &#8211; #WhyIMarch"},"content":{"rendered":"<p>I have 24 languages in my #WhyIMarch dataset, including the following: ar, da, de, el, en, en-gb, en-GB, es, fr, he, hu, id, it, ja, ko, nl, no, pt, ru, sv, th, tr, zh-CN, zh-tw.<\/p>\n<p>After typing the =COUNTIF formula into Excel, I found that there are 4183 tweets in the English language. The total number of tweets in my data set is n=4498. This means that about 93% of my tweets are in English! I also found that about 2% are in Russian, 1% Portuguese, and 3% in other languages.<\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-3280\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture1.jpg\" alt=\"Picture1\" width=\"582\" height=\"368\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture1.jpg 582w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture1-300x190.jpg 300w\" sizes=\"(max-width: 582px) 100vw, 582px\" \/><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-3285\" src=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture2.png\" alt=\"Picture2\" width=\"752\" height=\"452\" srcset=\"http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture2.png 752w, http:\/\/commons.trincoll.edu\/amst-data-driven\/files\/2017\/04\/Picture2-300x180.png 300w\" sizes=\"(max-width: 752px) 100vw, 752px\" \/><\/p>\n<p>From this chart I created using the archived tweets on excel, I found that the most tweets using #WhyIMarch were tweeted on 2\/9\/17, which was a Thursday. I chose this period of time originally because there was an article released on February 6th in\u00a0<em>The Guardian,<\/em> which announced a second women&#8217;s march to occur on March 6th. The week of February 6th was still very soon after the first women&#8217;s march on January 21st, so many people were still very heated tweeting about #WhyIMarch. With the announcement of a second women&#8217;s\u00a0march,\u00a0many people tweeted even more than before. Especially on Thursday, February 9th, because it was a chance to tweet before the weekend\u00a0and encourage followers to join them in any sort of women&#8217;s rights gathering that may occur over\u00a0the weekend. There are more tweets overall during the week, because people are either at work or school, on their computers or their phones tweeting\u00a0with time to tweet. The number of tweets decline over the weekend because people are preoccupied with activities and are out\u00a0doing things instead of tweeting about it.As I mentioned in Lab 4, it makes sense that the greatest number of tweets is a few days after the announcement was released, because by that time the news would have been able to travel around to more and more people.<\/p>\n<p>When I searched \u00a0Google during the week of 2\/7\/17-2\/13\/17, I found many interesting articles which help explain what I see on the chart. On February 13th, there was an article released on <em>MSEA Newsfeed<\/em> about another women&#8217;s march on March 13th. Similar to the article in\u00a0<em>The Guardian,\u00a0<\/em>this sparked more talk on twitter using #WhyIMarch, to rally people to attend the next march and make it even bigger than the first. Another reason why the number of tweets are significantly greater on February 9th compared to the rest is an article released by the official\u00a0<em>Women&#8217;s March\u00a0<\/em>website. This message is asking users to specifically tweet in order to get the word out about Senator McConnell being silenced! This must have reached many users who then followed the directions and tweeted the letter along with the #WhyIMarch hashtag.<\/p>\n<blockquote data-secret=\"ESKErepV7d\" class=\"wp-embedded-content\"><p><a href=\"https:\/\/womensmarchslo.com\/2017\/02\/senator-mcconnell-we-will-not-be-silenced\/\">Senator McConnell &#8211; We Will Not Be Silenced!<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"https:\/\/womensmarchslo.com\/2017\/02\/senator-mcconnell-we-will-not-be-silenced\/embed\/#?secret=ESKErepV7d\" data-secret=\"ESKErepV7d\" width=\"600\" height=\"338\" title=\"&#8220;Senator McConnell &#8211; We Will Not Be Silenced!&#8221; &#8212; Women&#039;s March\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>When I completed my lab, not everyone had posted their data. That being said, I was able to compare my data with about half the class and my mean is\u00a0one of the middle\u00a0values. There are means in the 2,000 and 7,000 range, but there are also means in the 200-500 range. My mean, 642.43, is about the middle of the means that are shown. The same goes for the median of my results. 580 is about in the middle of the other medians. However, I was curious to see that Bush and Ogan had the same Mean and Median for their data, 2,000 and 7,000. We all got N\/A, except for Quarls which does not say much about our data. Ogan&#8217;s hashtag, #climatechange, explains why his mean is so large. #Climatechange is a universal hashtag, which most people use all over the world, where as most of the other hashtags, including mine, have to do mostly with\u00a0America.<\/p>\n<p>The count of my data is 4497, the max is 877, the min is 493, and the range is 384. Compared to others, I had the higher number\u00a0of tweets counted. I wanted to choose the week of 4\/7\/17, so I chose the number of tweets based on those days, not based on limiting myself to a number. My data had around the same amount of tweets per day, some more and some less, but for the most part there were no extreme days. I found it interesting to look at Bush&#8217;s #transgender results to see that there was a total count of 4019, and a max of 3061! That means that there was one day where the majority of people tweeted. I wonder what happened on that day!<\/p>\n<p>I found it intriguing to look at the data results for each hashtag together on the google doc. It is the most interesting for me\u00a0to see all of the percentage of tweets in English for each hashtag. I originally assumed that hashtags like #climatechange would have a lower percentage of english, since that is a major issue around the globe. I was also surprised to see that #transgender had only 54% of tweets in English. That means that people around the world who speak other languages are still using the english word in their tweets, which shows the strength of the word. I enjoyed being able to\u00a0compare my data with others in\u00a0the class during this lab.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I have 24 languages in my #WhyIMarch dataset, including the following: ar, da, de, el, en, en-gb, en-GB, es, fr, he, hu, id, it, ja, ko, nl, no, pt, ru, sv, th, tr, zh-CN, zh-tw. After typing the =COUNTIF formula into Excel, I found that there are 4183 tweets in the English language. The total&#8230;<\/p>\n","protected":false},"author":1537,"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\/3187"}],"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\/1537"}],"replies":[{"embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/comments?post=3187"}],"version-history":[{"count":5,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3187\/revisions"}],"predecessor-version":[{"id":3289,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/posts\/3187\/revisions\/3289"}],"wp:attachment":[{"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/media?parent=3187"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/categories?post=3187"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/commons.trincoll.edu\/amst-data-driven\/wp-json\/wp\/v2\/tags?post=3187"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}