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 spend | Total Measure Ad Impressions | Cost per thousand | |
|---|---|---|---|
| Base Campaign January | $12,604 | 2,520,800 | |
| Base Campaign February | $15,220 | 3,044,000 | |
| Base Campaign March | $15,640 | 3,910,000 | |
| Base Campaign April | $20,151 | 5,037,750 | |
| Base Campaign May | $14,672 | 4,034,800 | |
| Base Campaign June | $17,555 | 4,827,625 | |
| Base Campaign July | $16,432 | 4,108,000 | |
| Base Campaign August | $15,595 | 3,898,750 | |
| Base Campaign September | $13,452 | 4,035,600 | |
| Base Campaign October | $16,355 | 4,906,500 | |
| Base Campaign November | $18,245 | 5,108,600 | |
| Base Campaign December | $20,763 | 5,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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
