Page 417 - Excel 2013 All-in-One For Dummies

Statistical Functions 399
Figure 5-3:
Using SUMIFS to total sales by location as well as the items sold.
Statistical Functions
Excel includes one of the most complete sets of statistical functions available outside a dedicated statistics software program. When you want to access these functions from the Ribbon’s Formulas tab instead of using the Insert Function dialog box, you need to click the More Functions command button and then highlight the Statistical option at the very top of the drop-down menu (or press Alt+MQS). Doing this displays a continuation menu listing all the statistical functions in alphabetical order.
The statistical functions run the gamut from the more mundane AVERAGE, MAX, and MIN functions to the more exotic and much more specialized CHITEST, POISSON, and PERCENTILE statistical functions.
Because I prefaced the item Strawberry pie with the not (<>) operator (which can be placed before or after the open double quotation mark), Excel sums the sale of every item except for Strawberry pie.
Book III Chapter 5
Math and Statistical Formulas