Determine the mean, median, mode, standard deviation and range of the sales per country.

1. Create a frequency table of the number of countries per sale range by filling the table given in the excel file (Hint: use the formula of Excel, “COUNTIF”). (5 Marks)

1. Determine the mean, median, mode, standard deviation and range of the sales per country.( 5 Marks)

1. Create a histogram of the distribution obtained in part (a) (5 Marks)

Sort your table by continent (Hint: continent code given in red font on the top of excel file) and create a