In the state of Maryland, Montgomery County passed a law that requires all retail establishments to charge a five-cent tax on each paper or plastic carryout bag. Retailers retain 1 cent of the 5 cents for the bags they sell to a customer. The other 4 cents must be remitted to the county. Go to the student download page at http://www.pearsonhighered.com/romney and download the file labeled “P7-

7MarylandBagTax.xlsx”. This file provides the actual amount companies collected, the amount they paid to the city each month (labeled “Amount Due”), and the amount they retained from the tax.

REQUIRED Using this data, create a separate visualization to accomplish each of the following objectives.

a. Create a visualization that emphasizes the vendors who contributed the most to the bag taxes collected by the county. Provide a brief explanation of which emphasis technique(s) you used.

b. Create a visualization that emphasizes which cities paid the most bag taxes to the county. Provide a brief explanation of which emphasis technique(s) you used.

Exclude all items that have a null value in the City field.

c. Create a visualization that examines the annual trend in amount collected for each city over time. Exclude all items that have a null value in the City field. Emphasize the town “Germantown” in the visualization. Provide a brief explanation of which emphasis technique(s) you used.