Excel Formulas

Showing page 16 of 21
TDIST
Statistical

Returns the Student's t-distribution

TINV
Statistical

Returns the inverse of the Student's t-distribution

WEIBULL
Statistical

Returns the Weibull distribution

RANK
Statistical

Returns the rank of a number in a list of numbers

PERCENTRANK
Statistical

Returns the percentage rank of a value in a dataset

CORREL
Statistical

Returns the correlation coefficient between two data sets

COVAR
Statistical

Returns covariance, the average of the products of paired deviations

FORECAST
Statistical

Returns a value along a linear trend

INTERCEPT
Statistical

Returns the intercept of the linear regression line

PEARSON
Statistical

Returns the Pearson product moment correlation coefficient

RSQ
Statistical

Returns the square of the Pearson product moment correlation coefficient

SLOPE
Statistical

Returns the slope of the linear regression line

STEYX
Statistical

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

FREQUENCY
Statistical

Returns a frequency distribution as a vertical array

GROWTH
Statistical

Returns values along an exponential trend

LINEST
Statistical

Returns the parameters of a linear trend

LOGEST
Statistical

Returns the parameters of an exponential trend

MDETERM
Math

Returns the matrix determinant of an array

MINVERSE
Math

Returns the matrix inverse of an array

MMULT
Math

Returns the matrix product of two arrays

Page 16 of 21