Task2

wright077
Assignment_data_CHOC.xlsx
Home>Business & Finance homework help>Marketing homework help>Task2

List of brands_CHOC

Mars B1
Snickers B2
Kinder Bueno B3
Twix B4
Nestle' Aero B5
Milkyway B6
Cadbury Crispello B7
Cadbury Dairy Milk B8
KitKat B9
Cadbury Twirl B10
Boost B11
Bounty B12
Lion B13
Cadbury Timeout B14
Galaxy B15
Cadbury Wispa B16
Flake B17
Yorkie B18
Lindor Treat Bar B19
Teasers B20
Cadbury Crunchie B21
Cadbury Picnic B22

Panel_Data_CHOCOLATE

Number of buyers
Shopper B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14 B15 B16 B17 B18 B19 B20 B21 B22 TOT B1 B2 B3 B4 B5 B6 B7 B8 B9 B10 B11 B12 B13 B14 B15 B16 B17 B18 B19 B20 B21 B22
1 3 0 0 3 0 0 0 0 0 0 11 0 0 0 6 2 0 0 0 0 1 3 29 1 0 0 1 0 0 0 0 0 0 1 0 0 0 1 1 0 0 0 0 1 1
2 1 0 0 0 0 0 2 0 0 0 0 0 0 0 4 0 0 2 0 0 0 0 9 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0
3 0 0 0 1 0 0 0 0 0 0 0 0 0 0 2 0 0 14 0 0 0 0 17 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0
4 0 0 1 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 1 6 0 0 10 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0
5 0 0 0 0 0 0 4 0 0 0 0 0 0 0 2 0 0 0 0 2 0 0 8 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 0 1 0 0
6 1 0 0 9 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 11 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
7 0 0 17 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 0 20 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 1 0
8 1 0 1 0 0 0 0 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 1 0 1 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
9 0 0 2 2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
10 0 0 3 47 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 2 0 54 0 0 1 1 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 1 0
11 4 0 5 0 0 12 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 23 1 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
12 0 0 3 0 0 0 0 1 0 0 0 0 0 0 13 0 0 0 0 0 5 0 22 0 0 1 0 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 1 0
13 0 0 0 0 0 0 0 5 0 4 0 1 0 0 0 0 0 0 0 0 0 0 10 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0
14 0 3 0 0 0 0 1 0 6 0 0 0 0 0 0 0 0 0 0 0 1 0 11 0 1 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0
15 0 1 0 0 0 0 0 10 10 11 0 17 0 1 0 1 0 0 0 0 0 0 51 0 1 0 0 0 0 0 1 1 1 0 1 0 1 0 1 0 0 0 0 0 0
16 2 15 0 0 0 1 0 13 1 0 0 0 0 0 0 0 0 0 0 0 0 0 32 1 1 0 0 0 1 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0
17 0 0 0 2 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
18 0 0 0 0 0 0 0 3 0 0 0 0 8 0 3 0 0 0 0 0 4 0 18 0 0 0 0 0 0 0 1 0 0 0 0 1 0 1 0 0 0 0 0 1 0
19 0 0 0 2 0 0 0 0 5 0 0 0 0 0 1 0 0 0 0 0 0 0 8 0 0 0 1 0 0 0 0 1 0 0 0 0 0 1 0 0 0 0 0 0 0
20 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
21 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0
22 4 0 2 0 0 0 0 0 2 1 0 0 0 1 0 2 1 0 0 2 2 3 20 1 0 1 0 0 0 0 0 1 1 0 0 0 1 0 1 1 0 0 1 1 1
23 3 0 0 0 1 0 5 3 0 1 0 0 0 0 0 0 0 0 12 0 0 0 25 1 0 0 0 1 0 1 1 0 1 0 0 0 0 0 0 0 0 1 0 0 0
24 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
25 0 3 0 2 0 0 0 0 2 0 2 0 0 4 0 0 0 0 1 0 0 0 14 0 1 0 1 0 0 0 0 1 0 1 0 0 1 0 0 0 0 1 0 0 0
26 1 0 0 4 0 1 0 0 19 1 0 0 1 0 0 0 0 0 0 0 1 0 28 1 0 0 1 0 1 0 0 1 1 0 0 1 0 0 0 0 0 0 0 1 0
27 0 0 0 0 0 0 0 0 0 0 0 0 0 13 6 0 0 1 0 0 0 2 22 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 1
28 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
29 1 1 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 6 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
30 0 0 0 0 0 0 0 2 0 0 4 0 0 0 1 0 0 0 0 0 3 0 10 0 0 0 0 0 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 1 0
31 3 4 0 1 0 0 0 1 0 0 0 0 0 0 4 0 0 0 0 0 0 0 13 1 1 0 1 0 0 0 1 0 0 0 0 0 0 1 0 0 0 0 0 0 0
32 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0 2 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 0
33 0 0 0 0 0 0 0 6 0 1 0 0 8 4 0 4 0 1 1 0 0 0 25 0 0 0 0 0 0 0 1 0 1 0 0 1 1 0 1 0 1 1 0 0 0
34 5 4 0 1 0 0 0 0 0 0 0 0 0 1 1 0 0 2 0 0 0 0 14 1 1 0 1 0 0 0 0 0 0 0 0 0 1 1 0 0 1 0 0 0 0
35 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 5 5 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1
36 0 0 0 0 0 0 0 7 0 1 0 1 0 0 0 0 0 0 0 0 0 0 9 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 0 0 0 0
37 0 0 0 0 0 0 0 0 0 0 0 0 0 3 13 0 0 0 0 0 0 1 17 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0 1
38 0 0 0 0 0 3 0 4 0 1 0 0 0 0 0 0 1 0 0 0 1 0 10 0 0 0 0 0 1 0 1 0 1 0 0 0 0 0 0 1 0 0 0 1 0
39 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 3 0 0 0 0 0 6 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0
40 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
41 2 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 4 0 0 7 1 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 1 0 0
42 10 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 12 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0
43 4 3 0 0 0 0 0 0 3 5 0 0 0 1 0 0 0 0 0 0 5 0 21 1 1 0 0 0 0 0 0 1 1 0 0 0 1 0 0 0 0 0 0 1 0
44 0 0 0 2 0 0 0 0 0 0 0 0 0 0 2 2 0 0 0 0 0 0 6 0 0 0 1 0 0 0 0 0 0 0 0 0 0 1 1 0 0 0 0 0 0
45 0 0 0 0 0 0 0 0 0 0 0 0 0 0 17 6 7 0 0 0 0 0 30 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0
46 1 12 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 16 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
47 1 0 4 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 6 1 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
48 0 0 0 0 0 0 0 2 0 1 0 0 0 0 0 0 0 0 0 1 0 0 4 0 0 0 0 0 0 0 1 0 1 0 0 0 0 0 0 0 0 0 1 0 0
49 0 0 0 0 0 0 0 0 4 0 0 0 0 0 0 0 0 1 0 0 0 0 5 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 1 0 0 0 0
50 21 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 23 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0
51 0 2 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 7 0 0 0 11 0 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0
52 0 0 2 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 4 0 0 1 0 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0
53 2 3 0 0 0 0 0 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0 7 1 1 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0
54 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 3 0 0 0 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0
55 0 3 0 1 0 0 0 0 0 2 0 0 0 0 0 0 5 0 1 9 0 5 26 0 1 0 1 0 0 0 0 0 1 0 0 0 0 0 0 1 0 1 1 0 1
56 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0
57 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 1 1 4 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 1 0 0 1 1
58 0 0 0 0 0 0 0 4 1 4 2 0 0 0 0 1 0 0 0 5 0 0 17 0 0 0 0 0 0 0 1 1 1 1 0 0 0 0 1 0 0 0 1 0 0
59 0 0 0 0 0 0 0 0 0 2 0 0 0 2 3 6 1 0 0 0 0 0 14 0 0 0 0 0 0 0 0 0 1 0 0 0 1 1 1 1 0 0 0 0 0
60 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2 29 0 0 0 0 0 33 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0
TOT 605 452 337 301 165 154 165 819 522 334 200 140 111 164 520 317 289 229 135 189 301 185 6634 132 98 83 68 31 47 42 154 108 93 45 34 39 44 125 81 66 69 38 53 75 50