Case background

You are looking to do a test marketing of your new and innovative Business in Tucson Arizona. You are thinking about print and internet marketing approaches. However, before you begin your marketing, you think you should have a better sense of the target population.

Process

You have a Spreadsheet, titled yourNetID$\_$A$2\_$TucsonData.xlsx$,$ vWth a sample of people from Tucson Arizona $($Note: this is a real marketing Database of people living in specific Tucson zip codes; and so some noise has been added to the data, e$.$g$.,$ names and street addresses have been randomized for privacy$).$ You will undertake some data preparation steps and use pivot tables to answer some basic questions about Tucson.

Core Items to Consider

Spreadsheet: You must use the MS Excel spreadsheet from D$2$L $($titled yourNetID$\_$A$2\_$TucsonData.xIsx$)$ to prepare your submission. Create your pivot tables on separate worksheets, one worksheet per question. Within a worksheet, you may have as many pivot tables for the tasks, as you deem necessary.