Assignment title: Management


a) Determine by using a spreadsheet model and drawing an ogive, a variety of averages and measures of dispersion (see marking criteria for full list). Place all of these calculated values in a suitable table and include this in your report, along with a copy of your ogive. Note: o All calculations (no matter how simple) should be done on and by the spreadsheet. Formulae in your spreadsheet will be checked. [9 marks] b) A colleague who has access to the raw data has calculated the mean as £370. Compare this value with the one you calculated in (a) above, and fully explain why this value is different. You will be expected to include an example to help your explanation. [