Part 4

Mr Sweet has also collected some information on possible new products. He developed two new toppings and asked loyal customers to evaluate both the caramel topping and the dark chocolate topping.

After a few months, the same loyal customers were asked to evaluate a new coffee and walnut cake. The customers rated these new products on a scale of 0-10. Daniella got access to the anonymised data in the sheet named 'Part 4 - MyCakes surveys'.

Daniella has also done an analysis with some of her customers to test their perception of her new carrot cake (sheet 'Part 4 - Carrot cake surveys'.)The rating scale of 0-10 was also used in this survey.

Daniella would like to understand the differences among the customers' ratings and requires your assistance once again.

Part 4a

Using the data provided, evaluate whether customers favour the caramel topping or the dark chocolate topping.

Part 4b

Compare the results of the survey related to the coffee and walnut cake with the results of the survey on the carrot cake. Determine if customers prefer the coffee and walnut cake or the carrot cake.

Part 4c

Discuss the data you analysed, the methods used to analyse them, the results of the analysis and the related business implications.

MyCakes survey data

Customer ID	Topping (milk caramel)	Topping (dark chocolate)	Coffe and walnut cake
1	5	9	7
2	6	10	5
3	0	10	10
4	5	9	10
5	6	10	8
6	6	10	5
7	5	9	6
8	10	8	6
9	7	7	10
10	8	6	7
11	1	8	6
12	5	8	7
13	10	4	7
14	3	7	6
15	10	9	10
16	7	7	9
17	3	10	9
18	4	10	6
19	5	7	9
20	4	10	7
21	5	7	8
22	4	10	6
23	6	8	7
24	6	7	9
25	5	10	5
26	5	10	4
27	9	8	9
28	10	7	5
29	6	9	10
30	7	9	9
31	9	6	8
32	7	10	9
33	10	8	8
34	4	7	9
35	4	7	9
36	5	8	10
37	6	9	5
38	4	10	8
39	4	10	7
40	1	9	7
41	8	10	8
42	7	9	8
43	8	7	3
44	4	10	6
45	2	10	6
46	7	5	9
47	8	9	10
48	1	9	9
49	7	10	7
50	5	6	7
51	6	7	6
52	8	10	10
53	3	7	9
54	6	9	7
55	4	8	5
56	3	7	4
57	6	6	6
58	-1	7	8
59	7	10	3
60	10	7	9
61	0	10	7
62	7	10	8
63	4	8	9
64	4	7	7
65	7	9	8
66	2	7	6
67	8	8	10
68	6	10	5
69	7	10	5
70	8	9	6
71	10	6	8
72	1	8	6
73	0	6	8
74	8	5	4
75	7	7	10
76	2	7	4
77	10	10	3
78	9	9	9
79	3	9	8
80	8	8	7
81	10	8	7
82	7	10	8
83	10	9	7
84	8	9	7
85	9	7	9
86	8	10	9
87	5	10	8
88	10	10	10
89	9	9	7
90	-1	8	5
91	4	7	6
92	7	8	6
93	6	10	10
94	3	9	10
95	1	6	7
96	10	5	5
97	8	7	10
98	10	5	7
99	4	6	7
100	10	10	8
101	7	10	5
102	6	10	7
103	6	8	10
104	5	9	6
105	5	10	8
106	5	10	10
107	8	9	9
108	8	6	7
109	9	7	8
110	8	6	5
111	7	10	8
112	5	8	10
113	4	10	10
114	5	9	7
115	4	7	9
116	0	7	8
117	7	10	5
118	5	6	10
119	5	5	4
120	5	9	7

Carrot cake surveys:

4

3

7

8

5

0

8

10

8

6

9

6

9

7

0

7

6

6

6

7

2

5

6

6

4

8

6

9

7

4

4

7

7

7

9

8

6

7

8

6

6

4

5

6

6

9

5

4

8

7

2

4

7

7

4

5

9

8

5

7

4

3

6

7

4

6

5

6

4

6

8

7

8

7

5

7

10

5

7

6

8

8

8

9

3

6

4

8

6

5

5

7

10

7

6

4

6

4

5

5