Page 157 - Excel Workbook for Dummies

15_798452 ch10.qxp 3/13/06 7:33 PM Page 140
140 Part II: Using Formulas and Functions
After that, you access their functions from the Data Analysis dialog box (Tools➪Data
Analysis) shown in Figure 10-1. To use a particular function, select its name in the
Analysis Tools list box and then select OK. To get online information about the
purpose of these statistical functions, select the Help button in this dialog box.
After selecting OK, Excel opens another dialog box specific to the function you selected
in the Data Analysis dialog box. This new dialog box contains all the controls and text
boxes needed to select and fill in the function’s arguments (for help on the arguments,
select its Help button). After filling in the necessary arguments, select OK to have
Excel compute the statistical result and return it to the current cell.

Figure 10-1:
The Data
Analysis
dialog box
enables you
to access
the extra
statistical
functions
included in
the Analysis
ToolPak
add-in.