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 an inverse value to one-tailed chi-squared distribution probability. |
ChiTest | The method returns value of 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 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 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 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 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 | 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. |
See also: