Part 3 – Using IT

12. Create the spreadsheet below using Excel. Include the rows and columns identifiers, text formatting and column highlighting as shown.

13)

a) What actions or steps in Excel can you take to rank them from 1st to 10th.

b) State the specific action(s) or step(s) in Excel that will produce a list/display of those countries with 800 or more medals in total?

c) Which type of graph will be suitable for representing only gold medals information?

d) In which column(s) might replication have been used?

e) What Excel formula can be used to calculate the overall total medals awarded?

14) Write the Excel functions for the following:

a. Give the total number of medals for Germany and Great Britain.

b. Give the average number of silver medals for a European country,

c. Sum the Medals Total for Gold for those countries with less than 20 games involvement.

d. Search the database (the whole spreadsheet) to find ‘Italy’ and also the corresponding Medals Total.

15) By using Microsoft Excel and provide screenshots:

a) Calculate the median number of medals for each medal type, stating the formula you would use for determining the median for the gold medals.

b) Calculate the mean number of medals for each of the 3 medal types, stating the formula you would use for determining the mean for the bronze medals.

c) Calculate the standard deviation of the total medals awarded to each country (column F) using the formula below. Show all the steps (full working).

Hint: You can use the STDEV.P function to cross-check your final answer.

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.

16) 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.

b) Use a suitable and fully labeled chart in Excel to reflect the contribution of each country to the overall medals total.