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
Search JabSto ::




Custom Search