Microsoft Office Tutorials and References
In Depth Information
Excel includes more than 80 statistical functions. You
can find these functions by using the Function Wizard
in the Statistics category. Some of them are also
available in the Descriptive Statistics dialog box. To
make additional statistical functions available, install
the Excel Analysis Toolpak described in Task #94.
Among the statistical functions, you will find more
than a dozen types of descriptive statistics. With
these statistics, you characterize both the central
tendency of your data, such as mean, mode, and
median, and the data’s variability, such as sample
variance and standard deviation. The Function Wizard
provides individual statistical functions. By using the
Descriptive Statistics dialog box, you can apply all
descriptive statistics at the same time.
To use descriptive statistics, first display a worksheet
with the data you want to analyze. You can generate
the worksheet within Excel or import it from Access
or another data source. Many functions work only
with numeric data.
Click the Data tab.
Click Data Analysis.
l The Data Analysis dialog box
Click Descriptive Statistics.