Assignment task:
This project gives you an opportunity to learn how to use Excel's PivotTable functionality to analyze a database or data list. Use the data file for Online Management Training Inc. described earlier in the chapter. This is a list of the sales transactions at OMT for one day. You can find this spreadsheet file at MyMISLab. Use Excel's PivotTable to help you answer the following questions: • Where are the average purchases higher? The answer might tell managers where to focus marketing and sales resources or pitch different messages to different regions. • What form of payment is the most common? The answer could be used to emphasize in advertising the most preferred means of payment. • Are there any times of day when purchases are most common? Do people buy products while at work (likely during the day) or at home (likely in the evening)? • What's the relationship among region, type of product purchased, and average sales price? We provide instructions on how to use Excel PivotTables in our Learning Tracks.