Microsoft Office Tutorials and References

In Depth Information

**Using the Descriptive Statistics tool**

The Descriptive Statistics tool requires an input range that consists of one or more variables

and an output range. You must also indicate whether the variables are to be arranged by

column or by row. If you include a row of labels, be sure to select the Labels In First Row

check box. Excel then uses the labels to identify the variables in its output table. Select the

Summary Statistics check box only if you want the detailed output table shown in Figure

17-7; otherwise, leave this check box clear.

Like the other tools in the Analysis Toolpak, Descriptive Statistics creates a table of

constants. If a table of constants doesn’t suit your needs, you can obtain most of the same

statistical data from other Analysis Toolpak tools or from formulas that use the Excel

worksheet functions. Table 17-2 lists the statistics and formulas.

TABLE 17-2
Descriptive Statistics formulas

Statistic

Formula

Mean

=AVERAGE(
number1, number2, …
)

Standard error

Similar to =STEYX(
known_y’s, known_x’s
) but uses ± distribution

rather than the standard distribution

Median

=MEDIAN(
number1, number2, …
)

Mode

=MODE.SNGL(
number1, number2, …
)

Standard deviation

=STDEV.S(
number1, number2, …
)

Variance

=VAR.S(
number1, number2, …
)

Kurtosis

=KURT(
number1, number2, …
)

Skewness

=SKEW(
number1, number2, …
)

Range

=MAX(
number1, number2
) – MIN(
number1, number2, …
)

Minimum

=MIN(
number1, number2, …
)

Maximum

=MAX(
number1, number2, …
)

Sum

=SUM(
number1, number2, …
)

Count

=COUNT(
value1, value2, …
)

k
th largest

=LARGE(
array, k
)

k
th smallest

=SMALL(
array, k
)

Confidence

Similar to =CONFIDENCE(
alpha, standard_dev, size
) but uses a

different algorithm