# 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