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 an inverse function of cumulative beta probability density function.
BinomDist	The method returns a single binomial distribution value.
ChiDist	The method returns the one-tailed probability of the chi-squared distribution.
ChiInv	The method returns an inverse value to one-sided chi-squared distribution probability.
ChiTest	The method returns value of chi-squared distribution.
Confidence	The method returns confidence interval for 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 least value, for which integral binomial distribution is greater or equal to a specified criterion.
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 the entire 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 the Value argument.
FisherInv	The method returns the inverse of the Fisher transformation.
Forecast	The method calculates a future value based on existing 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 harmonic mean for a data set.
HypGeomDist	The method returns the hypergeometric distribution.
Intercept	The method calculates the point where a line crosses the y axis using KnownXs and KnownYs.
JarqueBeraStat	The method returns the Jarque-Bera statistics.
Kurt	The method returns data set kurtosis.
Large	The method returns k-th greatest value of a data set.
Linest	The method calculates series statistics using the least squares method to calculate the straight line that approximates available data in the best way.
LogInv	The method returns the inverse function of lognormal distribution.
LogNormDist	The method returns the cumulative lognormal distribution.
Median	The method returns median of specified numbers.
Mode	The method returns mode, that is, the most frequently occurring or repetitive value in a data array.
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 value category in a data set as a percentage in this data set.
Permut	The method returns the number of permutations for a specified number of objects.
Poisson	The method returns the Poisson distribution.
Prob	The method returns probability that a range value lies within 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 distribution skew.
Slope	The method returns the slope of the linear regression line.
Small	The method returns the 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 should be calculated.
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	The method returns mean for 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.