Charts on Excel

s You will be making 3 pie charts and 1 bar graph on excel (I will be attaching the details and statistics on each graph) and then answering the questions related to each graph. The final paper should be on Microsoft word. Social Media Use in the United States Social media use is a common topic in the news in the United States, including some recent controversies about data sharing and how social media is used for advertising. The spreadsheet lists the number of users broken down by age for Facebook, Twitter, and Instagram. 1. When data is broken into distinct categories, it is often helpful to see what portion of the overall data set falls into each category. This can be effectively displayed using a pie chart. a) Create a pie chart displaying the breakdown of Facebook users by the following age groups: 18-24, 25-34, 35-44, 45-54, 55-64, and 65+. b) Create a pie chart displaying the breakdown of YouTube users by the following age groups: 18-24, 25-34, 35-44, 45-54, 55-64, and 65+. c) Create a pie chart displaying the breakdown of Twitter users by by the following age groups: 18-24, 25-34, 35-44, 45-54, 55-64, and 65+. d) Which age group has the highest percentage of users for each of the three social media sites? If you wanted to target advertising to a specific age group for each social media site, which age group would you focus on? Explain your answer. 2. Another method for displaying data that is broken into distinct categories is through the use of a bar graph. a) Create a bar graph displaying the breakdown of Facebook users by age group. b) Which of the visual representations created above – a bar graph or a pie chart – do you believe most effectively captures the important features of this data set? Provide a brief explanation of your answer. Indicate strengths and weaknesses of both types of visual representation. 3. What recommendations would you make to an advertiser looking to market on social media, specifically on Facebook, YouTube, and/or Twitter? Please provide a brief justification for your recommendations.

Back to School Offer

Get 15% of Your First Order amount back in Reward Credits!

ORDER NOW FOR CUSTOMIZED SOLUTION PAPERS