Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
STEP ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started