Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Analytics Data Analysis and Decision Making

Authors: S. Christian Albright, Wayne L. Winston

5th edition

1133629601, 9781285965529 , 978-1133629603

More Books

Students also viewed these Mathematics questions

Question

The paleolithic age human life, short write up ?

Answered: 1 week ago