# MS Excel Advanced - Statistical Functions

Resource Type
Product Rating
4.0
1 Rating
File Type

PDF (Acrobat) Document File

167 KB|0 pages
Share
Product Description
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
Total Pages
0 pages
N/A
Teaching Duration
N/A
Report this Resource

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.