| |
Method name |
Brief description |
 |
AveDev |
The AveDev method returns the average of absolute values of data point deviations from the average. |
|
Average |
The Average method returns arithmetic mean of its arguments. |
|
AverageDcml |
The AverageDcml method returns arithmetic mean of arguments of the Decimal type. |
|
BetaDist |
The BetaDist method returns the integral function of beta probability density. |
|
BetaInv |
The BetaInv method returns the inverse function for integral function of beta probability density. |
|
BinomDist |
The BinomDist method returns a separate value for binomial distribution. |
|
ChiDist |
The ChiDist method returns a single-sided probability for chi-square distribution. |
|
ChiInv |
The ChiInv method returns the value inverse to single-sided probability of chi-square distribution. |
|
ChiTest |
The ChiTest method returns the independence criterion: value of χ2 (chi-square) distribution for statistical distribution and corresponding number of degrees of freedom. |
|
Confidence |
The Confidence method returns a confidence interval for the population mean. |
|
Correl |
The Correl method returns correlation coefficient between two series. |
|
Count |
The Count property returns the number of non-empty elements in the array. |
|
CountBlank |
The CountBlank property returns the number of empty elements in the array. |
|
Covar |
The Covar method returns covariance, that is, the mean of deviation products for each pair of data points. |
|
CritBinom |
The CritBinom method returns the least value for which integral binomial distribution is greater or equal to the specified criterion. |
|
DevSq |
The DevSq method returns the sum of data points' squared deviations from their mean. |
|
Dispersion |
The Dispersion method estimates variance of the sample. |
|
DispersionDcml |
The DispersionDcml method estimates variance by sample of the Decimal type. |
|
DispersionP |
The DispersionP method calculates variance for population. |
|
DurbinWatsonProbabilities |
The DurbinWatsonProbabilities method calculates probability values of Durbin-Watson statistics range bounds. |
|
DurbinWatsonStats |
The DurbinWatsonStats method returns approximated values of Durbin-Watson statistics range bounds taken from tables. |
|
ExponDist |
The ExponDist method returns an exponential distribution. |
|
FDist |
The FDist method returns the F-distribution of probability. |
|
FInv |
The FInv method returns the inverse value for F-distribution of probabilities. |
|
Fisher |
The Fisher method returns the Fisher transform for the Value argument. |
|
FisherInv |
The FisherInv method returns the inverse Fisher transform. |
|
Forecast |
The Forecast method calculates a future value by existing values. |
|
Frequency |
The Frequency method calculates the frequency of value occurrences in a value range and returns a number array. |
|
FTest |
The FTest method returns the F-test result. |
|
GammaDist |
The GammaDist method returns gamma distribution. |
|
GammaFunc |
The GammaFunc property returns value of Gamma function for selected argument. |
|
GammaInv |
The GammaInv method returns the inverse Gamma distribution. |
|
GammaLn |
The GammaLn method returns the natural logarithm of the Gamma function. |
|
GeoMean |
The GeoMean method returns the geometrical mean of positive number array values. |
|
Growth |
The Growth method calculates predictable exponential growth based on existing data. |
|
HarMean |
The HarMean method returns the harmonic mean of a data set. |
|
HypGeomDist |
The HypGeomDist method returns the hypergeometric distribution. |
|
Intercept |
The Intercept method calculates the point, at which a line intersects the Y axis. |
|
JarqueBeraStat |
The JarqueBeraStat method returns the Jarque-Bera statistics. |
|
Kurt |
The Kurt method returns data set kurtosis. |
|
KurtDcml |
The KurtDcml method returns kurtosis of data set of the Decimal type. |
|
Large |
The Large method returns the k-th greatest value from a data set. |
|
Linest |
The Linest method estimates statistics for a series using the least squares method. |
|
Logest |
The Logest method returns exponential trend parameters. |
|
LogInv |
The LogInv method returns the inverse function of a lognormal distribution. |
|
LogNormDist |
The LogNormDist method returns the integral logarithmic normal distribution. |
|
Max |
The Max method returns the maximum value from the specified set of values. |
|
MaxDcml |
The MaxDcml method returns the greatest value from the set of values of the Decimal type. |
|
Median |
The Median method returns the median of specified numbers. |
|
MedianDcml |
The MedianDcml method returns median of the set numbers of the Decimal type. |
|
Min |
The Min method returns the minimum value from a specified set of values. |
|
MinDcml |
The MaxDcml method returns the least value from the set of values of the Decimal type. |
|
Mode |
The Mode method returns a mode, that is, the most frequently occurring value in a data array. |
|
NegBinomDist |
The NegBinomDist method returns the negative binomial distribution. |
|
NormDist |
The NormDist method returns the normal distribution function for the specified mean and standard deviation. |
|
NormInv |
The NormInv method returns the inverse normal distribution. |
|
NormsDist |
The NormsDist method returns the standard normal distribution. |
|
NormsInv |
The NormsInv method returns the inverse value for standard normal distribution. |
|
Pearson |
The Pearson method returns the Pearson correlation coefficient (r). |
|
Percentile |
The Percentile method returns the k-th percentile for interval values. |
|
PercentileDcml |
The PercentileDcml method returns the k-th percentile for values of the Decimal type from the set interval. |
|
PercentRank |
The PercentRank method returns the rank of a value in a data set as the value percentage in the data set. |
|
Permut |
The Permut method returns the number of permutations for the specified number of objects. |
|
Poisson |
The Poisson method returns the Poisson distribution. |
|
Prob |
The Prob method returns the probability for an interval value to be within the specified limits. |
|
Quartile |
The Quartile method returns the data set quartile. |
|
QuartileDcml |
The QuartileDcml method returns quartile of data set of the Decimal type. |
|
Rank |
The Rank method returns the rank of a number in a number array. |
|
Rsq |
The Rsq method returns the squared Pearson correlation coefficient. |
|
Skew |
The Skew method returns the distribution skewness. |
|
SkewDcml |
The SkewDcml method returns skewness of distribution for data of the Decimal type. |
|
Slope |
The Slope method returns the slope of the linear regression line. |
|
Small |
The Small method returns the k-th least value of a data set. |
|
Standardize |
The Standardize method returns a normalized value for distribution with medium or standard deviation. |
|
StDev |
The StDev method estimates standard deviation by a sample. |
|
StDevDcml |
The StDevDcml method estimates standard deviation by sample of the Decimal type. |
|
StDevP |
The StDevP method calculates standard deviation of the population. |
|
SteYX |
The SteYX method returns the standard error of predicted Y values for each X value in a regression. |
|
TDist |
The TDist method returns the percent points (probability) for the Student's t-distribution. |
|
TInv |
The TInv method returns the t-value of the Student's distribution as the function of probability and the number of degrees of freedom. |
|
Trend |
The Trend method returns values for a linear trend. |
|
TrimMean |
The TrimMean method returns the data set interior mean. |
|
TTest |
The TTest method returns the probability for the Student's criterion. |
|
Weibull |
The Weibull method returns the Weibull distribution. |
|
ZTest |
The ZTest method returns the bilateral P-value of the z-test. |
