Pivot Tables to Analyze Sales Data computer science homework help

Improving Decision Making: Using Pivot Tables to Analyze Sales Data

Software skills: Pivot tables

Business skills: Analyzing sales data

11-11 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. that is included in this Hands-On Project folder in Blackboard. This is a list of the sales transactions at OMT for one day.

Use Excel’s Pivot Table to help you answer the following questions:

1.  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.

2.  What form of payment is the most common? The answer could be used to emphasize in advertising the most preferred means of payment.

3.  Are there any times of day when purchases are most common? Do people buy the products while at work (likely during the day) or at home (likely in the evening)?

4.  What’s the relationship between regions, type of product purchased, and average sales price?

PLEASE SEE ATTACHED EXCEL SPREADSHEET 

Disclaimer: It is illegal to use the research material ordered on this website for other than research purposes. You must quote the sources appropriately. The company bears no responsibility for the use of research work, not intended for education use, the work is sold as-is with the highest quality and service available and written by freelancers.