FREE Trial
Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

BADB1023: : Management Information System Based on the data sets involving OMT below, you will develop pivot tables. Lab Exercise 2: Pivot Table Online Management

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 Email $23.51 Book 15:38
10005 South Credit Web $15.33 Book 15:21
10006 West Paypal Email $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 Email $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 Email $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 Email $17.16 Book 5:05
10022 West Credit Web $205.58 Book 20:42
10023 South Credit Email $18.12 Book 10:12
10024 West Credit Web $20.04 Online 16:27
10025 West Paypal Email $23.21 Online 20:22
10026 West Credit Email $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 Email $206.80 Book 18:14
10031 North Paypal Email $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 Email $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 Email $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 Email $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 Email $20.13 Online 13:55
10064 North Credit Email $20.77 Online 13:34
10065 North Credit Email $16.98 Online 19:21
10066 East Credit Email $19.40 Book 15:02
10067 East Paypal Email $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 Email $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 Email $21.58 Online 0:00
10074 North Paypal Email $16.09 Book 3:03
10075 East Credit Email $16.10 Online 10:13
10076 East Credit Web $15.95 Online 0:00
10077 South Credit Email $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 Email $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 Email $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 Email $18.20 Online 5:05
10091 East Credit Email $17.31 Book 0:00
10092 West Credit Web $23.94 Book 16:08
10093 West Paypal Email $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 Email $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 Email $21.64 Book 22:40
10104 West Paypal Email $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 Email $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 Email $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 Email $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 Email $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 Email $19.30 Online 17:00
10132 East Credit Email $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 Email $24.03 Online 11:14
10137 West Credit Web $24.59 Online 4:04
10138 West Paypal Email $155.91 Book 18:38
10139 East Credit Email $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 Email $15.71 Book 9:09
10149 West Paypal Web $24.65 Book 20:41
10150 West Paypal Email $24.88 Book 15:23
10151 East Paypal Email $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 Email $21.39 Book 17:17
10160 South Credit Email $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 Email $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 Email $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 Email $24.40 Book 13:25
10182 South Credit Web $19.37 Book 21:48
10183 West Credit Email $19.17 Online 0:00
10184 South Credit Email $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 Email $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 Email $24.86 Book 17:27
10201 North Credit Email $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 Email $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 Email $192.41 Book 20:23
10213 South Credit Email $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 Email $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 Email $16.34 Book 17:53
10224 West Credit Web $19.19 Book 19:08
10225 West Credit Email $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 Email $15.34 Book 10:08
10231 North Paypal Web $216.20 Book 10:33
10232 East Credit Email $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 Email $20.42 Book 0:00
10237 West Credit Email $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 Email $161.50 Book 16:15
10245 South Credit Email $21.92 Online 6:06
10246 West Credit Web $23.75 Online 20:34
10247 West Credit Email $23.74 Online 3:03
10248 West Paypal Web $21.67 Book 12:41
10249 West Paypal Email $22.04 Book 3:03
10250 North Paypal Email $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 Email $209.20 Book 17:19
10254 East Credit Email $24 Book 11:52
10255 West Credit Web $17.81 Book 12:36
10256 West Paypal Email $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 Email $242.40 Book 17:19
10267 West Paypal Web $23.01 Online 17:44
10268 East Credit Email $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 Email $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 Email $20.28 Book 6:06
10282 South Paypal Email $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 Email $24.71 Book 16:22
10292 East Credit Web $20.97 Book 11:17
10293 West Credit Email $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 Email $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 Email $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 Email $19.13 Book 22:55
10305 West Credit Web $231.23 Book 0:00
10306 East Credit Email $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 Email $21.58 Online 1:01
10310 North Paypal Email $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 Email $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 Email $22.92 Book 0:00
10319 West Credit Email $22.84 Online 17:37
10320 North Credit Web $16.97 Online 4:04
10321 South Credit Email $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 Email $19.83 Book 4:04
10327 West Paypal Email $19.09 Book 11:45
10328 South Credit Email $16.52 Book 6:06
10329 South Credit Email $22.31 Book 2:02
10330 North Credit Email $19.52 Online 0:00
10331 West Credit Web $24.79 Online 9:09
10332 West Credit Email $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 Email $18.81 Online 7:07
10339 West Paypal Web $20.08 Book 3:03
10340 West Credit Email $24.54 Book 4:04
10341 West Paypal Web $24.81 Book 14:40
10342 West Paypal Email $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 Email $17.34 Online 18:10
10347 East Paypal Email $22.51 Online 5:05
10348 South Paypal Email $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 Email $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 Email $18.14 Book 3:03
10358 North Credit Web $20.18 Book 11:13
10359 West Credit Email $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 Email $18.25 Book 5:05
10363 South Credit Web $203.72 Book 14:29
10364 West Paypal Email $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 Email $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 Email $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 Email $22.53 Book 11:41
10388 South Paypal Email $21.68 Book 14:32
10389 North Paypal Email $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 Email $15.27 Book 8:08
10394 West Credit Email $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 Email $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 Email $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 Email $16.32 Book 13:50
10422 North Credit Web $23.47 Book 17:00
10423 West Credit Email $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 Email $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 Email $23.64 Online 8:08
10433 North Credit Email $18.92 Book 13:23
10434 West Paypal Email $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 Email $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 Email $23.88 Online 3:03
10442 West Credit Web $17.76 Book 14:37
10443 South Credit Email $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 Email $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 Email $168.10 Book 16:22
10465 West Credit Web $16.83 Book 8:08
10466 East Credit Email $23.89 Book 0:00
10467 South Credit Web $16.73 Online 19:20
10468 South Credit Email $22.05 Online 10:27
10469 North Paypal Email $17.88 Book 6:06
10470 West Credit Email $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 Email $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 Email $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 Email $22.56 Book 13:32
10484 West Credit Email $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 Email $15.26 Online 20:34
10488 South Paypal Web $15.33 Online 22:22
10489 West Credit Email $18.88 Book 0:00
10490 North Credit Web $18.51 Book 15:38
10491 South Credit Email $18.73 Online 9:09
10492 South Paypal Email $18.69 Online 14:32
10493 West Paypal Web $18.29 Online 21:02
10494 West Credit Email $24.97 Online 15:32
10495 West Paypal Web $22.91 Book 20:36
10496 North Paypal Email $16.62 Book 9:09
10497 West Paypal Email $21.73 Book 17:31
10498 East Credit Web $15.92 Online 0:00
10499 South Paypal Email $20.77 Book 20:55
10500 West Credit Web $228.08 Book 14:57
10501 North Credit Email $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.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management

