• Use Tableau calculations and make a few graphs to answer the following questions:
  1. Bar chart the number of posts by type. Add a quick table calculation of percent of total. What is the percentage of photo posts?
  2. Which month has the highest average engagement rate? (Facebook engagement rate is calculated as the posts lifetime engaged users divided by lifetime post total reach. Engaged users are users who clicked anywhere in the post; Total reach is the total number of people who see the post).
  3. Looking at each month in the data, does including an exclamation point (!) in the text of our Facebook post seem to increase the posts average lifetime engaged users?
  4. How many posts contains the word science? What is the effect of inclusion of the key word science in the text and the lifetime negative feedback.