statistical analysis

This section describes the statistical data analysis tools that come with the Analysis ToolPak. To install the Analysis ToolPak, choose the Tools menu’s Add-Ins command, select the Analysis ToolPak check box, and click OK. Excel may prompt you to insert the Microsoft Office 2000 or Excel 2000 CD if … [Read more...] about Excel Data Analysis Tools

This section describes the basic statistical functions that come with Excel. To see which functions Excel provides or to see which arguments a function requires, click the Paste Function toolbar button and then select Statistical from the Function Category list box (see Figure 4-1). Once … [Read more...] about Statistical Formulas in Excel

To determine which function to use and to insert the correct variables in the correct places, you need to know some key statistical terms. This section describes these terms. The science of statistics makes a fundamental distinction between two types of data sets, population data and sample data. … [Read more...] about Easy Refresher: Basic Business Statistics