Microsoft Office Tutorials and References
In Depth Information
Statistical Functions
Returns the largest value in a set of values.
MAX
Returns the largest value in a list of arguments.
MAXA
Returns the median of the given numbers.
MEDIAN
Returns the smallest number in a set of values.
MIN
Returns the smallest value in a list of arguments.
MINA
Returns the most frequently occurring, or repetitive, value in an
array or range of data.
MODE
Returns the negative binomial distribution.
NEGBINOMDIST
Returns the normal cumulative distribution for the specified
mean and standard deviation.
NORMDIST
Returns the inverse of the normal cumulative distribution for the
specified mean and standard deviation.
NORMINV
Returns the standard normal cumulative distribution function.
NORMSDIST
Returns the inverse of the standard normal cumulative distribution.
NORMSINV
Returns the Pearson product moment correlation coefficient, r, a
dimensionless index that ranges from –1.0 to 1.0 inclusive and
reflects the extent of a linear relationship between two data sets.
PEARSON
Returns the k-th percentile of values in a range.
PERCENTILE
Returns the rank of a value in a data set as a percentage of the
data set.
PERCENTRANK
Returns the number of permutations for a given number of
objects that can be selected from number objects.
PERMUT
Returns the Poisson distribution and predicts events over time.
POISSON
Returns the probability that values in a range are between two
specified limits.
PROB
Returns the quartile of a data set.
QUARTILE
Returns the rank of a number in a list of numbers.
RANK
Returns the square of the Pearson product moment correlation
coefficient through data points in known_y’s and known_x’s .
RSQ
Returns the skewness of a distribution.
SKEW
Returns the slope of the regression line through data points in
known_y’s and known_x’s .
SLOPE
Returns the k-th smallest value in a data set.
SMALL
Returns a normalized value from a distribution characterized by
MEAN and STANDARD_DEV .
STANDARDIZE
Estimates standard deviation based on a sample. STDEVA acts
upon values.
STDEVA
Estimates standard deviation based on a sample. STDEVE acts
upon numbers.
STDEVE
Search JabSto ::




Custom Search