Question
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
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 a
Using the data provided, evaluate whether customers favour the caramel topping or the dark chocolate topping.
Write the null and alternative hypothesis Write both means, t value, df, and p value Provide the appropriate reporting of the results as per module activities Make sure you conclude whether we reject or fail to reject the null hypothesis
Part b
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.
- same as Part a
Part c
Prepare a document suitable for a business audience that presents:
- the data you analysed
- the methods used to analyse them
- the results of the analysis and the related business implications.
- Provide a summary of the aim and hypothesis for 4a and 4b -what you aimed to do Include a sentence or two answering: what relevance the above has for Daniella Explain what type of tests you chose to perform for 4a and 4b and why Write both hypothesis for 4a and 4b and state why we always have 2 of them Explain what results showed for 4a and 4b Explain how is this relevant for Daniella's business? What conclusions can we make? How can Daniella maximise profit considering the findings
Carrot cake |
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 |
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started