Question

(d) Samples of the 3D printed milk were given out to people for a taste test and the

following results were collected:

Age Group

21 years and below

22-54 years old

55 years and above

Milk Concentration w/w%

70

64

30

38

65

5

19

51

Table 2. Number of people for the different age groups choosing a

particular milk concentration

75

31

51

11

i. [DIAS] Using Excel, create a suitable visualization for the above data.

(5 marks)

ii. [DIAS] List SIX possible inferences/conclusions that one may draw from

the visualization created in (i).

(12 marks)

Question image 1