Business analytics 2 Excel Data File (ch 2 smartbook)

Description

Each question has a data excel spreadsheet that will need to be used in order to answer the question (there are five sets of questions all together i just ran out of room for the rest of the files)

Don't use plagiarized sources. Get Your Custom Assignment on
Business analytics 2 Excel Data File (ch 2 smartbook)
From as Little as $13/Page

Unformatted Attachment Preview

LastTransactionDate
5/20/2017
8/16/2018
10/22/2017
3/18/2017
1/15/2017
5/31/2018
3/18/2017
1/26/2017
1/15/2018
1/15/2018
10/24/2017
4/3/2018
7/28/2017
2/23/2017
3/17/2017
6/3/2018
2/28/2018
5/5/2017
8/19/2018
5/3/2017
8/8/2017
9/6/2017
8/8/2017
8/25/2018
9/18/2017
2/1/2018
1/12/2017
6/27/2018
8/30/2018
6/10/2017
1/8/2018
5/20/2017
1/12/2018
7/14/2017
1/16/2018
5/21/2017
1/15/2017
4/7/2017
4/12/2017
9/19/2018
4/16/2017
3/21/2017
7/18/2017
4/28/2017
1/13/2018
2/20/2017
Frequency
407
454
398
95
472
429
114
127
340
498
142
426
498
342
280
173
348
441
478
214
435
467
369
47
410
112
199
430
132
421
212
135
322
341
408
401
342
361
357
37
476
74
252
419
184
348
TotalSpending
41903
35918
90138
38068
12649
81922
35510
2104
54785
15445
9070
9281
79742
50802
75526
87778
18809
73938
62887
3754
98567
73877
12098
74101
21248
99325
62240
48229
94055
94950
83898
35174
59407
1959
6222
6869
58784
87110
38309
33898
38530
90699
17934
68055
11233
66212
6/24/2018
6/12/2018
10/13/2017
6/4/2017
6/9/2017
12/19/2017
2/11/2017
8/11/2018
5/11/2018
4/27/2018
5/17/2017
3/9/2018
5/3/2018
7/27/2018
1/24/2018
7/21/2017
7/11/2017
10/7/2018
2/14/2017
8/11/2017
9/4/2018
8/25/2018
3/28/2018
4/4/2017
2/28/2017
5/1/2018
12/15/2017
5/18/2018
5/13/2018
3/4/2017
6/7/2017
10/27/2018
7/17/2017
4/17/2017
12/13/2017
2/11/2017
2/8/2017
9/26/2017
9/29/2017
11/5/2017
8/9/2017
10/25/2018
8/23/2018
10/30/2017
4/2/2017
6/22/2018
11/18/2017
330
328
301
358
174
49
433
421
447
236
153
102
92
271
405
476
201
472
253
387
496
202
72
93
131
99
208
416
320
377
298
173
104
411
194
252
36
167
211
439
393
43
302
452
290
216
452
27666
99893
28822
61561
43822
14787
17368
51515
64139
24636
51118
97597
58045
42809
56691
8454
28039
66126
16901
82491
78658
85337
7707
79496
49835
23738
73734
77605
31733
31379
10990
871
62012
54796
31079
77797
85079
43450
34979
47439
69868
60852
51489
52068
36179
87808
66355
5/7/2017
4/23/2017
2/25/2017
3/30/2018
1/15/2017
6/6/2017
10/4/2018
7/30/2018
9/17/2017
12/5/2017
7/14/2018
12/13/2017
3/23/2017
4/4/2018
10/2/2017
2/16/2017
5/19/2017
7/24/2018
5/16/2018
7/27/2018
12/27/2017
5/22/2018
3/3/2018
12/29/2017
6/18/2017
7/19/2017
3/28/2018
8/15/2018
9/3/2017
9/28/2018
1/5/2018
7/29/2017
2/26/2017
1/13/2017
5/14/2017
3/29/2018
4/14/2018
9/29/2018
6/24/2017
5/22/2018
3/1/2017
5/23/2017
12/26/2017
2/24/2018
10/30/2017
4/16/2017
5/22/2017
156
293
336
40
421
339
205
441
208
110
369
92
499
237
468
275
150
296
32
91
330
259
372
189
254
122
183
77
61
153
257
55
290
107
389
291
439
347
399
352
317
193
135
59
292
242
151
9398
38447
76362
27081
62775
40509
25400
39151
4417
33167
3805
68284
53565
52203
87563
65212
51287
83074
35092
24024
62626
2744
48638
24837
30391
68307
50775
58786
50439
98854
30694
8907
3103
91861
3945
81141
55284
81608
24679
72740
26660
83761
61779
53534
5409
49843
2542
2/22/2018
1/17/2017
8/2/2018
7/23/2017
11/17/2017
8/8/2018
1/7/2017
3/10/2018
6/16/2017
5/31/2018
7/15/2017
5/7/2018
12/28/2017
11/15/2017
8/22/2017
2/6/2017
3/23/2018
3/16/2018
11/8/2017
2/12/2018
1/29/2018
6/15/2018
4/25/2018
9/3/2017
1/27/2017
5/4/2018
4/9/2017
4/14/2018
2/19/2018
7/31/2017
6/3/2018
2/4/2017
7/31/2018
10/10/2018
4/23/2017
8/10/2017
7/30/2018
2/8/2018
11/2/2017
11/18/2017
8/30/2018
3/19/2018
4/28/2018
8/9/2017
10/27/2018
9/5/2018
4/26/2018
258
495
295
167
422
186
489
142
46
48
36
130
316
467
456
420
270
274
341
91
420
373
364
333
89
221
466
470
299
81
468
444
118
325
391
396
280
150
364
252
455
56
391
223
260
193
445
16025
42922
34825
96373
28736
76243
81911
72129
30712
44485
24022
53103
18634
91113
81200
37089
33167
10645
92259
49900
90634
2390
66438
18649
99901
57565
67351
76579
21969
26998
23103
82335
21490
44822
34047
80877
15692
6394
33758
3715
53038
18704
18682
33483
12163
65445
55284
2/23/2017
9/4/2018
1/18/2017
7/22/2018
10/18/2017
3/5/2017
6/21/2018
3/20/2018
1/25/2017
3/9/2018
10/2/2018
6/24/2017
8/14/2017
267
113
403
434
481
106
101
48
39
330
348
315
49
86645
57781
53594
30433
93731
45400
42058
20197
42663
8582
92986
92100
27918
Package
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
Status
Delivered
Lost
Delivered
Delivered
Damaged
Lost
Lost
Lost
Lost
Delivered
Lost
Delivered
Damaged
Delivered
Lost
Lost
Damaged
Damaged
Lost
Damaged
Delivered
Damaged
Damaged
Lost
Delivered
Damaged
Delivered
Lost
Delivered
Delivered
Damaged
Delivered
Delivered
Delivered
Lost
Lost
Delivered
Delivered
Damaged
Lost
Lost
Delivered
Lost
Lost
Lost
Lost
Delivery
Standard
Express
Standard
Standard
Standard
Same day
Standard
Express
Express
Standard
Standard
Express
Standard
Express
Same day
Express
Standard
Standard
Standard
Standard
Standard
Express
Standard
Same day
Standard
Standard
Standard
Standard
Same day
Same day
Standard
Standard
Standard
Express
Express
Standard
Standard
Same day
Express
Standard
Standard
Express
Same day
Standard
Express
Standard
Size
M
M
L
M
M
XL
XL
S
M
L
S
M
M
M
L
XL
M
S
S
L
S
L
L
L
M
L
S
L
M
M
M
XL
XL
XL
XL
XL
L
M
S
L
S
S
XL
M
XL
XL
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
Damaged
Damaged
Damaged
Damaged
Delivered
Lost
Damaged
Damaged
Delivered
Lost
Delivered
Damaged
Damaged
Lost
Delivered
Lost
Delivered
Delivered
Delivered
Lost
Lost
Lost
Damaged
Damaged
Delivered
Lost
Lost
Delivered
Delivered
Standard
Express
Same day
Standard
Standard
Same day
Standard
Express
Standard
Express
Standard
Standard
Standard
Express
Standard
Standard
Standard
Express
Same day
Standard
Express
Standard
Standard
Same day
Express
Express
Standard
Express
Same day
M
XL
S
M
S
XL
L
XL
M
S
M
L
L
S
M
XL
S
M
L
XL
M
S
S
M
L
L
L
L
S
x1
x2
1
0
0
1
0
1
1
0
0
0
0
0
0
0
0
1
0
1
0
0
0
0
0
0
0
1
0
0
1
0
1
0
0
0
1
0
0
0
0
0
0
0
0
0
0
x3
Own
Rent
Rent
Own
Rent
Own
Own
Rent
Rent
Rent
Rent
Rent
Rent
Own
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Own
Rent
Rent
Own
Rent
Own
Rent
Rent
Rent
Own
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
x4
189
120
204
151
140
187
119
148
140
128
108
155
166
213
156
118
158
141
162
117
134
177
117
166
120
142
130
131
160
98
140
166
167
146
143
150
132
101
135
112
94
33
28
24
17
20
15
37
23
23
22
26
39
14
20
24
37
10
17
19
36
29
16
14
17
16
15
19
23
23
26
22
24
14
39
26
43
27
34
31
38
6
24
27
28
10
41
x5
0.054587
0.009077
0.93814
0.020797
0.008174
0.143977
0.192234
0.01414
0.010242
0.004495
0.000147
0.057231
0.015253
0.022706
0.969233
0.007268
0.00713
0.464121
0.002375
0.008515
0.021796
0.160323
0.004233
0.003056
0.683372
0.00267
0.01753
0.867974
0.36321
0.468196
0.029088
0.089045
0.003414
0.005908
0.005501
0.001544
0.004931
0.111923
0.031036
0.028299
0.050226
0.016332
0.003604
0.019936
0.00407
0
0
0
0
0
1
Rent
Rent
Rent
Rent
Rent
Own
0
0
0
0
0
0
0
0
0
1
0
0
0
1
0
0
1
1
0
0
0
0
0
0
1
0
0
0
0
0
0
0
0
0
0
0
0
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Own
Rent
0
0
Rent
Own
Rent
Rent
Own
Own
Rent
Rent
Rent
Rent
Rent
Rent
Own
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
Rent
155
140
171
157
166
123
138
99
201
95
153
158
144
132
140
156
150
148
192
201
170
119
114
154
124
130
133
189
178
160
157
163
159
128
163
160
140
159
128
169
137
139
125
126
151
172
138
12
11
18
21
36
14
23
9
2
26
25
4
16
12
25
9
14
25
11
26
22
25
52
19
22
30
8
33
20
14
33
24
13
8
7
20
28
14
19
18
28
22
0.525924
0.094654
0.015012
0.108886
0.193048
0.00063
0.394119
0.002161
0.000957
0.212033
0.001528
0.991581
0.003358
0.027852
0.002714
0.043913
0.245807
0.027565
0.023534
0.023674
0.428712
0.000883
0.002865
0.069552
0.047958
0.036604
0.000117
0.038614
0.680381
0.007326
0.003768
0.048316
0.562921
0.002629
0.272405
0.417452
0.001083
0.546549
0.00047
0.005424
0.000896
0.001067
0.000346
38
23 0.159971
30 0.003076
0
0
0
0
0
1
1
Rent
Rent
Rent
Rent
Rent
Own
Own
124
191
147
128
154
126
136
30
37
10
13
14
5
23
0.001804
0.314209
0.666483
0.000385
0.036317
0.000457
0.827123
State
.Alabama
.Alaska
.Arizona
.Arkansas
.California
.Colorado
.Connecticut
.Delaware
.Florida
.Georgia
.Hawaii
.Idaho
.Illinois
.Indiana
.Iowa
.Kansas
.Kentucky
.Louisiana
.Maine
.Maryland
.Massachusetts
.Michigan
.Minnesota
.Mississippi
.Missouri
.Montana
.Nebraska
.Nevada
.New Hampshire
.New Jersey
.New Mexico
.New York
.North Carolina
.North Dakota
.Ohio
.Oklahoma
.Oregon
.Pennsylvania
.Rhode Island
.South Carolina
.South Dakota
.Tennessee
.Texas
.Utah
.Vermont
.Virginia
2010
2011
2012
2013
2014
2015
2016
4,785,448
713,906
6,407,774
2,921,978
37,320,903
5,048,281
3,579,125
899,595
18,845,785
9,711,810
1,363,963
1,570,773
12,840,762
6,490,436
3,050,767
2,858,213
4,348,200
4,544,532
1,327,632
5,788,642
6,566,431
9,877,535
5,310,843
2,970,536
5,995,976
990,722
1,829,536
2,702,464
1,316,777
8,799,624
2,064,588
19,400,080
9,574,293
674,710
11,539,327
3,759,632
3,837,532
12,711,158
1,053,938
4,635,656
816,165
6,355,301
25,242,679
2,775,334
625,880
8,023,680
4,798,834
722,038
6,473,497
2,940,407
37,641,823
5,121,771
3,588,023
907,316
19,093,352
9,801,578
1,379,252
1,583,828
12,867,291
6,516,045
3,066,054
2,869,035
4,369,488
4,575,184
1,328,150
5,838,991
6,613,149
9,881,521
5,345,668
2,978,470
6,009,641
997,221
1,840,538
2,712,799
1,319,815
8,827,783
2,080,395
19,498,514
9,656,754
685,136
11,543,463
3,787,821
3,871,728
12,744,583
1,053,536
4,671,422
823,484
6,397,410
25,646,227
2,814,216
626,979
8,100,469
4,815,564
730,399
6,556,629
2,952,109
37,960,782
5,193,721
3,594,395
915,188
19,326,230
9,901,496
1,394,905
1,595,441
12,884,119
6,537,640
3,076,097
2,885,361
4,386,381
4,600,814
1,327,691
5,887,072
6,663,158
9,896,930
5,376,550
2,983,767
6,024,081
1,003,754
1,853,323
2,744,566
1,323,962
8,845,483
2,087,549
19,574,549
9,749,123
701,116
11,548,369
3,818,600
3,899,118
12,766,827
1,054,601
4,717,112
833,496
6,451,281
26,089,620
2,853,467
626,063
8,185,229
4,830,460
737,045
6,634,999
2,959,549
38,280,824
5,270,482
3,594,915
923,638
19,563,166
9,973,326
1,408,453
1,611,530
12,898,269
6,568,367
3,093,078
2,893,510
4,404,817
4,624,577
1,328,196
5,923,704
6,713,944
9,913,349
5,413,693
2,988,797
6,040,658
1,013,564
1,865,414
2,776,972
1,326,408
8,858,362
2,092,792
19,628,043
9,843,599
721,999
11,576,576
3,853,205
3,922,908
12,776,621
1,055,122
4,764,153
842,270
6,493,432
26,489,464
2,897,927
626,212
8,253,053
4,842,481
736,307
6,733,840
2,967,726
38,625,139
5,351,218
3,594,783
932,596
19,860,330
10,069,001
1,414,862
1,631,479
12,888,962
6,593,533
3,109,504
2,900,896
4,414,483
4,644,204
1,330,760
5,958,165
6,763,652
9,930,589
5,451,522
2,990,623
6,056,293
1,021,891
1,879,522
2,819,012
1,333,223
8,866,780
2,090,342
19,656,330
9,933,944
737,382
11,602,973
3,878,367
3,964,106
12,789,101
1,056,017
4,823,793
849,088
6,540,826
26,977,142
2,937,399
625,218
8,312,076
4,853,160
737,547
6,833,596
2,978,407
38,953,142
5,452,107
3,587,509
941,413
20,224,249
10,181,111
1,422,484
1,651,523
12,864,342
6,608,296
3,121,460
2,909,502
4,425,999
4,664,851
1,328,484
5,986,717
6,795,891
9,932,573
5,482,503
2,988,693
6,071,745
1,030,503
1,891,507
2,868,666
1,336,294
8,870,869
2,090,211
19,661,411
10,033,079
754,022
11,617,850
3,909,831
4,016,918
12,785,759
1,056,173
4,892,253
853,933
6,590,808
27,486,814
2,982,497
625,197
8,362,907
4,864,745
741,504
6,945,452
2,990,410
39,209,127
5,540,921
3,578,674
949,216
20,629,982
10,304,763
1,428,105
1,682,930
12,826,895
6,633,344
3,131,785
2,911,263
4,438,229
4,678,215
1,331,370
6,004,692
6,826,022
9,951,890
5,523,409
2,988,298
6,087,203
1,040,863
1,905,924
2,919,772
1,342,373
8,874,516
2,092,789
19,641,589
10,156,679
754,353
11,635,003
3,926,769
4,091,404
12,783,538
1,057,063
4,958,235
862,890
6,645,011
27,937,492
3,042,613
623,644
8,410,946
.Washington
.West Virginia
.Wisconsin
.Wyoming
6,742,902
1,854,214
5,690,479
564,483
6,821,655
1,856,074
5,704,755
567,224
6,892,876
1,856,764
5,719,855
576,270
6,962,906
1,853,873
5,736,952
582,123
7,052,439
1,849,467
5,751,974
582,548
7,163,543
1,841,996
5,761,406
585,668
7,294,680
1,830,929
5,772,958
584,290
2017
2018
4,875,120
739,786
7,048,876
3,002,997
39,399,349
5,615,902
3,573,880
957,078
20,976,812
10,413,055
1,424,203
1,718,904
12,786,196
6,660,082
3,143,637
2,910,689
4,453,874
4,670,818
1,335,063
6,024,891
6,863,246
9,976,447
5,568,155
2,989,663
6,108,612
1,053,090
1,917,575
2,972,405
1,349,767
8,888,543
2,093,395
19,590,719
10,270,800
755,176
11,664,129
3,932,640
4,146,592
12,790,447
1,056,486
5,021,219
873,286
6,708,794
28,322,717
3,103,118
624,525
8,465,207
4,887,871
737,438
7,171,646
3,013,825
39,557,045
5,695,564
3,572,665
967,171
21,299,325
10,519,475
1,420,491
1,754,208
12,741,080
6,691,878
3,156,145
2,911,505
4,468,402
4,659,978
1,338,404
6,042,718
6,902,149
9,995,915
5,611,179
2,986,530
6,126,452
1,062,305
1,929,268
3,034,392
1,356,458
8,908,520
2,095,428
19,542,209
10,383,620
760,077
11,689,442
3,943,079
4,190,713
12,807,060
1,057,315
5,084,127
882,235
6,770,010
28,701,845
3,161,105
626,299
8,517,685
7,425,432
1,817,048
5,792,051
578,934
7,535,591
1,805,832
5,813,568
577,737

Purchase answer to see full
attachment