Hello. Can anyone kindly assist me with the attached excel project.
excel_homework.xls
Unformatted Attachment Preview
Please answer each question including calculations in a separate excel tab; explain your answers if necessary. Al
1.
How many new classic food boxes and how many vegetarian food boxes did we sell? (Use column C from tab Data, solve
2.
Via which marketing channel did we sell most food boxes? (Use column D from tab Data, solve question with a pivot tab
3.
How many customers purchased more than 1 product? (Hint: Customer ID stays the same per customer when he/she bu
4.
What was the earliest and what was the latest time of the day we sold a product on 14.04.2015? Use column A from tab
5.
How many products did we sell for 2 people and how many products did we sell for 4 people? (Use column D tab Data, e
6.
How many veggie food boxes (hint: column C) did we sell on 14.04.2015 (hint: column A) via marketing channel Newslet
7.
Prepare an additional column in tab Data, in which you convert format “Date Time” from column A into format “Date” w
8.
Count how many food boxes “Classic – 3 meals per week for 2 people” we sold via marketing channel “TV / Radio Advert
9.
Prepare a chart that shows sold food boxes per marketing channel in San Diego
10. Which customer ID bought most food boxes? Explain how you determined relevant customer ID and note down which c
11. In an additional column in tab Data, mark all boxes sold in “New York” via Marketing channel “Newsletters (internal)” wi
12. Create an additional column in tab Data that shows state from tab State (Explain procedure)
ur answers if necessary. All relevant data in tab Data which shows one row per sold product (food box)
lumn A into format “Date” with a formula and prepare an overview how many classic food boxes and how many veggie food boxes we so
ow many veggie food boxes we sold per “Date”
date_sign_up
customer_id
4/17/2015 13:11
71041
4/14/2015 11:32
103289
4/14/2015 9:53
107746
4/14/2015 16:08
157441
4/18/2015 8:04
158646
4/18/2015 15:41
178843
4/15/2015 9:45
179297
4/15/2015 8:21
182439
4/17/2015 6:57
186180
4/19/2015 20:39
190396
4/14/2015 10:26
194229
4/13/2015 20:17
194353
4/15/2015 14:43
200286
4/16/2015 7:35
201307
4/15/2015 6:54
203319
4/14/2015 8:35
205233
4/13/2015 12:08
205322
4/16/2015 5:04
205611
4/15/2015 12:17
208066
4/14/2015 17:42
208079
4/15/2015 9:58
209055
4/14/2015 5:51
213420
4/15/2015 20:30
213584
4/14/2015 15:43
213711
4/16/2015 9:35
214129
4/13/2015 8:10
214667
4/15/2015 18:56
214779
4/17/2015 5:14
215253
4/13/2015 17:48
215309
4/13/2015 17:02
215319
4/14/2015 17:21
215332
4/13/2015 8:50
215381
4/13/2015 16:38
215386
4/16/2015 9:30
215505
4/13/2015 9:09
215561
4/13/2015 2:24
215609
4/13/2015 4:27
215627
4/13/2015 5:00
215635
4/13/2015 5:15
215640
4/13/2015 5:22
215642
4/13/2015 5:46
215662
4/13/2015 6:15
215668
4/13/2015 6:23
215686
4/13/2015 7:02
215723
4/13/2015 7:16
215757
4/13/2015 7:26
215760
4/13/2015 7:29
215768
4/13/2015 7:32
215777
4/13/2015 7:58
215811
product_name
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
4/13/2015 8:09
4/13/2015 8:12
4/13/2015 14:06
4/13/2015 8:21
4/13/2015 8:35
4/13/2015 8:38
4/13/2015 8:45
4/13/2015 8:50
4/13/2015 9:01
4/13/2015 9:21
4/13/2015 9:22
4/13/2015 9:30
4/13/2015 9:36
4/13/2015 9:38
4/13/2015 10:01
4/13/2015 10:14
4/13/2015 13:01
4/13/2015 10:23
4/13/2015 10:19
4/13/2015 10:24
4/13/2015 10:56
4/13/2015 11:00
4/13/2015 11:21
4/13/2015 11:43
4/13/2015 11:46
4/13/2015 11:52
4/13/2015 12:38
4/13/2015 12:40
4/13/2015 13:11
4/13/2015 13:17
4/13/2015 13:30
4/13/2015 13:34
4/13/2015 13:39
4/13/2015 13:44
4/13/2015 14:12
4/13/2015 13:56
4/13/2015 14:21
4/13/2015 14:23
4/13/2015 14:33
4/13/2015 14:50
4/13/2015 15:38
4/13/2015 15:35
4/13/2015 15:35
4/13/2015 15:40
4/13/2015 15:42
4/13/2015 15:45
4/13/2015 15:46
4/13/2015 15:52
4/13/2015 15:53
4/13/2015 16:17
215827
215835
215845
215849
215866
215886
215899
215911
215926
215957
215960
215976
215980
215992
216034
216038
216049
216058
216066
216079
216141
216146
216171
216213
216218
216226
216327
216331
216401
216422
216453
216463
216466
216479
216487
216509
216561
216563
216587
216617
216669
216702
216703
216709
216712
216718
216721
216734
216735
216782
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
4/13/2015 16:53
4/13/2015 16:36
4/13/2015 16:57
4/13/2015 17:02
4/13/2015 17:14
4/13/2015 17:05
4/13/2015 17:36
4/13/2015 17:44
4/13/2015 17:46
4/13/2015 18:08
4/13/2015 17:56
4/13/2015 17:58
4/13/2015 17:59
4/13/2015 18:14
4/13/2015 18:31
4/13/2015 18:27
4/13/2015 18:53
4/13/2015 18:56
4/13/2015 19:17
4/13/2015 19:33
4/13/2015 19:44
4/13/2015 20:03
4/13/2015 19:47
4/13/2015 19:48
4/13/2015 19:49
4/15/2015 13:26
4/13/2015 20:06
4/13/2015 20:21
4/13/2015 20:41
4/13/2015 20:36
4/13/2015 21:15
4/13/2015 21:34
4/13/2015 21:37
4/13/2015 22:43
4/14/2015 3:16
4/14/2015 4:15
4/14/2015 6:04
4/14/2015 6:16
4/14/2015 6:23
4/14/2015 7:10
4/14/2015 7:34
4/14/2015 7:25
4/14/2015 8:01
4/14/2015 8:09
4/14/2015 8:12
4/14/2015 8:31
4/14/2015 8:45
4/14/2015 8:51
4/14/2015 8:55
4/16/2015 11:49
216799
216808
216833
216850
216853
216858
216897
216922
216938
216946
216949
216960
216962
216977
217010
217020
217076
217081
217111
217134
217141
217145
217153
217157
217161
217179
217186
217211
217219
217233
217264
217282
217286
217319
217365
217380
217455
217460
217477
217539
217566
217572
217631
217652
217658
217690
217717
217730
217735
217739
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 4 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
3 Meals (vegetarian) for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
4/14/2015 8:57
4/14/2015 9:03
4/14/2015 9:56
4/14/2015 9:13
4/17/2015 9:39
4/14/2015 9:20
4/14/2015 9:16
4/14/2015 11:42
4/14/2015 9:19
4/14/2015 9:19
4/14/2015 9:25
4/14/2015 9:23
4/14/2015 9:29
4/14/2015 9:26
4/14/2015 10:02
4/14/2015 9:57
4/14/2015 9:56
4/14/2015 9:58
4/14/2015 10:17
4/14/2015 10:23
4/14/2015 10:22
4/14/2015 10:20
4/14/2015 10:21
4/14/2015 10:22
4/14/2015 10:26
4/14/2015 10:32
4/14/2015 10:30
4/14/2015 10:30
4/14/2015 10:32
4/14/2015 10:37
4/14/2015 10:37
4/14/2015 10:40
4/14/2015 10:40
4/14/2015 10:47
4/14/2015 10:41
4/14/2015 10:46
4/14/2015 10:48
4/14/2015 10:46
4/14/2015 10:50
4/14/2015 10:53
4/14/2015 10:49
4/14/2015 10:50
4/14/2015 10:52
4/14/2015 10:54
4/14/2015 10:56
4/14/2015 10:56
4/14/2015 11:01
4/14/2015 10:58
4/14/2015 11:27
4/14/2015 11:45
217749
217758
217776
217778
217784
217787
217788
217792
217800
217801
217802
217815
217818
217822
217887
217890
217893
217897
217940
217941
217945
217950
217962
217967
217973
217982
217983
217990
218000
218011
218012
218014
218015
218022
218025
218030
218033
218038
218041
218045
218046
218048
218050
218054
218055
218057
218060
218061
218063
218070
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
4/14/2015 11:03
4/14/2015 11:05
4/14/2015 11:05
4/14/2015 15:38
4/14/2015 11:11
4/14/2015 11:14
4/14/2015 11:18
4/14/2015 11:19
4/14/2015 11:23
4/14/2015 11:29
4/14/2015 11:30
4/14/2015 11:33
4/14/2015 11:34
4/14/2015 11:35
4/14/2015 11:38
4/14/2015 11:49
4/14/2015 11:52
4/14/2015 11:52
4/14/2015 11:54
4/14/2015 11:55
4/14/2015 11:59
4/14/2015 11:59
4/14/2015 12:01
4/14/2015 12:01
4/14/2015 12:21
4/14/2015 12:12
4/14/2015 12:25
4/14/2015 12:26
4/14/2015 12:30
4/14/2015 12:30
4/14/2015 12:37
4/14/2015 12:38
4/14/2015 13:03
4/14/2015 13:11
4/14/2015 13:11
4/14/2015 13:14
4/14/2015 13:16
4/14/2015 13:28
4/14/2015 15:44
4/14/2015 13:41
4/14/2015 13:49
4/14/2015 13:54
4/14/2015 13:58
4/14/2015 14:31
4/14/2015 14:19
4/14/2015 14:18
4/14/2015 14:24
4/14/2015 15:35
4/14/2015 14:44
4/14/2015 14:46
218072
218076
218077
218093
218096
218100
218111
218113
218118
218130
218142
218150
218151
218152
218164
218206
218221
218224
218225
218247
218264
218265
218275
218277
218289
218337
218387
218395
218406
218409
218429
218432
218504
218523
218532
218541
218546
218575
218593
218614
218630
218644
218653
218671
218695
218697
218705
218708
218751
218763
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
4/14/2015 15:19
4/14/2015 14:55
4/14/2015 16:05
4/14/2015 14:57
4/14/2015 14:57
4/14/2015 15:13
4/14/2015 15:18
4/14/2015 15:23
4/14/2015 15:27
4/14/2015 15:33
4/14/2015 15:39
4/14/2015 15:42
4/14/2015 15:56
4/14/2015 16:14
4/14/2015 16:18
4/14/2015 16:21
4/14/2015 16:29
4/14/2015 16:22
4/14/2015 16:29
4/14/2015 16:32
4/14/2015 16:33
4/14/2015 16:35
4/14/2015 17:00
4/14/2015 16:43
4/14/2015 16:47
4/14/2015 16:55
4/14/2015 16:58
4/14/2015 17:01
4/14/2015 17:01
4/14/2015 17:05
4/14/2015 17:14
4/14/2015 17:56
4/14/2015 17:27
4/14/2015 17:23
4/14/2015 17:23
4/14/2015 17:26
4/14/2015 17:26
4/14/2015 17:29
4/14/2015 17:28
4/14/2015 17:44
4/14/2015 17:49
4/14/2015 18:11
4/14/2015 18:19
4/14/2015 18:28
4/14/2015 18:28
4/14/2015 18:31
4/14/2015 18:35
4/14/2015 18:40
4/14/2015 18:40
4/14/2015 18:42
218784
218792
218796
218797
218799
218813
218839
218852
218860
218870
218883
218889
218925
218968
218975
218976
218984
218986
219015
219020
219025
219029
219034
219043
219055
219075
219080
219083
219086
219095
219102
219134
219135
219136
219137
219146
219149
219151
219152
219196
219208
219241
219263
219285
219286
219297
219304
219311
219321
219325
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
3 Meals (vegetarian) for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 4 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per week for 2 people
Classic – 3 meals per …
Purchase answer to see full
attachment
