Excel offers whole range statistical functions should have previously used functions MAX MIN AVERAGE We now going look at some other commonly used functions For example • MODE MEDIAN mode median set data • COUNT COUNTBLANK COUNTIF Count cells that fulfill given criteria • LARGE SMALL Find 7th largest or 4th smallest value etc • STDEV Standard deviation set data • RANK value occupying certain rank list • QUARTILE number one quarter way through set etc • PERCENTILE number 90% way through set etc spreadsheet below uses number statistical functions analyze set data present columns B C Task 1 – Data Ignoring blank cells write out data order starting with smallest table like one shown below Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Data Mode Minimum 2nd smallest 25th Percentile Median 65th Percentile 75th Percentile 3rd largest Maximum Note – way Excel calculates its quartiles percentiles fairly complicated It will not be covered here Task 2 – Using Functions Recreate spreadsheet shown above Make sure that all statistical values created using formulae that refer data range B3C13 Statistical Functions 2007 Excel Advanced 10