(Solved) : Use Microsoft Excel Spreadsheet Software Analyze Table Data Project Gives Opportunity Lear Q37217843 . . .
You will use Microsoft Excel spreadsheet software to analyze atable of data. This project gives you an opportunity to learn howto use Excel’s PivotTable functionality to analyze a database ordata List. Use the data file for Online Management Training Inc.This is a list of the sales transactions at OMT for one day. UsetheOnlineManagementTraining.xls file (attached)and update the spreadsheet to answer the following questions.
- In what region are the average prices higher?
- What form of payment is the most common?
- Are there any times of day when purchases are most common? Dopeople buy products while at work (likely during the day) or athome (likely in the evening)?
- What’s the relationship among region, type of productpurchased, and average sales price?
- Write a description of how the answers to these questions couldbe used to improve marketing, sales, and customer relationships ofthe business. What additional reports would be helpful?
Expert Answer
Answer to You will use Microsoft Excel spreadsheet software to analyze a table of data. This project gives you an opportunity to l…
OR