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