Excel Spreadsheets Statistical Functions (83)
There are new functions in Excel 2007 in this category.
Importance
Functions
What it Does
Interesting
AVERAGE
Returns the average of its arguments
Interesting
AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values
Interesting
COUNT
Counts how many numbers are in the list of arguments
Interesting
COUNTA
Counts how many values are in the list of arguments)
Interesting
RANK
Returns the rank of a number in a list of numbers
Interesting
LARGE
Returns the k-th largest value in a data set
Interesting
SMALL
Returns the k-th smallest value in a data set
Rarely Used
COUNTBLANK
Counts the number of blank cells within a range
Rarely Used
COUNTIF
Counts the number of nonblank cells within a range that meet the given criteria (SUMPRODUCT does better)
Rarely Used
AVEDEV
Returns the average of the absolute deviations of data points from their mean
Rarely Used
BETADIST
Returns the cumulative beta probability density function
Rarely Used
BETAINV
Returns the inverse of the cumulative beta probability density function
Rarely Used
BINOMDIST
Returns the individual term binomial distribution probability
Rarely Used
CHIDIST
Returns the one-tailed probability of the chi-squared distribution
Rarely Used
CHIINV
Returns the inverse of the one-tailed probability of the chi-squared distribution
Rarely Used
CHITEST
Returns the test for independence
Rarely Used
CONFIDENCE
Returns the confidence interval for a population mean
Rarely Used
CORREL
Returns the correlation coefficient between two data sets
Rarely Used
COVAR
Returns covariance, the average of the products of paired deviations
Rarely Used
CRITBINOM
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value
Rarely Used
DEVSQ
Returns the sum of squares of deviations
Rarely Used
EXPONDIST
Returns the exponential distribution
Rarely Used
FDIST
Returns the F probability distribution
Rarely Used
FINV
Returns the inverse of the F probability distribution
Rarely Used
FISHER
Returns the Fisher transformation
Rarely Used
FISHERINV
Returns the inverse of the Fisher transformation
Rarely Used
FORECAST
Returns a value along a linear trend
Rarely Used
FREQUENCY
Returns a frequency distribution as a vertical array
Rarely Used
FTEST
Returns the result of an F-test
Rarely Used
GAMMADIST
Returns the gamma distribution
Rarely Used
GAMMAINV
Returns the inverse of the gamma cumulative distribution
Rarely Used
GAMMALN
Returns the natural logarithm of the gamma function, Γ (x)
Rarely Used
GEOMEAN
Returns the geometric mean
Rarely Used
GROWTH
Returns values along an exponential trend
Rarely Used
HARMEAN
Returns the harmonic mean
Rarely Used
HYPGEOMDIST
Returns the hypergeometric distribution
Rarely Used
INTERCEPT
Returns the intercept of the linear regression line
Rarely Used
KURT
Returns the kurtosis of a data set
Rarely Used
LINEST
Returns the parameters of a linear trend
Rarely Used
LOGEST
Returns the parameters of an exponential trend
Rarely Used
LOGINV
Returns the inverse of the lognormal distribution
Rarely Used
LOGNORMDIST
Returns the cumulative lognormal distribution
Rarely Used
MAX

Rarely Used
MAXA

Rarely Used
MEDIAN
Returns the median of the given numbers
Rarely Used
MIN

Rarely Used
MINA

Rarely Used
MODE
Returns the most common value in a data set
Rarely Used
NEGBINOMDIST
Returns the negative binomial distribution
Rarely Used
NORMDIST
Returns the normal cumulative distribution
Rarely Used
NORMINV
Returns the inverse of the normal cumulative distribution
Rarely Used
NORMSDIST
Returns the standard normal cumulative distribution
Rarely Used
NORMSINV
Returns the inverse of the standard normal cumulative distribution
Rarely Used
PEARSON
Returns the Pearson product moment correlation coefficient
Rarely Used
PERCENTILE
Returns the k-th percentile of values in a range
Rarely Used
PERCENTRANK
Returns the percentage rank of a value in a data set
Rarely Used
PERMUT
Returns the number of permutations for a given number of objects
Rarely Used
POISSON
Returns the Poisson distribution
Rarely Used
PROB
Returns the probability that values in a range are between two limits
Rarely Used
QUARTILE
Returns the quartile of a data set
Rarely Used
RSQ
Returns the square of the Pearson product moment correlation coefficient
Rarely Used
SKEW
Returns the skewness of a distribution
Rarely Used
SLOPE
Returns the slope of the linear regression line
Rarely Used
SMALL
Returns the k-th smallest value in a data set
Rarely Used
STANDARDIZE
Returns a normalized value
Rarely Used
STDEV
Estimates standard deviation based on a sample
Rarely Used
STDEVA
Estimates standard deviation based on a sample, including numbers, text, and logical values
Rarely Used
STDEVP
Calculates standard deviation based on the entire population
Rarely Used
STDEVPA
Calculates standard deviation based on the entire population, including numbers, text, and logical values
Rarely Used
STEYX
Returns the standard error of the predicted y-value for each x in the regression
Rarely Used
TDIST
Returns the Student's t-distribution
Rarely Used
TINV
Returns the inverse of the Student's t-distribution
Rarely Used
TREND
Returns values along a linear trend
Rarely Used
TRIMMEAN
Returns the mean of the interior of a data set
Rarely Used
TTEST
Returns the probability associated with a Student's t-test
Rarely Used
VAR
Estimates variance based on a sample
Rarely Used
VARA
Estimates variance based on a sample, including numbers, text, and logical values
Rarely Used
VARP
Calculates variance based on the entire population
Rarely Used
VARPA
Calculates variance based on the entire population, including numbers, text, and logical values
Rarely Used
WEIBULL
Returns the Weibull distribution
Rarely Used
ZTEST
Returns the two-tailed P-value of a z-test
In Excel 2007 and Up
Rarely Used
AVERAGEIF
Calculates the average within a range that meet a given criteria (SUMPRODUCT does better)
Rarely Used
AVERAGEIFS
Calculates the average within a range that meet one or many given criteria (SUMPRODUCT does better)
Rarely Used
COUNTIFS
Counts the number of nonblank cells within a range that meet the given criteria (SUMPRODUCT does better)