Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 529

Kth Smallest

Click to print the kth smallest value for each row or column of the input

range; enter the value for k in the corresponding box.

Summary Statistics

Click to print the following statistics in the output range: Mean, Standard

Error (of the mean), Median, Mode, Standard Deviation, Variance, Kurtosis,

Skewness, Range, Minimum, Maximum, Sum, Count, Largest (#), Smallest

(#), and Confi dence Level.

See “Output Options” at the beginning of this section for information on

the output storage options.

Exponential Smoothing

The Exponential Smoothing command creates a column of smoothed aver-

ages using simple one-parameter exponential smoothing.

Input Range

Enter the range of worksheet data you want to analyze. The range must be a

single row or a single column.

Damping Factor

Enter the value of the smoothing constant. The value 0.3 is used as a default

if nothing is entered.