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 ...