Question
Instructions Basic Pivot Table Cust ID Region Payment Source Amount Product Time Of Day 10001 East Paypal Web $20.19 Online 22:19 10002 West Credit Web
Instructions
Basic Pivot Table
Cust ID | Region | Payment | Source | Amount | Product | Time Of Day |
10001 | East | Paypal | Web | $20.19 | Online | 22:19 |
10002 | West | Credit | Web | $17.85 | Online | 13:27 |
10003 | North | Credit | Web | $23.98 | Online | 14:27 |
10004 | West | Paypal | $23.51 | Book | 15:38 | |
10005 | South | Credit | Web | $15.33 | Book | 15:21 |
10006 | West | Paypal | $17.30 | Online | 13:11 | |
10007 | East | Credit | Web | $177.72 | Book | 21:59 |
10008 | West | Credit | Web | $21.76 | Book | 04:04 |
10009 | West | Paypal | Web | $15.92 | Online | 19:35 |
10010 | South | Paypal | Web | $23.39 | Online | 13:26 |
10011 | South | Paypal | $24.45 | Book | 14:17 | |
10012 | East | Credit | Web | $20.39 | Book | 01:01 |
10013 | North | Paypal | Web | $19.54 | Online | 10:04 |
10014 | East | Credit | Web | $151.67 | Book | 09:09 |
10015 | West | Credit | Web | $21.01 | Online | 05:05 |
10016 | West | Paypal | Web | $22.91 | Online | 20:29 |
10017 | West | Credit | $19.51 | Book | 15:03 | |
10018 | West | Paypal | Web | $20.16 | Book | 18:54 |
10019 | West | Credit | Web | $17.53 | Online | 20:00 |
10020 | West | Credit | Web | $17.74 | Online | 12:37 |
10021 | North | Paypal | $17.16 | Book | 05:05 | |
10022 | West | Credit | Web | $205.58 | Book | 20:42 |
10023 | South | Credit | $18.12 | Book | 10:12 | |
10024 | West | Credit | Web | $20.04 | Online | 16:27 |
10025 | West | Paypal | $23.21 | Online | 20:22 | |
10026 | West | Credit | $22.79 | Online | 19:58 | |
10027 | West | Credit | Web | $16.91 | Online | 19:44 |
10028 | South | Credit | Web | $20.22 | Book | 19:28 |
10029 | East | Paypal | Web | $18.36 | Online | 15:48 |
10030 | West | Paypal | $206.80 | Book | 18:14 | |
10031 | North | Paypal | $17.95 | Online | 15:15 | |
10032 | East | Credit | Web | $18.29 | Book | 12:59 |
10033 | South | Paypal | Web | $18.55 | Book | 17:38 |
10034 | West | Credit | Web | $18.82 | Book | 02:02 |
10035 | West | Credit | Web | $16.35 | Book | 14:05 |
10036 | East | Credit | Web | $16.30 | Online | 04:04 |
10037 | South | Paypal | Web | $217 | Book | 00:00 |
Using the excel spreadsheet found above, create a series of Pivot Tables (or Pivot Charts) to answer the following questions.
- What are the averages for purchases in each region?
- What form of payment is most common?
- Do our customers shop at work (most likely between 8:00 and 17:00) or at home?
Turn in a printout of the pivot tables you used to answer each question.
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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started