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

Answer rating: 100% (QA)

STEP ... View the full answer