Declarations Section, MathStatistics_Initialize Sub, SampleData Property, StatVarType Property, Array2D Sub, Average Function, AverageArray Function, AverageDeviation Function, AverageDeviationArray Function, ChiTst Function, ChiTstVerify Sub, ConcatAllTypes Sub, ConcatInit Sub, ConcatIsNumeric Sub, ConcatNumeric Sub, ConcatNumericAndString Sub, ConcatTerm Sub, Correlation Function, Count Function, CountEqual Function, Covariance Function, DeviationsSquared Function, DeviationsSquaredArray Function, Fisher Function, FisherInverse Function, FlattenNumeric Sub, Forecast Function, GeometricMean Function, GeometricMeanArray Function, HarmonicMean Function, HarmonicMeanArray Function, Intercept Function, Kurtosis Function, KurtosisArray Function, KurtosisExcel Function, KurtosisExcelArray Function, Large Function, Maximum Function, MaximumArray Function, Median Function, MedianDeviation Function, MedianOfThree Function, MedianOfThreeVerify Sub, Minimum Function, MinimumArray Function, Mode Function, Pearson Function, Percentile Function, PercentRank Function, Probability Function, Product Function, ProductArray Function, Quartile Function, Range Function, RangeArray Function, Rank Function, RSquared Function, Skew Function, SkewArray Function, SkewExcel Function, SkewExcelArray Function, Slope Function, Small Function, StandardDeviation Function, StandardDeviationArray Function, StandardDeviationPopulation Function, StandardDeviationPopulationArray Function, StandardError Function, Standardize Function, Sum Function, SumArray Function, SumOfSquares Function, SumOfSquaresArray Function, TrimMean Function, Variance Function, VarianceArray Function, VariancePopulation Function, VariancePopulationArray Function, ZTst Function

Declarations Section

 

Math Statistics _ Initialize Sub

Initialize the MathStatistics Class, describing which numeric data types will be operated upon by the functions in this Class.

Sample Data Property

Returns an array of sample data for use in testing the statistical functions.

Stat Var Type Property

Determine if a specific numeric type of variable will be recognized by the statistical routines. Set whether a specific numeric type of variable will be recognized by the statistical routines.

Array 2D Sub

Converts a one-dimensional array into a two-dimensional array. See the examples in the ChiTstVerify function.

Average Function

Average (mean) value of numeric arguments.

Average Array Function

Average (mean) of numeric values. More efficient version of the Average Function but with restrictions on the arguments it accepts.

Average Deviation Function

Average deviation of numeric values from the mean.

Average Deviation Array Function

Average deviation of numeric values from the mean. More efficient version of the AverageDeviation Function but with restrictions on the arguments it accepts.

Chi Tst Function

Returns the chi-squared (X2) test for independence.

Chi Tst Verify Sub

Test the ChiTst function.

Concat All Types Sub

Concatenate all types of elements from vInput to array rOutput using counter rCount.

Concat Init Sub

Initialize the array and counter for the array concatenation routines.

Concat Is Numeric Sub

Concatenate numeric elements from vInput to array rOutput using counter rCount.

Concat Numeric Sub

Concatenate numeric elements from vInput to array rOutput using counter rCount.

Concat Numeric And String Sub

Concatenate numeric, boolean, and string numeric elements from vInput to array rOutput using counter rCount.

Concat Term Sub

Redimension the array rOutput based upon the number of elements according to the counter rCount.

Correlation Function

Returns the correlation coefficient of arrays vXValues and vYValues.

Count Function

Count the number of arguments that are numeric.

Count Equal Function

Count number of numeric arguments equal to the value vEqual.

Covariance Function

Returns the average of the products of the deviations for each data point pair.

Deviations Squared Function

Square of deviations of numeric values from the mean.

Deviations Squared Array Function

Square of deviations of numeric values from the mean. More efficient version of the DeviationsSquared Function but with restrictions on the arguments it accepts.

Fisher Function

Return the Fisher transformation at X.

Fisher Inverse Function

Return the inverse of the Fisher Transformation.

Flatten Numeric Sub

Accept an Array that contains other arrays and produces a one-dimensional array of "atomic" (non-array) elements.

Forecast Function

Predicts a future Y value for a specified X value using linear regression.

Geometric Mean Function

Geometric mean of positive numeric arguments.

Geometric Mean Array Function

Geometric mean of positive numeric values. More efficient version of the GeometricMean Function but with restrictions on the arguments it accepts.

Harmonic Mean Function

Harmonic mean of numeric arguments.

Harmonic Mean Array Function

Harmonic mean of numeric values. More efficient version of the HarmonicMean Function but with restrictions on the arguments it accepts.

Intercept Function

Calculates the point at which a line will intercept the Y axis using existing vYValues and vXValues. This point is based on a best-fit regression line plotted through the existing vYValues and vXValues.

Kurtosis Function

Returns the kurtosis of a distribution, as defined in Numerical Recipes in C, Second Edition. Measures the relative peakedness or flatness of a distribution.

