(b) The first vaccine that could fight the Covid-Pi virus was developed in February 2021 by Cosmos Pharmaceutical Limited (CPL). It is named the Conqueror. A sample data was collected on its effective duration in weeks, i.e., how long the immunity lasts in a human body after the vaccination.

Six months later, another company Delta Life Science (DLS) develops its vaccine named Destroyer. A sample data is collected. DLS Management claims that its Destroyer has longer effective duration than Conqueror.

Note: Only one dose will be administered per person for either vaccine. The data is shown in the GBA Data file (see worksheet 'Vaccine Effectiveness').

Use Microsoft Excel to summarise separately the two (2) sets of data. Identify the locations and spreads of the samples, each with a measure that takes all data into consideration. Comment on their differences.

Present each data in an appropriate type of diagram. Comment on the data distributions.

Vaccine Effective Durations in Weeks

Conqueror Destroyer

18 21.5

21.7 37.9

19 46.3

28.2 16.2

33.2 47.5

25.4 22.3

32.6 34.8

24.1 21.4

32.3 27.9

30 19.8

31.7 30.3

33.3 29.7

30.9 30.1

21.5 21.4

27.4 20

22.6 41.4

36 23.2

32.1 40.2

37.2 33.5

34.3 38.7

31.6 25.6

9 27.3

28.9 23.9

28.8 29.8

19.5 36.8

34.5 24.3

28.2 26.1

37.9 28.4

23.8 21.9

26.6 34.4

37 41.7

22.9 28.6

20.4 42.1

27.3 28.8

25.7 29.5

29.6 21.5

19.8 12.4

38.7 24.6

19.4 28

28.3 28.3

32.9 49.2

21.4 20.9

30.5 30.4

23.6 31.9

28.3 37.5

17.5 23.1

33.8 33.2

25.2

34.2

28

23.6