The attached Excel File provides customer purchasing information for 4 regions. The table includes the region, how the customer paid for the purchase, whether it was an online or in-store purchase, the amount after purchase of phone package, accessories and discounts, the phone type and the time of day of the purchase (24-hour clock). It is assumed that customers work from 8am until 5pm.

Using the excel spreadsheet attached to this assignment, create a series of Pivot Tables (in a single Excel workbook) to answer the following questions in a Word or PDF document (150 words or more):

1. What are the averages for purchases of the Samsung 10 and iPhone X in each region?
2. What Source (Online or In-Store) produces the most profit?
3. Do customers shop at work (between 8:00 and 17:00) or at home?
4. What would your advertising/marketing strategy be for each region?
5. Is it worth continuing to sell through the stores if the overhead costs for the stores were an additional $50 per purchase?
6. Is it worth continuing to allow purchases using a Credit Card, if the costs were 2% higher than Paypal

Please upload the Excel Workbook (with the pivot tables you've created) and the Word/PDF document with your answers to the questions to this assignment

\f