Chapter 11

Using Common Statistical Functions


check Calculating averages

check Finding the maximum and minimum values

check Counting the cells in a range of data

check Using the Statistical functions offered by the Analysis ToolPak add-in

Excel includes one of the most complete sets of statistical functions available outside of a dedicated statistics software program. These functions run the gamut from the garden-variety AVERAGE, MAX, and MIN functions to the more exotic CHITEST, POISSON, and PERCENTILE statistical functions. The program also offers an assortment of counting functions that enable you to count the number of cells that contain values, are nonblank (and thus contain entries of some kind), or count only the cells in a cell range that meet the criteria you specify. In this chapter, you get a chance to practice working with the most commonly used statistical functions, AVERAGE, MAX, and MIN, as well as the different counting functions.

Computing Averages

The average is the arithmetic mean computed by summing all the values to be averaged and then dividing this total by the number ...

Get Excel Workbook For Dummies, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.