Question: The embedded spreadsheet contains colums of data containing Ad spend and Total measured Ad impressions for each calendar month of a year. By inserting an

The embedded spreadsheet contains colums of data containing Ad spend and Total measured Ad impressions for each calendar month of a year.

By inserting an appropiate formula into the relevant cells please calculate the:

- Cost per thousand for each month (including dollars and cents $x.xx))

- Average Ad spend per month (Do not include deimals)

- Average Ad Impressions per month (Do not include decimals)

- Average cost per thousand per month (including dollars and cents, i.e $x.xx)

Ad spendTotal Measure Ad ImpressionsCost per thousand
Base Campaign January$12,6042,520,800
Base Campaign February$15,2203,044,000
Base Campaign March$15,6403,910,000
Base Campaign April$20,1515,037,750
Base Campaign May$14,6724,034,800
Base Campaign June$17,5554,827,625
Base Campaign July$16,4324,108,000
Base Campaign August$15,5953,898,750
Base Campaign September$13,4524,035,600
Base Campaign October$16,3554,906,500
Base Campaign November$18,2455,108,600
Base Campaign December$20,7635,813,640
Average Ad Spend per month
Average Ad Impressions per month
Average Cost per thousand per month


Step by Step Solution

3.38 Rating (154 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

STEP ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!