Formulas and Functions

Chapter 10 Statistical Functions 229
Function Description
“QUARTILE” (page 284) The QUARTILE function returns the value for the
specied quartile of a given collection.
“RANK” (page 285) The RANK function returns the rank of a number
within a range of numbers.
“SLOPE” (page 287) The SLOPE function returns the slope of the best-
t line for the collection using linear regression
analysis.
“SMALL” (page 288) The SMALL function returns the n
th
-smallest
value within a range. The smallest value is ranked
number 1.
“STANDARDIZE” (page 289) The STANDARDIZE function returns a normalized
value from a distribution characterized by a given
mean and standard deviation.
“STDEV” (page 290) The STDEV function returns the standard
deviation, a measure of dispersion, of a collection
of values based on their sample (unbiased)
variance.
“STDEVA” (page 291) The STDEVA function returns the standard
deviation, a measure of dispersion, of a collection
of values that may include text and Boolean
values, based on the sample (unbiased) variance.
“STDEVP” (page 293) The STDEVP function returns the standard
deviation, a measure of dispersion, of a collection
of values based on their population (true)
variance.
“STDEVPA” (page 294) The STDEVPA function returns the standard
deviation, a measure of dispersion, of a collection
of values that may include text and Boolean
values, based on the population (true) variance.
“TDIST” (page 296) The TDIST function returns the probability from
the Student’s t-distribution.
“TINV” (page 297) The TINV functions returns the t value (a function
of the probability and degrees of freedom) from
the Student’s t-distribution.
“TTEST” (page 297) The TTEST function returns the probability
associated with a Student’s t-test, based on the
t-distribution function.
“VAR” (page 298) The VAR function returns the sample (unbiased)
variance, a measure of dispersion, of a collection
of values.