Business Solutions Formulas and Functions with Microsoft® Office Excel 2007

Chapter 12. Working with Statistical Functions

IN THIS CHAPTER

• Understanding Descriptive Statistics 265

• Counting Items with the COUNT() Function 266

• Calculating Averages 267

• Calculating Extreme Values 269

• Calculating Measures of Variation 272

• Working with Frequency Distributions 275

• Using the Analysis ToolPak Statistical Tools 280

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