MBA's Guide to Microsoft Excel
Chapter 4
Statistical Analysis
Excel 2000 provides an almost countless number of tools you can use to analyze data and make meaningful statements about it. However, without understanding the purpose and design of the tools and the details of how to use them, they offer little help. This chapter supplies the background information required to determine which statistical tool to use and how to use it to find the information you need. The first part of this chapter defines some important statistical terms used in the calculations. The second part of the chapter details each function in turn and provides examples illustrating the type of data each function requires and the type of result you can expect. The last part of this chapter describes the statistical analysis tools included in the Analysis ToolPak add-in.