Advertising math

ADV 330

FUN WITH INDEX NUMBERS

TV HH "Category" "Brand"

TV DMA TV HH W 18-49 W 18-49 Sales W 18-49 Sales THE ASSIGNMENT POINT VALUE NORTH CAROLINA

Charlotte 1,189,950 618,774 1,137,120.00$ 238,795.00$ #1 Index DMA TV HH - calculate the INDEX NUMBER for each city/ TV DMA 15

Greensboro 690,050 351,926 590,495.00$ 183,053.00$

Raleigh-Durham 1,523,580 611,397 879,311.00$ 211,034.00$ #2 Index W 18-49 CATEGORY SALES - calculate the INDEX NUMBER for each city/ TV DMA 15

3,403,580 1,582,097 2,606,926.00$ 632,882.00$

SOUTH CAROLINA #3 Index W 18-49 BRAND SALES - calculate the INDEX NUMBER for each city/TV DMA 15

Charleston 327,040 170,061 298,932.00$ 83,701.00$

Columbia 400,790 192,379 292,050.00$ 96,376.00$ #4 WHAT ARE THE "TOP 5" INDEXING MARKETS FOR THE CATEGORY 2.5

Greenville 372,450 178,776 253,986.00$ 87,372.00$

Myrtle Beach 291,680 148,757 261,484.00$ 64,063.00$ #5 WHAT ARE THE "TOP 5" INDEXING MARKETS FOR THE BRAND 2.5

1,391,960 689,973 1,106,452.00$ 331,512.00$

GEORGIA TOTAL 50

Augusta 260,840 133,028 223,208.00$ 58,034.00$ YOUR KEY TO SUCCESS

Columbus 217,660 108,830 208,692.00$ 64,694.00$ #1 Calculate the data set average for each state - TV HH, W 18-49TV HH, etc.

Macon 232,910 123,442 157,808.00$ 58,389.00$ #2 DIVIDE each data point by the data set average

Rome 198,763 96,996 138,581.00$ 48,780.00$ #3 Multiply your answer for each data point in #2 by 100

Savannah 340,050 176,826 395,595.00$ 112,744.00$ #4 Round this number UP or DOWN to the next WHOLE NUMBER (< .5 DOWN / > .5 UP)

1,250,223 639,122 1,123,884.00$ 342,641.00$ #5 Index Numbers MUST BE WHOLE NUMBERS

FLORIDA

Jacksonville 688,500 351,135 617,225.00$ 172,823.00$

Panama City 141,790 73,731 153,168.00$ 29,101.00$

Tallahassee 288,390 152,847 219,824.00$ 79,136.00$

1,118,680 577,713 990,217.00$ 281,060.00$