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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
