Statistics Functions

Use this chart to see how each function works:

Function

Definition

ERF Computes the error function integrated between lower and upper limits.
ERFC Computes the compliment of the standard error function integrated between the lower limit and infinity.
MAX Used to find the maximum value in the data set provided.
MEDIAN Used to find the median value in the data set provided.
MIN Used to find the minimum value in the data set provided.
MODE Finds the lowest, most frequently occurring value in the data set provided.
NORMSDIST Takes a single value or an array of values and provides the normal standard distribution of each value.
RANK Returns the rank of each value using the order specified.
SLOPE Computes the slope of the linear regression line represented by the known_y and known_x values.
STANDARDIZE Standardizes each value using the supplied mean and standard deviation.
STDEV Computes the standard deviation for a random sampled population using the n-1 method.
STDEVP Computes the standard deviation for a random sampled population using the n method.
VARIANCE Computes the variance for a random sample population using the n-1 method.
VARIANCEP Computes the variance for a random sample population using the n method.
ZTEST Computes the one-tailed probability-value of a z-test.