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 Formulas and Functions (Office 2021 and Microsoft 365) 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.
