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 of 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 of 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.

A B 1 Vaccine Effective Durations in Weeks Conqueror Destroyer W N 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 10 24.1 21.4 11 32.3 27.9 12 30 19.8 13 31.7 30.3 14 33.3 29.7 15 30.9 30.1 16 21.5 21.4 17 27.4 20 18 22.6 41.4 19 36 23.2 20 32.1 40.2 21 37.2 33.5 22 34.3 38.7 23 31.6 25.6 24 9 27.3 25 28.9 23.9 26 28.8 29.8 27 19.5 36.8 28 34.5 24.3 29 28.2 26.1 30 37.9 28.4 31 23.8 21.9 32 26.6 34.4 33 37 41.7 34 22.9 28.6 35 20.4 42.1 36 27.3 28.8 37 25.7 29.5 38 29.6 21.5 39 19.8 12.4 40 38.7 24.6 41 19.4 28 42 28.3 28.3 43 32.9 49.2 44 21.4 20.9 45 30.5 30.4 46 23.6 31.9 47 28.3 37.5 48 17.5 23.1 49 33.8 33.2 50 25.2 51 34.2 52 28 53 23.6 54Conqueror Conqueror Frequency Histogram 10 1 Mean 27.6157 15 0 20 Standard Error 0.87944 20 6 15 Median 28.2 25 10 Frequency 10 Mode 28.2 30 15 Frequency OUT Standard Deviation 6.28046 35 14 Sample Variance 39.4441 40 5 10 15 20 25 30 35 40 More Kurtosis 0.0903 More 0 Conqueror Skewness -0.43642 Range 29.7 Minimum 9 Maximum 38.7 Sum 1408.4 Count 51 Destroyer Destroyer Frequency 10 0 Histogram Mean 29.666 15 1 15 Standard Error 1.22012 20 3 Frequency Median 28.6 25 12 Ous Mode 21.5 30 12 Frequency Standard Deviation 8.36474 35 8 20 AO re Sample Variance 69.9688 40 4 Mo Kurtosis -0.19041 45 Destroyer W A Skewness 0.47666 50 Range 36.8 More 0 Minimum 12.4 Maximum 49.2 Sum 1394.3 Count 47