This assignment is for you to practice calculating data. Try to work out the answers, including every cell's formula on your own, and then compare your answers to the correct formulas in the spreadsheet.

Data Overview

This Excel Spreadsheet Download Excel Spread sheet has one row for each post that David has made over the last month. Each post contains the following information:

• Post ID: A unique value that identifies the post.
• Impressions: How many users saw the post.
• Like: How many users clicked the like button on the post.
• Comments: How many users made a comment on the post.
• Shares: How many users shared the post.
• Clicks: How many times users clicked on the post's link to the apparel website.

David wants to understand what metrics he should be looking at with Facebook, and how much people are interacting with the posts.

Your Tasks:

1. Calculate the following metrics under the area labeled Part A "Social Metrics". Format all rates as percentages.

• Total and average impressions
• Total and average likes
• Total and average comments
• Total and average shares
• Total and average clicks
• Engagement rates:
  • Like rate
  • Comment rate
  • Share rate
  • Click-through rate

Double Check

Make sure that you have provided clear answers and formulas for everything listed above on the "Facebook" Excel sheet and resubmit with your name.

Facebook: This sheet shows the performance of 17 posts on Facebook over the course of the month. 187 3 Facebook Report This is your data Post ID Impressions Likes Comments 1 187 17 2 197 17 3 15 4 200 22 5 188 18 6 208 21 7 208 28 8 207 24 9 217 23 10 205 21 11 244 21 12 251 22 13 241 23 14 253 23 15 215 21 16 229 18 17 281 30 Shares Clicks 0 2 2 5 0 4 4 7 2 5 2 4 1 4 0 0 2 2 4 6 2 1 0 1 1 0 3 1 2 1 4 4 1 4 3 2 5 1 1 3 4 2 Part A: Social Metrics : Total: Average: Impressions Likes Comments Shares Clicks 3700 382 52 32 50 217.65 21.29 3.00 1.88 2.94 Click Comment Share Through Like Rate Rate rate Rate 0.78% 1.41% 0.86% 1 35%