Operations Management

Authors: R. Dan Reid, Nada R. Sanders

4th edition

9780470556702, 470325046, 470556706, 978-0470325049

More Books

Students also viewed these General Management questions

Question

CoursHeroTranscribedText: Question 1 The daily volume of a brokerage company follows a normal distribution. The director wants to estimate the daily volume negotiated. a) What size should have a...

Answered: 1 week ago

Question

★★★★★
Develop a spreadsheet model for Classify each of the data elements in the Sales Transactions database (Figure 1.1) as categorical, ordinal, interval, or ratio data and explain why. Apply the...

Answered: 1 week ago

Question

★★★★★
Consider the following information: Rate of Return if State Occurs State of Economy Boom :57 Bust of Economy .66 .34 Probability of State Stock A .09 .13 Stock B Stock C .03 .19 .24 -.04 a. What is...

Answered: 1 week ago

Question

★★★★★
What is the average US Gross of movies? What is the average Budget of movies? What is the average Run time of movies? Place the plot of Budget and US Gross here.

Answered: 1 week ago

Question

★★★★★
Europa Publications, Inc. specializes in reference honks that keep abreast of the rapidly changing political and economic issues in Europe. The results of the companys operations during the prior...

Answered: 1 week ago

Question

★★★★★
For the year ending December 31, 2014, Cobb Company accumulates the following data for the Plastics Division which it operates as an investment center: contribution margin$700,000 budget, $710,000...

Answered: 1 week ago

Question

★★★★★
1. Compare and contrast the Moffitt theory with the Sampson and Laub theory on the development of delinquency.

Answered: 1 week ago

Question

★★★★★
Is JetBlue likely to continue being successful in building customer relationships? Why or why not? In 2007, JetBlue was a thriving young airline with a strong reputation for outstanding service. In...

Answered: 1 week ago

Question

★★★★★
A project requires the purchase (in year 0 ) of a machine for $419,000. The firm will depreciate the machine to zero salvage value over its life of 7 years. The project will also generate incremental...

Answered: 1 week ago

Question

★★★★★
Russell (birthdate February 2, 1969) and Linda (birthdate August 30, 1974) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and...

Answered: 1 week ago

Question

★★★★★
2. The length of the strings on a grand piano are chosen to obtain the required pitch (or fundamental frequency). Modern pianos are usually tuned so that, letting n be the nth key from the left, and...

Answered: 1 week ago

Question

★★★★★
Using a sample space S = {1, 2, 3, 4} with Pr(i) = 1/4 and A = {1, 2} find examples of events B,C and D where Pr(A | B) Pr(A). Let E = {1, 2, 3}, F = {2,...

Answered: 1 week ago

Question

★★★★★
Question 2 Bramble Ltd. is authorized to issue 10,000, $6 noncumulative preferred shares. On January 13, it issued 2,700 preferred shares for $85 cash per share. Prepare the journal entry to record...

Answered: 1 week ago

Question

★★★★★
Mackenzie Corp. is preparing the December 31, 2023, year-end financial statements. Following are selected unadjusted account balances: Estimated warranty liability $ 6,650 Income tax expense Mortgage...

Answered: 1 week ago

Question

★★★★★
A driver in a moving car applies the brakes. The car slows to a final speed of 2.95 m/s over a distance of 40.0 m and a time interval of 7.70 s. The acceleration while braking is approximately...

Answered: 1 week ago

Question

★★★★★
2. (40 pts) The Howard County Hospital is assessing its Emergency Department (ED) capacity so it knows how to expand as the county population grows. The hospital has the following information about...

Answered: 1 week ago

Question

★★★★★
Java language and please include the screenshot of the output ory Bookmarks Tools Window Help Home | Hacker101 https://blackboard stockt Unit II Practical Attached Files: BallToss java (955 8)...

Answered: 1 week ago

Question

★★★★★
How does the organizational structure of an MNC influence its strategy implementation?

Answered: 1 week ago

Question

★★★★★
In what ways is the demand/withdraw pattern influenced by culture?

Answered: 1 week ago

Question

★★★★★
What kinds of problems might be unique to homosexual couples? To heterosexual couples?

Answered: 1 week ago

Question

★★★★★
What does it mean that women are the emotional barometer in a relationship?

Answered: 1 week ago

Previous Question Next Question