Excel Reference 581
The following functions are available in Excel when StatPlus™ is loaded:
Descriptive Statistics for One Variable
Function Name Description
COUNTBETW COUNTBETW(range, lower, upper, boundary)
returns the count of nonblank cells in the range
that lie between the lower and upper values. The
boundary variable determines how the end points
are used.
If boundary 5 1, the interval is > the lower value
and < the upper value.
If boundary 5 2, the interval is ≥ the lower value
and < the upper value.
If boundary 5 3, the interval is > the lower value
and ≤ the upper value.
If boundary 5 4, the interval is ≥ lower value
and ≤ the upper value.
IQR IQR(range) calculates the interquartile range for
the data in range.
MODEVALUE MODEVALUE(range) calculates the mode of the data
in range. The data are assumed to be in one column.
NSCORE NSCORE(number, range) returns the normal score
of number (or cell reference to number) from a
range of values.
RANGEVALUE RANGEVALUE(range) calculates the difference
between the maximum and minimum values from
a range of values.
RANKTIED RANKTIED(number, range, order) returns the rank
of the number in range, adjusting the rank for ties.
If order 5 0, then the range is ranked from largest
to smallest; if order 5 1, the range is ranked from
smallest to largest.
RUNS RUNS(range, [center]) returns the number of runs
in the data column range. The center 5 0 unless a
center value is entered.
SE SE(range) calculates the standard error of the
values in range.
SIGNRANK SIGNRANK(number, range) returns the sign rank
of the number in range, adjusting the rank for ties.
Values of zero receive a sign rank of 0. If order 5 0,
then the range is ranked from largest to smallest in
absolute value; if order 5 1, the range is ranked from
smallest to largest in absolute value.
StatPlusTM Math and Statistical
Functions
