Statistical Functions

Excel provides a large selection of Statistical Functions, that perform most of the common statistical calculations, from basic mean, median & mode calculations to the more complex statistical distribution and probability tests. Note, however, that some of the functions are new to Excel 2007, Excel 2010 or Excel 2013, so are not available in earlier versions of Excel.

The Excel Statistical functions are all listed in the table below. The functions have been grouped into categories, to enable you to easily find the function you need. Selecting a function name will take you to a full description of the function, with examples of use and common errors.