Microsoft Office Tutorials and References
In Depth Information
Returns the largest value in a set of values.
Returns the largest value in a list of arguments.
Returns the median of the given numbers.
Returns the smallest number in a set of values.
Returns the smallest value in a list of arguments.
Returns the most frequently occurring, or repetitive, value in an
array or range of data.
Returns the negative binomial distribution.
Returns the normal cumulative distribution for the specified
mean and standard deviation.
Returns the inverse of the normal cumulative distribution for the
specified mean and standard deviation.
Returns the standard normal cumulative distribution function.
Returns the inverse of the standard normal cumulative distribution.
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.
Returns the k-th percentile of values in a range.
Returns the rank of a value in a data set as a percentage of the
Returns the number of permutations for a given number of
objects that can be selected from number objects.
Returns the Poisson distribution and predicts events over time.
Returns the probability that values in a range are between two
Returns the quartile of a data set.
Returns the rank of a number in a list of numbers.
Returns the square of the Pearson product moment correlation
coefficient through data points in known_y’s and known_x’s .
Returns the skewness of a distribution.
Returns the slope of the regression line through data points in
known_y’s and known_x’s .
Returns the k-th smallest value in a data set.
Returns a normalized value from a distribution characterized by
MEAN and STANDARD_DEV .
Estimates standard deviation based on a sample. STDEVA acts
Estimates standard deviation based on a sample. STDEVE acts