12-9 This project gives you an opportunity to learn how to use Excel’s PivotTable feature 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 are products while at work (likely during the day) or at home (likely in the evening)?

• What’s the relationship between region, type of product purchased, and average sales price?

We provide instructions on how to use Excel PivotTables in our Learning Tracks.