Assignment Goals:
In this assignment, you will use Excel to calculate basics metrics that are commonly generated from syndicated marketing databases.
TUTORIAL [This is TRAINING, this is NOT the Assignment!]:
Download the Excel sheet here.Links to an external site.
This Excel spreadsheet has three tabs. The tabs show you: (1) how to interpret common metrics from syndicated marketing databases (first tab). (2) how to use EXCEL to calculate the metrics (third tab, check the orange table in cells I9 to K11).
ASSIGNMENT FILE:
Download the ASSIGNMENT FILE (Excel File) here.Links to an external site.
TASK: Calculate the missing metrics using Excel equations. Specifically, Column E, Column F, and Column G ( % Detail, % Target, and Index) The tutorial spreadsheet (above) shows you how these calculations are done (see the third tab, "GfK Solution Sheet").
When complete, keep the Excel functions in the cells. That is, if an answer in a cell is "10" and you derived it by writing an equation "= A2 + B12," keep the underlying function in Excel so I can inspect your work. Of course, Excel will still show "10," but I want to be able to check that you set up the function correctly.
For INDEX values, do not show any decimals points ("124" would be acceptable; "124.34" would not).
For %Target and %Detail, show percentages to the first decimals point ("30.5%" is acceptable, "30.57632%" is not).
SUBMIT an Excel file as your solution (*.xls or *.xlsx extension).
Previous
Next