Chapter 11

Building descriptive statistical formulas

In this chapter, you will:

  • Understand descriptive statistics

  • Learn how to count items and calculate permutations and combinations

  • Calculate the mean, median, mode, and other averages

  • Work with maximums, minimums, and other extreme values

  • Calculate measures of variation such as the range, variance, and standard deviation

In Excel’s list of worksheet functions, the Statistical category boasts well over 100 functions. That’s a massive number, and it inevitably means that many of those functions are obscure and highly specialized. That’s great if you’re a specialist, but for general business uses it’s highly unlikely you’ll ever need the Fisher transformation (via the FISHER() function), the ...

Get Microsoft Excel 2019 Formulas and Functions, First Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.