[SOLVED] excel work help – Business Finance

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

Purchase answer to see full
attachment

Why Choose Us

• 100% non-plagiarized Papers
• 24/7 /365 Service Available
• Affordable Prices
• Any Paper, Urgency, and Subject
• Will complete your papers in 6 hours
• On-time Delivery
• Money-back and Privacy guarantees
• Unlimited Amendments upon request
• Satisfaction guarantee

How it Works

• Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
• Fill in your paper’s requirements in the "PAPER DETAILS" section.
• Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
• Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
• From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.