Kurtosis Array Function

Returns the kurtosis of a distribution, as defined in Numerical Recipes in C, Second Edition. More efficient version of the Kurtosis Function but with restrictions on the arguments it accepts. Measures the relative peakedness or flatness of a distribution.

Kurtosis Excel Function

Returns the kurtosis of a distribution, as defined by Microsoft Excel. Measures the relative peakedness or flatness of a distribution.

Kurtosis Excel Array Function

Returns the kurtosis of a distribution, as defined by Microsoft Excel. More efficient version of the KurtosisExcel Function but with restrictions on the arguments it accepts. Measures the relative peakedness or flatness of a distribution.

Large Function

Returns the Nth largest number within vValues.

Maximum Function

Maximum of numeric arguments.

Maximum Array Function

Maximum of numeric values. More efficient version of the Maximum Function but with restrictions on the arguments it accepts.

Median Function

Median (middle) value of numeric arguments.

Median Deviation Function

Average deviation of numeric values from the median value.

Median Of Three Function

Median (or middle) of the three numeric arguments.

Median Of Three Verify Sub

Test the MedianOfThree function.

Minimum Function

Minimum of numeric arguments.

Minimum Array Function

Minimum of numeric values. More efficient version of the Minimum Function but with restrictions on the arguments it accepts.

Mode Function

Mode (most-frequently-occurring) value of numeric arguments.

Pearson Function

Returns the Pearson product moment correlation coefficient.

Percentile Function

Return the value from vValues at the Nth percentile. Inverse of the PercentRank function.

Percent Rank Function

Returns the rank of a value as a percentage of the values in the data set. Inverse of the Percentile function.

Probability Function

Returns the probability that the values in range vXValues are between two limits.

Product Function

Product of numeric arguments.

Product Array Function

Product of numeric values. More efficient version of the Product Function but with restrictions on the arguments it accepts.

Quartile Function

Returns the value from vValues at the quartile vQuartile.

Range Function

Range of numeric arguments. Return the difference between the maximum and minimum values.

Range Array Function

Range of numeric values. Return the difference between the maximum and minimum values. More efficient version of the Range Function but with restrictions on the arguments it accepts.

Rank Function

Returns the rank of the number vN within the numbers in vValues. vAscending determines how the numbers in vValues are sorted to determine the rank of vN.

R Squared Function

Returns the square of the Pearson product moment correlation coefficient. The proportion of the variance in Y attributable to the variance in X.

Skew Function

Returns the skewness of a distribution, as defined in Numerical Recipes in C, Second Edition. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Skew Array Function

Returns the skewness of a distribution, as defined in Numerical Recipes in C, Second Edition. More efficient version of the Skew Function but with restrictions on the arguments it accepts. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Skew Excel Function

Returns the skewness of a distribution, as defined by Microsoft Excel. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Skew Excel Array Function

Returns the skewness of a distribution, as defined by Microsoft Excel. More efficient version of the SkewExcel Function but with restrictions on the arguments it accepts. The skewness characterizes the degree of asymmetry of a distribution around its mean.

Slope Function

Returns the slope of the linear regression line through data points in vYValues and vXValues.

Small Function

Returns the Nth smallest number within vValues.

Standard Deviation Function

Standard deviation of numeric arguments.

Standard Deviation Array Function

Standard deviation of numeric values. More efficient version of the StandardDeviation Function but with restrictions on the arguments it accepts.

Standard Deviation Population Function

Population standard deviation of numeric arguments.

Standard Deviation Population Array Function

Population standard deviation of numeric values. More efficient version of the StandardDeviationPopulation Function but with restrictions on the arguments it accepts.

Standard Error Function

Returns the standard error of the Y value for each X value in the linear regression.

Standardize Function

Returns a normalized value from a distribution with mean vMean and standard deviation vStdDev.

Sum Function

Sum (total) of numeric arguments.

Sum Array Function

Sum (total) of numeric values. More efficient version of the Sum Function but with restrictions on the arguments it accepts.

Sum Of Squares Function

Sum of squares of numeric arguments.

Sum Of Squares Array Function

Sum of squares of numeric values. More efficient version of the SumOfSquares Function but with restrictions on the arguments it accepts.

Trim Mean Function

Returns the mean of the values in the middle of a data set by excluding vPercent of the data points, half at the top and half at the bottom of the data.

Variance Function

Variance of numeric arguments.

Variance Array Function

Variance of numeric values. More efficient version of the Variance Function but with restrictions on the arguments it accepts.

Variance Population Function

Population variance of numeric arguments.

Variance Population Array Function

Population variance of numeric values. More efficient version of the VariancePopulation Function but with restrictions on the arguments it accepts.

Z Tst Function

Returns the two-tailed P-value of a z-test.

This Windows-based ActiveX DLL provides many useful routines through its function-bearing and data structure classes. Consult the Help file for more information, or call us at 1-310-472-3736. For the latest news and files, visit our home page on the World Wide Web: http://www.entisoft.com