Excel Formulas

Showing page 7 of 21
NORMINV
Statistical

Returns the inverse of the normal cumulative distribution

NORMSDIST
Statistical

Returns the standard normal cumulative distribution

NORMSINV
Statistical

Returns the inverse of the standard normal cumulative distribution

PEARSON
Statistical

Returns the Pearson product moment correlation coefficient

PERCENTILE
Statistical

Returns the k-th percentile of values in a range

PERCENTRANK
Statistical

Returns the percentage rank of a value in a dataset

PERMUT
Statistical

Returns the number of permutations for a given number of objects

POISSON
Statistical

Returns the Poisson probability distribution

PROB
Statistical

Returns the probability that values in a range are between two limits

QUARTILE
Statistical

Returns the specified quartile of a data set

RANK
Statistical

Returns the rank of a number in a list of numbers

RSQ
Statistical

Returns the square of the Pearson product moment correlation coefficient

SKEW
Statistical

Returns the skewness of a distribution

SLOPE
Statistical

Returns the slope of the linear regression line

STANDARDIZE
Statistical

Returns a normalized value from a distribution

STDEV
Statistical

Estimates standard deviation based on a sample

STDEVP
Statistical

Calculates standard deviation based on the entire population

STEYX
Statistical

Returns the standard error of the predicted y-value for each x

TDIST
Statistical

Returns the Student's t-distribution

TINV
Statistical

Returns the inverse of the Student's t-distribution

Page 7 of 21