12. Working with Statistical Functions
IN THIS CHAPTER
Understanding Descriptive Statistics
Counting Items with the COUNT() Function
Calculating Measures of Variation
Working with Frequency Distributions
Using the Analysis ToolPak Statistical Tools
Excel’s statistical functions calculate all the standard statistical measures, such as average, maximum, minimum, and standard deviation. For most of the statistical functions, you supply a list of values (which could be an entire population or just a sample from a population). You can enter individual values or cells, or you can specify a range. Excel has dozens of statistical functions, many of which are rarely, if ever, used in business. Table 12.1 ...
Get Formulas and Functions with Microsoft® Excel 2003 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.
