IStatistics

The IStatistics interface contains properties and methods for working with statistics characteristics and functions.

Inheritance Hierarchy

Comments

If on calculating a function or characteristic an error occurred, the 1.#QNAN value is returned.

Properties

Methods

	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.

	Property name	Brief description
	Errors	The Errors property returns a message showing all the errors and warnings occurred during calculations.
	Status	The Status property returns the calculation execution status.

IStatistics

Description

Inheritance Hierarchy

Comments

Properties

Methods