Statistical Functions

The list of predefined statistical functions is given in the table below:

Function	Brief description
_Frequency	The method calculates how often values occur within a range of values, and then returns an array of numbers.
AveDev	The method returns the average of the absolute data points deviations from the mean.
BetaDist	The method returns the beta cumulative distribution function.
BetaInv	The method returns the inverse of the cumulative distribution function for a specified beta distribution.
BinomDist	The method returns the individual value of binomial distribution.
ChiDist	The method returns the one-tailed probability of the chi-squared distribution.
ChiInv	The method returns the inverse of the one-tailed probability of the chi-squared distribution.
ChiTest	The method returns a value for the chi-squared distribution.
Confidence	The method returns the confidence interval for a population mean.
Correl	The method returns the correlation coefficient between A1 and A2.
Covar	The method returns covariance, that is, the average of the products for each pair of data points.
CritBinom	The method returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value.
DevSq	The method returns sum of squares of data point deviations from mean.
Dispersion	The method estimates variance of the sample.
DispersionP	The method calculates variance for population.
ExponDist	The method returns exponential distribution.
FDist	The method returns the F-probability distribution.
FInv	The method returns the inverse of the F-probability distribution.
Fisher	The method returns the Fisher transformation for Value argument.
FisherInv	The method returns the inverse of the Fisher transformation.
Forecast	The method estimates a future value using available values.
FTest	The method returns the result of an F-test.
GammaDist	The method returns the gamma distribution.
GammaInv	The method returns the inverse of gamma distribution.
GammaLn	The method returns the natural logarithm of the gamma function.
GeoMean	The method returns geometric mean of positive number array' values.
HarMean	The method returns the harmonic mean of a data set.
HypGeomDist	The method returns the hypergeometric distribution.
Intercept	The method returns the intercept of the line with the Y axis using KnownXs and KnownYs.
JarqueBeraStat	The method returns Jarque-Bera statistics.
Kurt	The method returns the kurtosis of a data set.
Large	The method returns the k-th largest value in a data set.
Linest	The method calculates the statistics for a line by using the least squares method to calculate a straight line that best approximates the available data.
LogInv	The method returns the inverse function of lognormal distribution.
LogNormDist	The method returns the cumulative lognormal distribution.
Median	The method returns the median of the given numbers.
Mode	The method returns the most frequently occurring, or repetitive, value in an array of data.
NegBinomDist	The method returns the negative binomial distribution.
NormDist	The method returns normal distribution function for the specified mean and standard deviation.
NormInv	The method returns the inverse of the normal distribution.
NormsDist	The method returns the standard normal cumulative distribution function.
NormsInv	The method returns the inverse of the standard normal cumulative distribution.
Pearson	The method returns the Pearson correlation coefficient (r).
Percentile	The method returns the k-th percentile of values in a range.
PercentRank	The method returns the rank of a value in a data set as a percentage of the data set.
Permut	The method returns the number of permutations for a given number of objects.
Poisson	The method returns the Poisson distribution.
Prob	The method returns the probability that value in a range is between the specified limits.
Quartile	The method returns the quartile of a data set.
Rank	The method returns the rank of a number in an array of numbers.
Rsq	The method returns the square of the Pearson correlation coefficient (r^2).
Skew	The method returns the skewness of a distribution.
Slope	The method returns the slope of the linear regression line.
Small	The method returns k-th least value in a data set.
Standardize	The method returns normalized value for the distribution described by the mean and standard deviation.
StDev	The method estimates standard deviation based on a sample.
StDevP	The method calculates standard deviation based on the entire population.
SteYX	The method returns the standard error of the predicted Y values for each X value in the regression.
TDist	The method returns the percentage points (probability) for the Student t-distribution, where a numeric value (x) is a calculated value for which the percentage points are to be computed.
TInv	The method returns t-value of the Student's distribution as a probability function and the number of degrees of freedom.
Trend	The method returns values along a linear trend.
TrimMean	Returns the mean of the interior of a data set.
TTest	The method returns the probability associated with the Student's criterion.
Weibull	The method returns the Weibull distribution.
ZTest	The method returns the two-tailed P-value of a z-test.