BADB1023: : Management Information System Based on the data sets involving OMT below, you will develop pivot
Fantastic news! We've Found the answer you've been seeking!
Question:
BADB1023: : Management Information System
Based on the data sets involving OMT below, you will develop pivot tables.
| Lab Exercise 2: Pivot Table | ||||||
| Online Management Training Inc. | ||||||
| Transaction Log: October 28 | ||||||
| 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 | 4: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 | 1:01 |
| 10013 | North | Paypal | Web | $19.54 | Online | 10:04 |
| 10014 | East | Credit | Web | $151.67 | Book | 9:09 |
| 10015 | West | Credit | Web | $21.01 | Online | 5: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 | 5: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 | 2:02 |
| 10035 | West | Credit | Web | $16.35 | Book | 14:05 |
| 10036 | East | Credit | Web | $16.30 | Online | 4:04 |
| 10037 | South | Paypal | Web | $217 | Book | 0:00 |
| 10038 | East | Credit | Web | $16.15 | Online | 10:28 |
| 10039 | North | Credit | Web | $18.78 | Online | 5:05 |
| 10040 | South | Credit | Web | $150.99 | Book | 7:07 |
| 10041 | West | Credit | Web | $21.39 | Online | 19:20 |
| 10042 | West | Credit | Web | $16.60 | Online | 16:23 |
| 10043 | South | Paypal | Web | $23.81 | Book | 7:07 |
| 10044 | South | Credit | Web | $15.87 | Book | 13:46 |
| 10045 | West | Credit | Web | $20.82 | Online | 9:09 |
| 10046 | South | Credit | Web | $21.15 | Book | 6:06 |
| 10047 | South | Paypal | Web | $19.66 | Online | 18:50 |
| 10048 | West | Paypal | $21.02 | Online | 3:03 | |
| 10049 | West | Credit | Web | $23.13 | Online | 6:06 |
| 10050 | West | Paypal | Web | $15.17 | Online | 18:53 |
| 10051 | East | Paypal | Web | $209.51 | Book | 9:09 |
| 10052 | West | Credit | Web | $16.03 | Book | 17:28 |
| 10053 | North | Credit | $16.17 | Online | 13:18 | |
| 10054 | East | Credit | Web | $18.37 | Online | 8:08 |
| 10055 | East | Credit | Web | $15.96 | Book | 8:08 |
| 10056 | North | Paypal | Web | $19.29 | Book | 0:00 |
| 10057 | West | Paypal | $16.49 | Online | 19:59 | |
| 10058 | East | Paypal | Web | $18.12 | Book | 17:35 |
| 10059 | East | Credit | Web | $18.22 | Online | 15:52 |
| 10060 | East | Credit | Web | $18.32 | Book | 10:15 |
| 10061 | West | Credit | Web | $23.77 | Online | 19:53 |
| 10062 | East | Paypal | Web | $24.35 | Book | 15:16 |
| 10063 | South | Credit | $20.13 | Online | 13:55 | |
| 10064 | North | Credit | $20.77 | Online | 13:34 | |
| 10065 | North | Credit | $16.98 | Online | 19:21 | |
| 10066 | East | Credit | $19.40 | Book | 15:02 | |
| 10067 | East | Paypal | $23.49 | Book | 4:04 | |
| 10068 | South | Credit | Web | $15.58 | Book | 11:39 |
| 10069 | South | Credit | Web | $21.94 | Online | 20:19 |
| 10070 | South | Credit | $229.73 | Book | 1:01 | |
| 10071 | West | Credit | Web | $16.06 | Book | 10:31 |
| 10072 | South | Credit | Web | $22.21 | Online | 10:01 |
| 10073 | West | Credit | $21.58 | Online | 0:00 | |
| 10074 | North | Paypal | $16.09 | Book | 3:03 | |
| 10075 | East | Credit | $16.10 | Online | 10:13 | |
| 10076 | East | Credit | Web | $15.95 | Online | 0:00 |
| 10077 | South | Credit | $17.77 | Book | 1:01 | |
| 10078 | North | Credit | Web | $19.30 | Online | 11:24 |
| 10079 | West | Paypal | Web | $21.75 | Book | 10:23 |
| 10080 | West | Paypal | Web | $20.51 | Book | 11:29 |
| 10081 | North | Credit | Web | $16.14 | Online | 4:04 |
| 10082 | West | Paypal | $157.76 | Book | 19:02 | |
| 10083 | South | Credit | Web | $21.55 | Book | 9:09 |
| 10084 | North | Paypal | Web | $21.85 | Online | 12:24 |
| 10085 | East | Credit | Web | $21.70 | Online | 13:33 |
| 10086 | East | Paypal | Web | $20.31 | Book | 19:26 |
| 10087 | East | Credit | $23.62 | Book | 22:20 | |
| 10088 | East | Credit | Web | $216.37 | Book | 10:20 |
| 10089 | North | Paypal | Web | $21.99 | Online | 3:03 |
| 10090 | West | Credit | $18.20 | Online | 5:05 | |
| 10091 | East | Credit | $17.31 | Book | 0:00 | |
| 10092 | West | Credit | Web | $23.94 | Book | 16:08 |
| 10093 | West | Paypal | $174.25 | Book | 18:31 | |
| 10094 | West | Paypal | Web | $20.26 | Online | 4:04 |
| 10095 | North | Credit | Web | $18.73 | Online | 0:00 |
| 10096 | North | Paypal | Web | $22.88 | Book | 13:09 |
| 10097 | West | Paypal | Web | $19.15 | Online | 14:44 |
| 10098 | South | Credit | $15.33 | Book | 1:01 | |
| 10099 | West | Paypal | Web | $20.82 | Online | 18:01 |
| 10100 | West | Credit | Web | $20.61 | Online | 18:29 |
| 10101 | East | Credit | Web | $16.43 | Online | 11:23 |
| 10102 | West | Credit | Web | $21.10 | Online | 2:02 |
| 10103 | North | Paypal | $21.64 | Book | 22:40 | |
| 10104 | West | Paypal | $18.06 | Book | 16:00 | |
| 10105 | East | Credit | Web | $19.35 | Book | 10:06 |
| 10106 | North | Credit | Web | $23.70 | Online | 19:02 |
| 10107 | North | Credit | Web | $18.93 | Book | 9:09 |
| 10108 | North | Credit | $16.83 | Book | 16:20 | |
| 10109 | West | Credit | Web | $22.19 | Book | 18:52 |
| 10110 | West | Credit | Web | $23.90 | Book | 19:40 |
| 10111 | East | Credit | Web | $17.47 | Online | 10:53 |
| 10112 | West | Credit | $209.37 | Book | 20:11 | |
| 10113 | North | Credit | Web | $18 | Online | 8:08 |
| 10114 | East | Credit | Web | $22.83 | Book | 10:17 |
| 10115 | East | Credit | $20.31 | Online | 14:34 | |
| 10116 | South | Paypal | Web | $22.06 | Online | 11:07 |
| 10117 | North | Paypal | Web | $15.22 | Book | 10:39 |
| 10118 | South | Paypal | Web | $20.60 | Online | 20:46 |
| 10119 | East | Credit | Web | $18.25 | Online | 20:42 |
| 10120 | East | Credit | Web | $174.18 | Book | 12:42 |
| 10121 | North | Credit | $19.58 | Online | 22:31 | |
| 10122 | West | Paypal | Web | $17.91 | Book | 19:14 |
| 10123 | West | Credit | Web | $22.90 | Book | 12:16 |
| 10124 | North | Paypal | Web | $22.26 | Book | 17:50 |
| 10125 | South | Credit | Web | $19.04 | Book | 15:23 |
| 10126 | East | Credit | Web | $17.42 | Online | 5:05 |
| 10127 | West | Paypal | Web | $18.54 | Book | 19:30 |
| 10128 | North | Credit | Web | $19.74 | Online | 12:49 |
| 10129 | West | Credit | Web | $22.03 | Online | 14:49 |
| 10130 | West | Paypal | Web | $236.49 | Book | 16:24 |
| 10131 | South | Paypal | $19.30 | Online | 17:00 | |
| 10132 | East | Credit | $23.73 | Online | 16:57 | |
| 10133 | West | Paypal | Web | $19.96 | Book | 16:50 |
| 10134 | East | Credit | Web | $20.75 | Online | 15:02 |
| 10135 | South | Paypal | Web | $22.37 | Online | 8:08 |
| 10136 | West | Credit | $24.03 | Online | 11:14 | |
| 10137 | West | Credit | Web | $24.59 | Online | 4:04 |
| 10138 | West | Paypal | $155.91 | Book | 18:38 | |
| 10139 | East | Credit | $16.43 | Book | 9:09 | |
| 10140 | South | Paypal | Web | $15.71 | Book | 16:44 |
| 10141 | West | Paypal | Web | $15.19 | Book | 16:22 |
| 10142 | West | Paypal | Web | $21.35 | Online | 17:54 |
| 10143 | West | Credit | Web | $19.47 | Online | 18:17 |
| 10144 | West | Credit | Web | $21.49 | Online | 9:09 |
| 10145 | East | Paypal | Web | $22.20 | Online | 12:29 |
| 10146 | East | Paypal | Web | $21.15 | Online | 7:07 |
| 10147 | East | Credit | Web | $15.16 | Online | 11:19 |
| 10148 | East | Credit | $15.71 | Book | 9:09 | |
| 10149 | West | Paypal | Web | $24.65 | Book | 20:41 |
| 10150 | West | Paypal | $24.88 | Book | 15:23 | |
| 10151 | East | Paypal | $17.49 | Book | 21:46 | |
| 10152 | West | Credit | Web | $19.71 | Online | 7:07 |
| 10153 | South | Credit | Web | $17.33 | Book | 2:02 |
| 10154 | West | Credit | Web | $15.56 | Online | 21:07 |
| 10155 | East | Credit | Web | $18.94 | Online | 20:00 |
| 10156 | North | Credit | Web | $22.86 | Book | 16:02 |
| 10157 | South | Paypal | Web | $15.18 | Book | 6:06 |
| 10158 | South | Credit | Web | $22.46 | Book | 17:44 |
| 10159 | West | Credit | $21.39 | Book | 17:17 | |
| 10160 | South | Credit | $22.17 | Online | 10:23 | |
| 10161 | North | Paypal | Web | $234.63 | Book | 9:09 |
| 10162 | North | Paypal | Web | $24.97 | Book | 22:11 |
| 10163 | West | Credit | Web | $15.72 | Book | 10:53 |
| 10164 | East | Credit | Web | $24.35 | Book | 8:08 |
| 10165 | West | Paypal | $16.09 | Book | 8:08 | |
| 10166 | West | Credit | Web | $23.51 | Book | 16:18 |
| 10167 | North | Paypal | Web | $22.59 | Book | 16:51 |
| 10168 | East | Credit | Web | $15.59 | Online | 9:09 |
| 10169 | West | Credit | Web | $190.81 | Book | 21:57 |
| 10170 | West | Paypal | Web | $21.12 | Book | 16:40 |
| 10171 | North | Credit | Web | $24.60 | Online | 20:38 |
| 10172 | North | Paypal | Web | $21.22 | Online | 12:20 |
| 10173 | West | Credit | Web | $21.78 | Online | 7:07 |
| 10174 | West | Credit | Web | $16.54 | Online | 17:52 |
| 10175 | East | Credit | $177.32 | Book | 15:52 | |
| 10176 | South | Credit | Web | $21.50 | Book | 10:53 |
| 10177 | West | Paypal | Web | $24.65 | Online | 20:45 |
| 10178 | North | Paypal | Web | $19.43 | Online | 9:09 |
| 10179 | West | Credit | Web | $21.12 | Online | 20:13 |
| 10180 | West | Credit | Web | $18.10 | Online | 20:32 |
| 10181 | East | Credit | $24.40 | Book | 13:25 | |
| 10182 | South | Credit | Web | $19.37 | Book | 21:48 |
| 10183 | West | Credit | $19.17 | Online | 0:00 | |
| 10184 | South | Credit | $241.77 | Book | 9:09 | |
| 10185 | West | Paypal | Web | $19.65 | Book | 20:46 |
| 10186 | West | Paypal | Web | $19.88 | Book | 8:08 |
| 10187 | West | Paypal | Web | $15.18 | Online | 12:30 |
| 10188 | West | Paypal | Web | $15.08 | Book | 12:15 |
| 10189 | North | Paypal | Web | $23.74 | Book | 5:05 |
| 10190 | North | Credit | Web | $19.44 | Book | 9:09 |
| 10191 | South | Credit | Web | $17.70 | Online | 2:02 |
| 10192 | West | Credit | Web | $16.99 | Online | 17:34 |
| 10193 | East | Paypal | $16.13 | Book | 13:37 | |
| 10194 | West | Paypal | Web | $24.80 | Online | 20:28 |
| 10195 | West | Paypal | Web | $17.52 | Book | 20:35 |
| 10196 | North | Paypal | Web | $23.63 | Book | 19:47 |
| 10197 | West | Credit | Web | $23.03 | Online | 11:27 |
| 10198 | West | Paypal | Web | $21.03 | Online | 19:18 |
| 10199 | South | Credit | Web | $21.88 | Book | 3:03 |
| 10200 | South | Credit | $24.86 | Book | 17:27 | |
| 10201 | North | Credit | $21.43 | Online | 7:07 | |
| 10202 | South | Paypal | Web | $16.32 | Online | 15:09 |
| 10203 | East | Credit | Web | $17.20 | Online | 0:00 |
| 10204 | North | Paypal | Web | $17.87 | Online | 7:07 |
| 10205 | South | Credit | Web | $17.27 | Online | 7:07 |
| 10206 | South | Credit | Web | $19.76 | Book | 21:13 |
| 10207 | East | Paypal | Web | $17.10 | Book | 6:06 |
| 10208 | West | Credit | $15.66 | Book | 11:18 | |
| 10209 | West | Credit | Web | $22.37 | Book | 16:21 |
| 10210 | East | Credit | Web | $15.81 | Online | 12:26 |
| 10211 | South | Credit | Web | $18.75 | Online | 2:02 |
| 10212 | West | Credit | $192.41 | Book | 20:23 | |
| 10213 | South | Credit | $242.52 | Book | 9:09 | |
| 10214 | North | Credit | Web | $20.40 | Book | 0:00 |
| 10215 | East | Credit | Web | $24.71 | Online | 12:45 |
| 10216 | East | Credit | Web | $21.49 | Online | 8:08 |
| 10217 | West | Paypal | Web | $22.26 | Online | 5:05 |
| 10218 | West | Credit | Web | $22.39 | Book | 16:16 |
| 10219 | East | Credit | $21.01 | Book | 8:08 | |
| 10220 | West | Credit | Web | $226.15 | Book | 16:41 |
| 10221 | West | Paypal | Web | $20.67 | Book | 19:27 |
| 10222 | West | Credit | Web | $21.72 | Online | 20:04 |
| 10223 | East | Credit | $16.34 | Book | 17:53 | |
| 10224 | West | Credit | Web | $19.19 | Book | 19:08 |
| 10225 | West | Credit | $19.21 | Online | 2:02 | |
| 10226 | West | Credit | Web | $16.06 | Book | 17:30 |
| 10227 | South | Paypal | Web | $20.87 | Online | 13:41 |
| 10228 | West | Credit | Web | $15.33 | Online | 5:05 |
| 10229 | West | Credit | Web | $23.58 | Online | 2:02 |
| 10230 | North | Credit | $15.34 | Book | 10:08 | |
| 10231 | North | Paypal | Web | $216.20 | Book | 10:33 |
| 10232 | East | Credit | $21.85 | Online | 14:28 | |
| 10233 | West | Credit | Web | $23.59 | Book | 3:03 |
| 10234 | North | Paypal | Web | $20.44 | Book | 11:52 |
| 10235 | East | Credit | Web | $22.05 | Online | 8:08 |
| 10236 | West | Paypal | $20.42 | Book | 0:00 | |
| 10237 | West | Credit | $20.49 | Online | 20:10 | |
| 10238 | West | Credit | Web | $161.46 | Book | 14:23 |
| 10239 | South | Paypal | Web | $19.69 | Online | 4:04 |
| 10240 | South | Paypal | Web | $24.16 | Book | 2:02 |
| 10241 | East | Credit | Web | $22.80 | Online | 10:59 |
| 10242 | East | Paypal | Web | $243.70 | Book | 20:26 |
| 10243 | West | Paypal | Web | $210.38 | Book | 12:19 |
| 10244 | West | Paypal | $161.50 | Book | 16:15 | |
| 10245 | South | Credit | $21.92 | Online | 6:06 | |
| 10246 | West | Credit | Web | $23.75 | Online | 20:34 |
| 10247 | West | Credit | $23.74 | Online | 3:03 | |
| 10248 | West | Paypal | Web | $21.67 | Book | 12:41 |
| 10249 | West | Paypal | $22.04 | Book | 3:03 | |
| 10250 | North | Paypal | $17.83 | Online | 12:55 | |
| 10251 | South | Paypal | Web | $23.60 | Book | 2:02 |
| 10252 | North | Credit | Web | $19.90 | Book | 14:04 |
| 10253 | East | Credit | $209.20 | Book | 17:19 | |
| 10254 | East | Credit | $24 | Book | 11:52 | |
| 10255 | West | Credit | Web | $17.81 | Book | 12:36 |
| 10256 | West | Paypal | $24.77 | Online | 0:00 | |
| 10257 | East | Credit | Web | $21 | Online | 17:14 |
| 10258 | North | Paypal | Web | $191.43 | Book | 16:36 |
| 10259 | South | Paypal | Web | $24.52 | Online | 21:59 |
| 10260 | East | Credit | Web | $17.34 | Online | 8:08 |
| 10261 | East | Paypal | Web | $17.19 | Book | 3:03 |
| 10262 | West | Credit | Web | $22.55 | Book | 11:43 |
| 10263 | South | Credit | Web | $15.35 | Online | 10:15 |
| 10264 | South | Credit | Web | $23.20 | Book | 15:38 |
| 10265 | West | Credit | Web | $241.65 | Book | 20:39 |
| 10266 | West | Paypal | $242.40 | Book | 17:19 | |
| 10267 | West | Paypal | Web | $23.01 | Online | 17:44 |
| 10268 | East | Credit | $17.22 | Online | 1:01 | |
| 10269 | North | Paypal | Web | $15.96 | Online | 1:01 |
| 10270 | East | Credit | Web | $15.45 | Online | 9:09 |
| 10271 | North | Credit | $17.41 | Online | 5:05 | |
| 10272 | East | Credit | Web | $21.64 | Book | 10:39 |
| 10273 | South | Credit | Web | $157.86 | Book | 5:05 |
| 10274 | West | Paypal | Web | $18.17 | Online | 16:09 |
| 10275 | West | Credit | Web | $18.73 | Book | 20:18 |
| 10276 | West | Paypal | Web | $17.24 | Book | 20:47 |
| 10277 | South | Credit | Web | $23.91 | Online | 13:59 |
| 10278 | South | Credit | Web | $22.12 | Book | 17:31 |
| 10279 | West | Credit | Web | $15.25 | Online | 19:11 |
| 10280 | South | Credit | Web | $24.77 | Book | 0:00 |
| 10281 | West | Paypal | $20.28 | Book | 6:06 | |
| 10282 | South | Paypal | $20.33 | Online | 8:08 | |
| 10283 | South | Credit | Web | $16.90 | Book | 21:41 |
| 10284 | South | Paypal | Web | $16.47 | Book | 16:22 |
| 10285 | West | Paypal | Web | $21.18 | Book | 15:10 |
| 10286 | West | Credit | Web | $15.86 | Book | 18:00 |
| 10287 | West | Credit | Web | $24.42 | Book | 1:01 |
| 10288 | South | Paypal | Web | $222.38 | Book | 18:53 |
| 10289 | South | Paypal | Web | $188.85 | Book | 5:05 |
| 10290 | East | Credit | Web | $15.32 | Book | 9:09 |
| 10291 | West | Credit | $24.71 | Book | 16:22 | |
| 10292 | East | Credit | Web | $20.97 | Book | 11:17 |
| 10293 | West | Credit | $21.92 | Online | 19:17 | |
| 10294 | West | Paypal | Web | $15.40 | Book | 17:16 |
| 10295 | East | Credit | Web | $23.08 | Book | 7:07 |
| 10296 | East | Paypal | Web | $23.40 | Online | 1:01 |
| 10297 | North | Credit | Web | $22.65 | Book | 6:06 |
| 10298 | East | Paypal | $24.61 | Book | 13:08 | |
| 10299 | East | Credit | Web | $24.97 | Book | 16:53 |
| 10300 | South | Credit | Web | $18.57 | Book | 12:45 |
| 10301 | West | Credit | $16.15 | Online | 3:03 | |
| 10302 | West | Paypal | Web | $19.95 | Book | 19:35 |
| 10303 | West | Paypal | Web | $15.61 | Online | 22:02 |
| 10304 | South | Credit | $19.13 | Book | 22:55 | |
| 10305 | West | Credit | Web | $231.23 | Book | 0:00 |
| 10306 | East | Credit | $244.75 | Book | 10:13 | |
| 10307 | South | Paypal | Web | $21.36 | Online | 20:25 |
| 10308 | West | Credit | Web | $21.83 | Book | 1:01 |
| 10309 | South | Credit | $21.58 | Online | 1:01 | |
| 10310 | North | Paypal | $17.51 | Book | 20:19 | |
| 10311 | South | Paypal | Web | $23.29 | Online | 4:04 |
| 10312 | West | Paypal | Web | $18.35 | Book | 20:54 |
| 10313 | West | Credit | $23.06 | Online | 11:48 | |
| 10314 | South | Credit | Web | $19.81 | Online | 21:19 |
| 10315 | East | Credit | Web | $162.74 | Book | 9:09 |
| 10316 | East | Credit | Web | $16.86 | Online | 9:09 |
| 10317 | South | Credit | Web | $23.31 | Book | 16:23 |
| 10318 | West | Credit | $22.92 | Book | 0:00 | |
| 10319 | West | Credit | $22.84 | Online | 17:37 | |
| 10320 | North | Credit | Web | $16.97 | Online | 4:04 |
| 10321 | South | Credit | $188.16 | Book | 19:21 | |
| 10322 | West | Credit | Web | $22.57 | Online | 18:45 |
| 10323 | North | Paypal | Web | $24.71 | Online | 13:34 |
| 10324 | South | Credit | Web | $246.67 | Book | 16:47 |
| 10325 | South | Credit | Web | $20.97 | Book | 8:08 |
| 10326 | East | Paypal | $19.83 | Book | 4:04 | |
| 10327 | West | Paypal | $19.09 | Book | 11:45 | |
| 10328 | South | Credit | $16.52 | Book | 6:06 | |
| 10329 | South | Credit | $22.31 | Book | 2:02 | |
| 10330 | North | Credit | $19.52 | Online | 0:00 | |
| 10331 | West | Credit | Web | $24.79 | Online | 9:09 |
| 10332 | West | Credit | $18.84 | Online | 22:04 | |
| 10333 | East | Credit | Web | $24.58 | Online | 0:00 |
| 10334 | North | Credit | Web | $17.19 | Book | 12:19 |
| 10335 | East | Paypal | Web | $19.65 | Book | 6:06 |
| 10336 | South | Credit | Web | $17.35 | Book | 21:37 |
| 10337 | West | Paypal | Web | $22.92 | Online | 16:23 |
| 10338 | North | Credit | $18.81 | Online | 7:07 | |
| 10339 | West | Paypal | Web | $20.08 | Book | 3:03 |
| 10340 | West | Credit | $24.54 | Book | 4:04 | |
| 10341 | West | Paypal | Web | $24.81 | Book | 14:40 |
| 10342 | West | Paypal | $15.94 | Online | 0:00 | |
| 10343 | North | Paypal | Web | $18.29 | Online | 8:08 |
| 10344 | East | Credit | Web | $15.55 | Online | 6:06 |
| 10345 | West | Paypal | Web | $19.20 | Online | 20:52 |
| 10346 | West | Credit | $17.34 | Online | 18:10 | |
| 10347 | East | Paypal | $22.51 | Online | 5:05 | |
| 10348 | South | Paypal | $23.45 | Online | 2:02 | |
| 10349 | East | Paypal | Web | $16.15 | Online | 13:45 |
| 10350 | West | Paypal | Web | $17.68 | Book | 0:00 |
| 10351 | North | Credit | $22.11 | Book | 11:28 | |
| 10352 | West | Credit | Web | $18.41 | Online | 1:01 |
| 10353 | West | Paypal | Web | $17.08 | Online | 17:06 |
| 10354 | South | Paypal | Web | $15.77 | Online | 10:36 |
| 10355 | East | Credit | Web | $22.41 | Book | 7:07 |
| 10356 | North | Paypal | Web | $20.63 | Online | 3:03 |
| 10357 | South | Credit | $18.14 | Book | 3:03 | |
| 10358 | North | Credit | Web | $20.18 | Book | 11:13 |
| 10359 | West | Credit | $177.30 | Book | 11:33 | |
| 10360 | South | Paypal | Web | $15.71 | Online | 5:05 |
| 10361 | North | Credit | Web | $21.75 | Online | 17:22 |
| 10362 | South | Credit | $18.25 | Book | 5:05 | |
| 10363 | South | Credit | Web | $203.72 | Book | 14:29 |
| 10364 | West | Paypal | $15.54 | Book | 19:36 | |
| 10365 | West | Credit | Web | $17.50 | Online | 5:05 |
| 10366 | East | Credit | Web | $21.32 | Book | 2:02 |
| 10367 | East | Paypal | Web | $150.86 | Book | 13:17 |
| 10368 | West | Paypal | Web | $17.39 | Book | 4:04 |
| 10369 | East | Credit | Web | $23.87 | Online | 13:52 |
| 10370 | North | Credit | Web | $21.53 | Book | 16:04 |
| 10371 | North | Credit | Web | $19.64 | Online | 16:14 |
| 10372 | West | Paypal | Web | $18.27 | Book | 18:39 |
| 10373 | West | Credit | Web | $19.27 | Online | 6:06 |
| 10374 | North | Credit | Web | $20.16 | Book | 14:38 |
| 10375 | West | Credit | Web | $15.59 | Online | 4:04 |
| 10376 | South | Paypal | $16.34 | Online | 12:35 | |
| 10377 | East | Credit | Web | $199.18 | Book | 14:00 |
| 10378 | South | Paypal | Web | $19.99 | Book | 20:29 |
| 10379 | North | Credit | $18.44 | Online | 18:38 | |
| 10380 | West | Credit | Web | $23.75 | Book | 9:09 |
| 10381 | West | Credit | Web | $20.88 | Online | 0:00 |
| 10382 | South | Credit | Web | $197.43 | Book | 10:43 |
| 10383 | West | Credit | Web | $20.32 | Book | 18:33 |
| 10384 | South | Credit | Web | $16.82 | Online | 8:08 |
| 10385 | West | Paypal | Web | $20.16 | Book | 13:40 |
| 10386 | West | Credit | Web | $16.79 | Book | 21:27 |
| 10387 | North | Credit | $22.53 | Book | 11:41 | |
| 10388 | South | Paypal | $21.68 | Book | 14:32 | |
| 10389 | North | Paypal | $23.54 | Book | 6:06 | |
| 10390 | East | Paypal | Web | $17.67 | Online | 9:09 |
| 10391 | West | Credit | Web | $22.79 | Book | 0:00 |
| 10392 | East | Paypal | Web | $24.80 | Book | 18:09 |
| 10393 | South | Paypal | $15.27 | Book | 8:08 | |
| 10394 | West | Credit | $18.74 | Book | 22:41 | |
| 10395 | West | Credit | Web | $16.47 | Online | 20:26 |
| 10396 | West | Paypal | Web | $18.11 | Online | 0:00 |
| 10397 | West | Paypal | Web | $20.73 | Online | 17:46 |
| 10398 | West | Credit | Web | $21.64 | Online | 16:11 |
| 10399 | East | Credit | Web | $17.38 | Book | 16:14 |
| 10400 | West | Credit | Web | $17.70 | Online | 7:07 |
| 10401 | West | Credit | Web | $24.66 | Book | 17:07 |
| 10402 | West | Credit | Web | $24.24 | Online | 19:16 |
| 10403 | South | Paypal | $19.79 | Book | 7:07 | |
| 10404 | North | Credit | Web | $16.86 | Online | 8:08 |
| 10405 | North | Credit | Web | $19.97 | Online | 22:37 |
| 10406 | East | Credit | Web | $22.99 | Book | 9:09 |
| 10407 | North | Credit | Web | $153.83 | Book | 15:07 |
| 10408 | South | Credit | Web | $15.20 | Online | 15:03 |
| 10409 | West | Credit | Web | $16.01 | Online | 20:02 |
| 10410 | West | Paypal | Web | $18.88 | Online | 17:57 |
| 10411 | South | Credit | $21.54 | Book | 19:37 | |
| 10412 | East | Credit | Web | $24.11 | Book | 0:00 |
| 10413 | North | Paypal | Web | $21.43 | Book | 8:08 |
| 10414 | North | Credit | Web | $24.80 | Online | 0:00 |
| 10415 | West | Credit | Web | $19.76 | Online | 20:15 |
| 10416 | North | Credit | Web | $23.97 | Online | 18:39 |
| 10417 | North | Credit | Web | $19.96 | Online | 11:25 |
| 10418 | West | Credit | Web | $18.19 | Book | 1:01 |
| 10419 | East | Credit | Web | $17.28 | Online | 15:45 |
| 10420 | West | Credit | Web | $24.84 | Book | 8:08 |
| 10421 | South | Paypal | $16.32 | Book | 13:50 | |
| 10422 | North | Credit | Web | $23.47 | Book | 17:00 |
| 10423 | West | Credit | $16.65 | Book | 19:19 | |
| 10424 | East | Paypal | Web | $22.64 | Book | 11:53 |
| 10425 | North | Credit | Web | $16.66 | Book | 2:02 |
| 10426 | North | Credit | $21.78 | Book | 14:10 | |
| 10427 | West | Paypal | Web | $21.29 | Online | 14:14 |
| 10428 | North | Paypal | Web | $160.78 | Book | 14:47 |
| 10429 | West | Credit | Web | $21.10 | Book | 14:38 |
| 10430 | East | Credit | Web | $169.79 | Book | 20:13 |
| 10431 | West | Paypal | Web | $16.99 | Book | 3:03 |
| 10432 | North | Credit | $23.64 | Online | 8:08 | |
| 10433 | North | Credit | $18.92 | Book | 13:23 | |
| 10434 | West | Paypal | $23.96 | Book | 7:07 | |
| 10435 | South | Paypal | Web | $18.53 | Book | 21:20 |
| 10436 | West | Credit | Web | $24.44 | Online | 5:05 |
| 10437 | South | Credit | Web | $21.81 | Online | 5:05 |
| 10438 | South | Paypal | $18.25 | Online | 15:54 | |
| 10439 | East | Credit | Web | $17.42 | Book | 1:01 |
| 10440 | South | Credit | Web | $18.40 | Book | 10:25 |
| 10441 | North | Paypal | $23.88 | Online | 3:03 | |
| 10442 | West | Credit | Web | $17.76 | Book | 14:37 |
| 10443 | South | Credit | $23.06 | Book | 11:57 | |
| 10444 | West | Paypal | Web | $18.87 | Book | 16:33 |
| 10445 | West | Credit | Web | $17.87 | Online | 16:11 |
| 10446 | East | Credit | Web | $18.77 | Book | 15:09 |
| 10447 | North | Credit | Web | $18.60 | Online | 0:00 |
| 10448 | North | Credit | Web | $152.27 | Book | 6:06 |
| 10449 | North | Credit | Web | $20.83 | Book | 16:46 |
| 10450 | West | Credit | $21.47 | Book | 17:52 | |
| 10451 | West | Credit | Web | $218.60 | Book | 12:33 |
| 10452 | North | Paypal | Web | $163.37 | Book | 16:55 |
| 10453 | North | Paypal | Web | $24.78 | Book | 21:56 |
| 10454 | West | Credit | Web | $17.01 | Book | 7:07 |
| 10455 | South | Credit | Web | $231.23 | Book | 20:26 |
| 10456 | East | Credit | Web | $22.57 | Online | 15:02 |
| 10457 | West | Paypal | Web | $24.16 | Online | 11:02 |
| 10458 | South | Paypal | Web | $20.68 | Book | 21:51 |
| 10459 | South | Paypal | Web | $21.20 | Online | 7:07 |
| 10460 | West | Credit | Web | $247.14 | Book | 17:16 |
| 10461 | South | Credit | Web | $19.10 | Book | 13:04 |
| 10462 | South | Paypal | Web | $19.02 | Online | 22:07 |
| 10463 | East | Credit | Web | $19.66 | Book | 1:01 |
| 10464 | West | Credit | $168.10 | Book | 16:22 | |
| 10465 | West | Credit | Web | $16.83 | Book | 8:08 |
| 10466 | East | Credit | $23.89 | Book | 0:00 | |
| 10467 | South | Credit | Web | $16.73 | Online | 19:20 |
| 10468 | South | Credit | $22.05 | Online | 10:27 | |
| 10469 | North | Paypal | $17.88 | Book | 6:06 | |
| 10470 | West | Credit | $15.18 | Online | 19:25 | |
| 10471 | West | Paypal | Web | $15.62 | Online | 3:03 |
| 10472 | North | Credit | Web | $20.58 | Online | 18:02 |
| 10473 | West | Paypal | $17.28 | Online | 17:32 | |
| 10474 | West | Credit | Web | $24.38 | Online | 8:08 |
| 10475 | West | Credit | Web | $15.70 | Book | 1:01 |
| 10476 | North | Paypal | Web | $16.64 | Book | 21:58 |
| 10477 | West | Credit | $16.77 | Book | 18:15 | |
| 10478 | West | Credit | Web | $22.06 | Book | 18:21 |
| 10479 | West | Paypal | Web | $15.06 | Online | 21:31 |
| 10480 | West | Credit | Web | $17.70 | Book | 19:49 |
| 10481 | West | Credit | Web | $24.63 | Book | 19:34 |
| 10482 | East | Paypal | Web | $17.98 | Book | 8:08 |
| 10483 | North | Credit | $22.56 | Book | 13:32 | |
| 10484 | West | Credit | $17.95 | Book | 17:03 | |
| 10485 | West | Paypal | Web | $17.94 | Online | 15:44 |
| 10486 | West | Credit | Web | $15.72 | Online | 16:18 |
| 10487 | West | Paypal | $15.26 | Online | 20:34 | |
| 10488 | South | Paypal | Web | $15.33 | Online | 22:22 |
| 10489 | West | Credit | $18.88 | Book | 0:00 | |
| 10490 | North | Credit | Web | $18.51 | Book | 15:38 |
| 10491 | South | Credit | $18.73 | Online | 9:09 | |
| 10492 | South | Paypal | $18.69 | Online | 14:32 | |
| 10493 | West | Paypal | Web | $18.29 | Online | 21:02 |
| 10494 | West | Credit | $24.97 | Online | 15:32 | |
| 10495 | West | Paypal | Web | $22.91 | Book | 20:36 |
| 10496 | North | Paypal | $16.62 | Book | 9:09 | |
| 10497 | West | Paypal | $21.73 | Book | 17:31 | |
| 10498 | East | Credit | Web | $15.92 | Online | 0:00 |
| 10499 | South | Paypal | $20.77 | Book | 20:55 | |
| 10500 | West | Credit | Web | $228.08 | Book | 14:57 |
| 10501 | North | Credit | $22.14 | Book | 20:01 | |
| 10502 | North | Credit | Web | $17.73 | Book | 5:05 |
| 10503 | West | Credit | Web | $22.28 | Online | 17:39 |
| 10504 | West | Credit | Web | $19.92 | Book | 16:53 |
| 10505 | South | Credit | Web | $17.83 | Online | 6:06 |
| 10506 | South | Credit | Web | $16.35 | Book | 22:29 |
| 10507 | West | Paypal | Web | $23.70 | Book | 20:43 |
| 10508 | South | Credit | Web | $22.02 | Online | 11:55 |
| 10509 | East | Paypal | Web | $23.53 | Online | 21:52 |
| 10510 | North | Credit | Web | $24.63 | Book | 4:04 |
Answer these questions using your Pivot Table:
1. Where do most of our customers come from? The answer might tell managers where to spend more marketing resources or to initiate new marketing efforts.
2. 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.
3. What form of payment is the most common? The answer could be used to emphasize in advertising the most preferred means of payment. Are there any times of day when purchases are most common? Do people buy products while at work (likely during the day) or at home (likely in the evening)?
4. Are there regional differences in the average purchase? If one region is much more lucrative, managers could focus their marketing and advertising resources on that region.
5. Are there regional differences in the sources of our customers? Perhaps in some regions, e-mail is the most effective marketing tool, whereas in other regions, Web banner ads are more effective. The answer to this more complicated question could help managers develop a regional marketing strategy.
Expert Answer:
Posted Date:
