Hint: You can use the STDEV. P function to cross-check your final answer. (10 marks)
d) Using the given spreadsheet as a basis, discuss the usefulness of a standard
deviation in a given dataset. You need to cite any literature sources you use.
(10 marks)
By using Microsoft Excel:
a) Produce an appropriate fully labeled chart in Excel to compare the gold, silver
and bronze medals totals of the 10 countries.
(10 marks)
b) Use a suitable and fully labeled chart in Excel to reflect the contribution of
each country to the overall medals total.
(10 marks)
(Part 3 - 100 marks)