Using the excel spreadsheet provided to you, create a series of Pivot Tables (or Pivot Charts) to answer the following questions. 1. What are the averages for purchases in each region?
2. What form of payment is most common?
3. Do our customers shop at work (most likely between 8:00 and 17:00) or at home? Include a printout of the pivot tables you used to answer each question.
You can type your answer and insert pivot tables right after each question, but highlighted it with different fonts or format.
Note: To answer number 3, I created a new column in the spreadsheet labeled ""Hour of Day"" and set it to just the hour instead of hour and minutes. In other words =hour(G8). The students who are excel power users should use an ""if"" formula to create a value of either day (time between 8:00 and 17:00) or night (not between 8:00 and 17:00).