Statistics

ADTEST — Anderson-Darling Test of Normality
AVEDEV — average of the absolute deviations of a data set
AVERAGE — average of all the numeric values and cells
AVERAGEA — average of all the values and cells
BERNOULLI — probability mass function of a Bernoulli distribution
BETADIST — cumulative distribution function of the beta distribution
BETAINV — inverse of the cumulative distribution function of the beta distribution
BINOM.DIST.RANGE — probability of the binomial distribution over an interval
BINOMDIST — probability mass or cumulative distribution function of the binomial distribution
CAUCHY — probability density or cumulative distribution function of the Cauchy, Lorentz or Breit-Wigner distribution
CHIDIST — survival function of the chi-squared distribution
CHIINV — inverse of the survival function of the chi-squared distribution
CHITEST — p value of the Goodness of Fit Test
CONFIDENCE — margin of error of a confidence interval for the population mean
CORREL — Pearson correlation coefficient of two data sets
COUNT — total number of integer or floating point arguments passed
COUNTA — number of arguments passed not including empty cells
COVAR — covariance of two data sets
COVARIANCE.S — sample covariance of two data sets
CRITBINOM — right-tailed critical value of the binomial distribution
CRONBACH — Cronbach's alpha
CVMTEST — Cramér-von Mises Test of Normality
DEVSQ — sum of squares of deviations of a data set
EXPONDIST — probability density or cumulative distribution function of the exponential distribution
EXPPOWDIST — the probability density function of the Exponential Power distribution
FDIST — survival function of the F distribution
FINV — inverse of the survival function of the F distribution
FISHER — Fisher transformation
FISHERINV — inverse of the Fisher transformation
FORECAST — estimates a future value according to existing values using simple linear regression
FREQUENCY — frequency table
FTEST — p-value for the two-tailed hypothesis test comparing the variances of two populations
GAMMADIST — probability density or cumulative distribution function of the gamma distribution
GAMMAINV — inverse of the cumulative gamma distribution
GEOMDIST — probability mass or cumulative distribution function of the geometric distribution
GEOMEAN — geometric mean
GROWTH — exponential growth prediction
HARMEAN — harmonic mean
HYPGEOMDIST — probability mass or cumulative distribution function of the hypergeometric distribution
INTERCEPT — the intercept of a linear regression line
KURT — unbiased estimate of the kurtosis of a data set
KURTP — population kurtosis of a data set
LANDAU — approximate probability density function of the Landau distribution
LAPLACE — probability density function of the Laplace distribution
LARGE — k-th largest value in a data set
LEVERAGE — calculate regression leverage
LINEST — multiple linear regression coefficients and statistics
LKSTEST — Lilliefors (Kolmogorov-Smirnov) Test of Normality
LOGEST — exponential least square fit
LOGFIT — logarithmic least square fit (using a trial and error method)
LOGINV — inverse of the cumulative distribution function of the lognormal distribution
LOGISTIC — probability density function of the logistic distribution
LOGNORMDIST — cumulative distribution function of the lognormal distribution
LOGREG — the logarithmic regression
MAX — largest value, with negative numbers considered smaller than positive numbers
MAXA — largest value, with negative numbers considered smaller than positive numbers
MEDIAN — median of a data set
MIN — smallest value, with negative numbers considered smaller than positive numbers
MINA — smallest value, with negative numbers considered smaller than positive numbers
MODE — first most common number in the dataset
NEGBINOMDIST — probability mass function of the negative binomial distribution
NORMDIST — probability density or cumulative distribution function of a normal distribution
NORMINV — inverse of the cumulative distribution function of a normal distribution
NORMSDIST — cumulative distribution function of the standard normal distribution
NORMSINV — inverse of the cumulative distribution function of the standard normal distribution
OWENT — Owen's T function
PARETO — probability density function of the Pareto distribution
PEARSON — Pearson correlation coefficient of the paired set of data
PERCENTILE — determines the 100*k-th percentile of the given data points
PERCENTRANK — rank of a data point in a data set
PERMUT — number of k-permutations of a n-set
PERMUTATIONA — the number of permutations of y objects chosen from x objects with repetition allowed
POISSON — probability mass or cumulative distribution function of the Poisson distribution
PROB — probability of an interval for a discrete (and finite) probability distribution
QUARTILE — the k-th quartile of the data points
R.DBETA — probability density function of the beta distribution
R.DBINOM — probability density function of the binomial distribution
R.DCAUCHY — probability density function of the Cauchy distribution
R.DCHISQ — probability density function of the chi-square distribution
R.DEXP — probability density function of the exponential distribution
R.DF — probability density function of the F distribution
R.DGAMMA — probability density function of the gamma distribution
R.DGEOM — probability density function of the geometric distribution
R.DHYPER — probability density function of the hypergeometric distribution
R.DLNORM — probability density function of the log-normal distribution
R.DNBINOM — probability density function of the negative binomial distribution
R.DNORM — probability density function of the normal distribution
R.DPOIS — probability density function of the Poisson distribution
R.DSNORM — probability density function of the skew-normal distribution
R.DST — probability density function of the skew-t distribution
R.DT — probability density function of the Student t distribution
R.DWEIBULL — probability density function of the Weibull distribution
R.PBETA — cumulative distribution function of the beta distribution
R.PBINOM — cumulative distribution function of the binomial distribution
R.PCAUCHY — cumulative distribution function of the Cauchy distribution
R.PCHISQ — cumulative distribution function of the chi-square distribution
R.PEXP — cumulative distribution function of the exponential distribution
R.PF — cumulative distribution function of the F distribution
R.PGAMMA — cumulative distribution function of the gamma distribution
R.PGEOM — cumulative distribution function of the geometric distribution
R.PHYPER — cumulative distribution function of the hypergeometric distribution
R.PLNORM — cumulative distribution function of the log-normal distribution
R.PNBINOM — cumulative distribution function of the negative binomial distribution
R.PNORM — cumulative distribution function of the normal distribution
R.PPOIS — cumulative distribution function of the Poisson distribution
R.PSNORM — cumulative distribution function of the skew-normal distribution
R.PST — cumulative distribution function of the skew-t distribution
R.PT — cumulative distribution function of the Student t distribution
R.PWEIBULL — cumulative distribution function of the Weibull distribution
R.QBETA — probability quantile function of the beta distribution
R.QBINOM — probability quantile function of the binomial distribution
R.QCAUCHY — probability quantile function of the Cauchy distribution
R.QCHISQ — probability quantile function of the chi-square distribution
R.QEXP — probability quantile function of the exponential distribution
R.QF — probability quantile function of the F distribution
R.QGAMMA — probability quantile function of the gamma distribution
R.QGEOM — probability quantile function of the geometric distribution
R.QHYPER — probability quantile function of the hypergeometric distribution
R.QLNORM — probability quantile function of the log-normal distribution
R.QNBINOM — probability quantile function of the negative binomial distribution
R.QNORM — probability quantile function of the normal distribution
R.QPOIS — probability quantile function of the Poisson distribution
R.QSNORM — probability quantile function of the skew-normal distribution
R.QST — probability quantile function of the skew-t distribution
R.QT — probability quantile function of the Student t distribution
R.QWEIBULL — probability quantile function of the Weibull distribution
RANK — rank of a number in a list of numbers
RANK.AVG — rank of a number in a list of numbers
RAYLEIGH — probability density function of the Rayleigh distribution
RAYLEIGHTAIL — probability density function of the Rayleigh tail distribution
RSQ — square of the Pearson correlation coefficient of the paired set of data
SFTEST — Shapiro-Francia Test of Normality
SKEW — unbiased estimate for skewness of a distribution
SKEWP — population skewness of a data set
SLOPE — the slope of a linear regression line
SMALL — k-th smallest value in a data set
SSMEDIAN — median for grouped data
STANDARDIZE — z-score of a value
STDEV — sample standard deviation of the given sample
STDEVA — sample standard deviation of the given sample
STDEVP — population standard deviation of the given population
STDEVPA — population standard deviation of an entire population
STEYX — standard error of the predicted y-value in the regression
SUBTOTAL — the subtotal of the given list of arguments
TDIST — survival function of the Student t-distribution
TINV — inverse of the survival function of the Student t-distribution
TREND — estimates future values of a given data set using a least squares approximation
TRIMMEAN — mean of the interior of a data set
TTEST — p-value for a hypothesis test comparing the means of two populations using the Student t-distribution
VAR — sample variance of the given sample
VARA — sample variance of the given sample
VARP — variance of an entire population
VARPA — variance of an entire population
WEIBULL — probability density or cumulative distribution function of the Weibull distribution
ZTEST — the probability of observing a sample mean as large as or larger than the mean of the given sample