Statistical Functions

Statistical Functions
Name	Description
avg	Average of values
min	Minimum value
max	Maximum value
stdev	Standard deviation
stdevp	Population standard deviation
linest	Multiple linear regression (least squares) : linest(dependent, {independent}*)
var	Variance
count	Count (sample size)
skew	Skewness
kurt	Kurtosis
geomean	Geometric mean
median	Median
mode	Mode
covar	Covariance
correl	Correlation coefficient
mvcorr	Moving Correlation. Syntax mvcorr(a,b) or mvcorr(a,b,interval)
mvcovar	Moving Covariance. Syntax mvcovar(a,b) or mvcovar(a,b,interval)
cagr	Compound Annual Growth Rate. Syntax cagr(a)