Login
Register
Contact Us
Search
Menu
Home
Products
XLeratorDB
function packages
for SQL Server
financial
view documentation
pricing
statistics
view documentation
pricing
math
view documentation
pricing
engineering
view documentation
pricing
strings
view documentation
pricing
financial-options
view documentation
pricing
windowing
view documentation
pricing
XLeratorDB
Compilation packages
for SQL Server
Suite
incl:
financial
,
statistics
,
math
,
engineering
&
strings
pricing
Suite (Developer)
requires SQL Server Developer Edition
pricing
Suite (Subscription)
One-year non-recurring license
pricing
SuitePLUS
incl: all Suite packages PLUS
financial-options
pricing
SuitePLUS (Developer)
requires SQL Server Developer Edition, also incl:
financial-options
pricing
SuitePLUS (Subscription)
One-year non-recurring license, also incl:
financial-options
pricing
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
view documentation
pricing
SQL Server not required
View All Product Pricing ...
Download Free 15 Day Trial ...
Documentation
Purchase
XLeratorDB
function packages for
SQL Server (2008 & later)
financial
statistics
math
engineering
strings
financial-options
windowing
XLeratorDB
Compilation packages for
SQL Server (2008 & later)
Suite
Suite (Developer)
Suite (Subscription)
SuitePLUS
SuitePLUS (Developer)
SuitePLUS (Subscription)
XLeratorDLL
function packages
Microsoft .NET API Library
financial (DLL)
Legacy XLeratorDB Packages for
SQL Server 2005
financial
for SQL Server 2005 only
statistics
for SQL Server 2005 only
math
for SQL Server 2005 only
Suite
for SQL Server 2005 only
Suite (Developer)
for SQL Server 2005 only
SuitePLUS
for SQL Server 2005 only
SuitePLUS (Developer)
for SQL Server 2005 only
Download Trial
Case Studies
Blog
Support
XLeratorDB/statistics Documentation
Home
Search
Recent Changes
Show All Pages
Statistics Functions Index ...
Statistical Functions
Continuous Data
Location
AVERAGE - average (arithmetic mean) of a dataset
AVERAGE_q - average (arithmetic mean) of a dataset
COUNT - count of numeric rows in a dataset
COUNT_q - count of numeric rows in a dataset
GEOMEAN - geometric mean of a dataset
GEOMEAN_q - geometric mean of a dataset
HARMEAN - harmonic mean of a dataset
HARMEAN_q - harmonic mean of a dataset
MEDIAN - median value in a dataset
MEDIAN_q - median value in a dataset
MODE - mode (most frequent value) of a dataset
MODE_q - mode (most frequent value) of a dataset
TRIMMEAN - mean of the interior of a dataset
TRIMMEAN_q - mean of the interior of a dataset
Dispersion
AVEDEV - average deviation
AVEDEV_q - average deviation
COVAR - covariance
COVAR_q - covariance
COVARIANCE_P - population covariance
COVARIANCE_S - sample covariance
DEVSQ - deviation squared
DEVSQ_q - deviation squared
IPR - inter-percentile range
IQR - inter-quartile range
KURTOSIS_P - population kurtosis
KURTOSIS_S - sample kurtosis
LARGE - kth largest value in a dataset
LARGE_q - kth largest value in a dataset
PERCENTILE - percentile
PERCENTILE_q - percentile
PERCENTILE_EXC - percentile
PERCENTILES - any number of percentiles from a set of values
PERCENTRANK - rank of a value in a dataset as a percentage of the dataset
PERCENTRANK_q - rank of a value in a dataset as a percentage of the dataset
PERCENTRANK_EXC - rank of a value in a dataset
PERCENTRANKS - relative standing of values within a dataset
QUARTILE - specified quartile of a dataset
QUARTILE_q - specified quartile of as dataset
QUARTILE_EXC - specified quartile of a dataset
RANGE - difference between the minimum and maximum values in a dataset
RANK - rank of a number in a list of numbers
RANK_q - rank of a number in a list of numbers
RANKAVG - average rank of a number in a list of numbers
SKEWNESS_P - skewness for an entire population
SKEWNESS_S - sample skewness
SMALL - kth smallest value in a dataset
SMALL_q - kth smallest value in a dataset
STDEV - estimated standard deviation based on a sample
STDEV_q - estimated standard deviation based on a sample
STDEVP - standard deviation for an entire population
STDEVP_q - standard deviation for an entire population
STDEV_P - standard deviation for an entire population
STDEV_S - estimated standard deviation based on a sample
VAR_P - variance for an entire population
VAR_S - estimate variance based on a sample
Shape
KURT - kurtosis of a dataset
KURT_q - kurtosis of a dataset
SKEW - degree of asymmetry of a distribution
SKEW_q - degree of asymmetry of a distribution
VAR - estimate variance based on a sample
VAR_q - estimate variance based on a sample
VARP - variance for an entire population
VARP_q - population variance
Statistical Inference
Specific Tests
CHISQ - chi-square (χ2) statistic
CHISQ_q - chi-square (χ2) statistic
CHISQ2 - chi-square (χ2) statistic
CHISQ2_q - chi-square (χ2) statistic
CHISQN - chi-square (χ2) statistic for data in third-normal form
CHISQN_q - chi-square (χ2) statistic for data in third-normal form
CHISQN2 - chi-square (χ2) statistic for data in third-normal form
CHISQN2_q - chi-square (χ2) statistic for data in third-normal form
CHITEST - Pearson chi-square test for independence
CHITEST_q - Pearson chi-square test for independence
CHITEST2 - Pearson chi-square test for independence
CHITEST2_q - Pearson chi-square test for independence
CHITESTN - Pearson chi-square test for independence on data in third-normal form
CHITESTN_q - Pearson chi-square test for independence on data in third-normal form
CHITESTN2 - Pearson chi-square test for independence on data in third-normal form
CHITESTN2_q - Pearson chi-square test for independence on data in third-normal form
FTEST - result of an F-test
FTEST_q - result of an F-test
KSTEST - compare a sample with a reference probability distribution
KSTEST_q - compare a sample with a reference probability distribution
KSTEST2 - two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples
KSTEST2_q - two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples
SFTEST - Shapiro-Francia test for the composite hypothesis of normality
SFTEST_q - Shapiro-Francia test for the composite hypothesis of normality
SWTEST - Shapiro and Wilk’s W statistic and its p-value
SWTEST_q - Shapiro and Wilk’s W statistic and its p-value
TTEST - probability associated with Student’s t-test
TTEST_q - probability associated with Student’s t-test
TTEST_INDEP - t-test on data in two samples assuming equal variance
TTEST_INDEPU - t-test on data in two samples assuming unequal variance
TTEST_PAIRED - t-test on data in two samples assuming unequal variance
ZTEST - one-tailed probability of a Z-test
ZTEST_q - one-tailed probability of a Z-test
Correlation and Regression Analysis
Correlations
CORREL - correlation coefficient between two datasets
CORREL_q - correlation coefficient between two datasets
PEARSON - Pearson product-moment coefficient between two datasets
PEARSON_q - Pearson product-moment coefficient between two datasets
PROB - probability that values in a range are between two limits
PROB_q - probability that values in a range are between two limits
RSQ - Pearson product moment correlation coefficient through data points in known-y’s and known-x’s
RSQ_q - Pearson product moment correlation coefficient through data points in known-y’s and known-x’s
Linear Regressions
EXPPRED - predicted value for a dependent variable using the coeffiecients from a previously run mutlivariate exponential regression
FORECAST - future value by using existing values
FORECAST_q - future value by using existing values
GROWTH - predicted exponential growth by using existing data
GROWTH_q - predicted exponential growth by using existing data
GROWTHMX - values along an exponential trend
GROWTHMX_q - values along an exponential trend
INTERCEPT - point at which a line will intersect the y-axis by using existing x-values and y-values
INTERCEPT_q - point at which a line will intersect the y-axis by using existing x-values and y-values
LINEST - ordinary least squares (OLS) solution for a series of x- and y-values
LINEST_q - ordinary least squares (OLS) solution for a series of x- and y-values
LMPRED - predicted value for a dependent variable using the coefficients from a previously run multivariate linear regression
LOGEST - exponential curve that best fits a series of x- and y-values
LOGEST_q - exponential curve that best fits a series of x- and y-values
SLOPE - slope of the linear regression through the data points in the known x-values and y-values
SLOPE_q - slope of the linear regression through the data points in the known x-values and y-values
TREND - values along a linear trend
TREND_q - values along a linear trend
TRENDMX - values along a linear trend
TRENDMX_q - values along a linear trend
WLS - Weighted least squares solution for a series of x- and y-values and their associated weights
WLS_q - Weighted least squares solution for a series of x- and y-values and their associated weights
Logistic Regressions
LOGIT - binary logistic regression coefficients from a table of x-values (the independent variables) and dichotomous y-values (the dependent variable)
LOGITPRED - probability that Y = 1 given a set of coefficients from a logistic regression and a set of x-values
LOGITPROB - probability that Y = 1 given a set of coefficients from a logistic regression and a set of x-values
LOGITSUM - binary logistic regression coefficients from a table of grouped x-values (the independent variables) with counts of the successes and failures for each group
ROCTable - calculation of the area under the ROC curve
VIF - R-squared
Data Collection
Sampling
KMEANS - k-means clustering in N-dimensions
STEYX - standard error of the predicted y-value for each x in a regression
STEYX_q - standard error of the predicted y-value for each x in a regression
Interobserver Agreement
ICC - intra-class coefficient
ICC_TV - intra-class coefficient
KAPPA_COHEN - Cohen’s kappa (κ) or weighted kappa as an index of inter-rater agreement between 2 raters
KAPPA_COHEN_TV - Cohen’s kappa (κ) or weighted kappa as an index of inter-rater agreement between 2 raters
KAPPA_FLEISS - Fleiss’ kappa (κ) as an index of inter-rater agreement between m raters on categorical data
KAPPA_FLEISS_TV - Fleiss’ kappa (κ) as an index of inter-rater agreement between m raters on categorical data
KENDALLT - Kendall’s tau (τ)
KENDALLT_TV - Kendall’s tau (τ)
KENDALLW - Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data
KENDALLW_TV - Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data
MCNEMAR - McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table
MCNEMAR_TV - McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table
PSIGNRANK - distribution function of the Wilcoxon Signed Rank statistic
RANK_AVG - ranks for a collection of x- and y-values
SPEARMAN - Spearman’s rank correlation coefficient (ρ)
SPEARMAN_TV - Spearman’s rank correlation coefficient (ρ)
WMPSR - Wilcoxon matched-pair signed-rank test
WMPSR_TV - Wilcoxon matched-pair signed-rank test
Probability Functions
Distributions
BETA_DIST - probability density function or cumulative distribution function of a beta distribution for x with shape parameters a and ß
BETADIST - beta cumulative probability density function
BETAINV - quartiles of the beta cumulative distribution function
BETAPDF - probability density function for the beta distribution
BINOM_DIST_RANGE - probability of a trial result using a binomial distribution
BINOMDIST - binomial distribution
BINOMINV - value of number of success in the binomial distribution given the cumulative distribution function
BIVAR - bivariate normal probabilities
CAUCHY - probability density function or the lower cumulative distribution function of the Cauchy distribution
CAUCHYINV - inverse lower cumulative distribution of the Cauchy distribution
CHI2NC - lower cumulative distribution function of the non-central chi-square distribution
CHI2NCINV - inverse of the lower cumulative distribution function of the non-central chi-square distribution
CHIDIST - one-tailed probability of the chi-square distribution
CHIINV - inverse of the one-tailed probability of the chi-square distribution
CHISQ_DIST - probability density or the lower cumulative probability of a chi-squared distribution for x and a number of degrees of freedom
CHISQ_DIST_RT - upper distribution of a chi-squared distribution for x and a number of degrees of freedom
CHISQ_INV - inverse of the left-tailed probability of a chi-squared distribution
CHISQ_INV_RT - inverse of the right-tailed probability of a chi-squared distribution
CHISQPDF - probability density function of the chi square distribution
CONFIDENCE - value that you can use to construct a confidence interval for a population mean
CONFIDENCE_NORM - confidence interval for a population mean
CONFIDENCE_T - confidence interval when you don't know the population standard deviation and are using the sample standard deviation instead
CRITBINOM - smallest value for the cumulative binomial distribution that is greater than or equal to a criterion value
DIGAMMA - digamma(z), the logarithmic derivative of the gamma function
EXPDIST - probability density function or the upper cumulative distribution function of the Exponential distribution
EXPONDIST - exponential distribution that is equivalent to the function used in EXCEL
EXPINV - inverse of the cumulative distribution function of the exponential distribution
F_DIST - probability density or the lower cumulative probability of an F-distribution for x and degrees of freedom for 2 independent random variables
F_DIST_RT - upper cumulative probability of an F-distribution for x and degrees of freedom for 2 independent random variables
FDIST - F probability distribution
FINV - inverse of the F probability distribution
FPDF - probability density function of the F distribution
FISHER - Fisher transformation at x
FISHERINV - inverse of the Fisher transformation
GAMMADIST - gamma distribution
GAMMAINV - inverse of the cumulative gamma distribution
GAMMAP - regularized gamma function P(a
GAMMAQ - regularized gamma function Q(a
GEOMETRIC - probability mass function of the geometric distribution
GEOMETRICP - cumulative distribution function of the geometric distribution
GEOMETRICINV - inverse of the cumulative distribution function of the geometric distribution
HYPGEOM_DIST - pmf or the cdf of the hypergeometric distribution
HYPGEOM_INV - quantiles of the hypergeometric distribution
HYPGEOMDIST - hypergeometric distribution
HYPGEOMDISTP - lower cumulative distribution of the hypergeometric function
HYPGEOMDISTPINV - inverse of the cumulative distribution function of the hypergeometric distribution
HYPGEOMDISTQ - upper cumulative distribution of the hypergeometric function
INVGAMMAP - inverse of the incomplete gamma function P(a
KScdf - cumulative probability P[Dn >= x] of the Kolmogorov-Smirnov distribution with sample size n at x
KSccdf - complementary cumulative probability P[Dn >= x] of the Kolmogorov-Smirnov distribution with sample size n at x
KSP - Kolmogorov-Smirnov (KS) cumulative distribution function
KSPINV - inverse of the Kolmogorov-Smirnov (KS) cumulative distribution function
KSQ - complementary Kolmogorov-Smirnov (KS) cumulative distribution function
KSQINV - inverse of the complementary Kolmogorov-Smirnov (KS) cumulative distribution function
LAPLACE - probability density function or the lower cumulative distribution function of the Laplace distribution
LAPLACEINV - inverse lower cumulative distribution of the Laplace distribution
LOGINV - inverse of the lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation
LOGISTIC - probability density function or the lower cumulative distribution function of the logistic distribution
LOGISTICINV - inverse lower cumulative distribution of the logistic distribution
LOGNORM_DIST - probability density function or the cumulative distributive function of the normal distribution of x
LOGNORM_INV - inverse of the lognormal distribution function of x
LOGNORMDIST - lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation
LOGNORMPDF - probability density function of the lognormal distribution
NCFCDF - lower cumulative distribution function of the non-central F distribution
NCFINV - inverse of the lower cumulative distribution function of the non-central F distribution
NCFPDF - probability density function of the non-central F distribution
NCHISQPDF - probability density function of the non-central chi square distribution
NCTCDF - lower cumulative distribution function of the non-central T distribution
NCTINV - inverse of the lower cumulative distribution function of the non-central T distribution
NCTPDF - probability density function of the non-central T distribution
NEGBINOM_DIST - probability mass function or the cumulative distributive function of the negative binomial distribution
NEGBINOMDIST - negative binomial distribution
NEGBINOMDISTP - cumulative distribution function of the negative binomial distribution
NEGBINOMINV - smallest value of x such that NEGBINOMDISTP(x
NEGHYPGEOM_DIST - probability mass function or the cumulative distributive function of the negative hypergeometric distribution
NEGHYPGEOM_INV - quantiles of the negative hypergeometric distribution
NORMAL - probability density function for the standard normal distribution
NORM_S_DIST - probability density function or the lower cumulative distribution function of the standard normal distribution in SQL Server
NORMDIST - normal distribution for the specified mean and standard deviation
NORMINV - inverse of the normal cumulative distribution function (cdf)
NORMSDIST - standard normal cumulative distribution function
NORMSINV - inverse of the standard normal distribution in SQL Server
POISSON - Poisson distribution
POISSON_DIST - probability mass function or the lower cumulative probability of a Poisson distribution for a given number of events occurring in a fixed interval given the rate
POISSONINV - inverse of the cumulative distribution function of the Poisson distribution
STANDARDIZE - normalized value from a distribution characterized by a mean and standard deviation
STUDENTST - Student’s t-distribution
T_DIST - probability density function and the left-tailed cumulative probability distribution of Student's t-distribution
T_DIST_2T - two-tailed cumulative probability distribution of Student's t-distribution
T_DIST_RT - right-tailed cumulative probability distribution of Student's t-distribution
TDIST - probability for the Student t-distribution where a numeric value (x) is a calculated value of t for which the probability is to be computed
T_INV - inverse of the left-tailed cumulative probability distribution of Student's t-distribution
T_INV_2T - inverse of the two-tailed distribution of Student's t-distribution
TINV - t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
TPDF - probability density function of the T distribution
TRIGAMMA - trigamma(z) the second derviative of the natural log of the gamma function
UNIFORM - probability density function or the lower cumulative distribution function of the uniform distribution
UNIFORMINV - inverse of the lower cumulative distribution of the uniform distribution
WEIBULL - Weibull distribution
WEIBULLINV - inverse of the cumulative distribution function of the Weibull distribution
Combinatorics
BETA - beta function
BETAI - incomplete beta function
BICO - binomial coefficient
FACTLN - natural logarithm of a factorial
FACTORIALPOWER - rising or falling factorials
GAMMA - invoke the (complete) gamma function Γ(x)
GAMMAINC - incomplete gamma function
GAMMALN - natural logarithm of the (complete) gamma function Γ(x)
LCHOOSE - natural logarithm of the binomial coefficient
LPERMUT - natural logarithm of the PERMUT function
LPERMUTA - natural logarithm of the PERMUTATIONA function
MULTINOM - to calculate the probability distribution of the outcomes of a multinomial experiment
PERMUT - number of permutations for a given number objects that can be selected from a number of objects
PERMUTATIONA - number of permutations with replacement
STIRLING1 - stirling number of the first kind
STIRLING2 - stirling number of the second kind
Misc Functions
XLDB_STATISTICS_VERSION - version information for the XLeratorDB/statistics module
SAMPLE DATA - sample data for certain XLeratorDB/statistics functions documentation
ALL FUNCTIONS (alpahbetical)
AVEDEV - average deviation
AVEDEV_q - average deviation
AVERAGE - average (arithmetic mean) of a dataset
AVERAGE_q - average (arithmetic mean) of a dataset
BETA - beta function
BETA_DIST - probability density function or cumulative distribution function of a beta distribution for x with shape parameters a and ß
BETADIST - beta cumulative probability density function
BETAI - incomplete beta function
BETAINV - quartiles of the beta cumulative distribution function
BETAPDF - probability density function for the beta distribution
BICO - binomial coefficient
BINOM_DIST_RANGE - probability of a trial result using a binomial distribution
BINOMDIST - binomial distribution
BINOMINV - value of number of success in the binomial distribution given the cumulative distribution function
BIVAR - bivariate normal probabilities
CAUCHY - probability density function or the lower cumulative distribution function of the Cauchy distribution
CAUCHYINV - inverse lower cumulative distribution of the Cauchy distribution
CHI2NC - lower cumulative distribution function of the non-central chi-square distribution
CHI2NCINV - inverse of the lower cumulative distribution function of the non-central chi-square distribution
CHIDIST - one-tailed probability of the chi-square distribution
CHIINV - inverse of the one-tailed probability of the chi-square distribution
CHISQ - chi-square (χ2) statistic
CHISQ_DIST - probability density or the lower cumulative probability of a chi-squared distribution for x and a number of degrees of freedom
CHISQ_DIST_RT - upper distribution of a chi-squared distribution for x and a number of degrees of freedom
CHISQ_INV - inverse of the left-tailed probability of a chi-squared distribution
CHISQ_INV_RT - inverse of the right-tailed probability of a chi-squared distribution
CHISQ_q - chi-square (χ2) statistic
CHISQ2 - chi-square (χ2) statistic
CHISQ2_q - chi-square (χ2) statistic
CHISQN - chi-square (χ2) statistic for data in third-normal form
CHISQN_q - chi-square (χ2) statistic for data in third-normal form
CHISQN2 - chi-square (χ2) statistic for data in third-normal form
CHISQN2_q - chi-square (χ2) statistic for data in third-normal form
CHISQPDF - probability density function of the chi square distribution
CHITEST - Pearson chi-square test for independence
CHITEST_q - Pearson chi-square test for independence
CHITEST2 - Pearson chi-square test for independence
CHITEST2_q - Pearson chi-square test for independence
CHITESTN - Pearson chi-square test for independence on data in third-normal form
CHITESTN_q - Pearson chi-square test for independence on data in third-normal form
CHITESTN2 - Pearson chi-square test for independence on data in third-normal form
CHITESTN2_q - Pearson chi-square test for independence on data in third-normal form
CONFIDENCE - value that you can use to construct a confidence interval for a population mean
CONFIDENCE_NORM - confidence interval for a population mean
CONFIDENCE_T - confidence interval when you don't know the population standard deviation and are using the sample standard deviation instead
CORREL - correlation coefficient between two datasets
CORREL_q - correlation coefficient between two datasets
COUNT - count of numeric rows in a dataset
COUNT_q - count of numeric rows in a dataset
COVAR - covariance
COVAR_q - covariance
COVARIANCE_P - population covariance
COVARIANCE_S - sample covariance
CRITBINOM - smallest value for the cumulative binomial distribution that is greater than or equal to a criterion value
DEVSQ - deviation squared
DEVSQ_q - deviation squared
DIGAMMA - digamma(z), the logarithmic derivative of the gamma function
EXPDIST - probability density function or the upper cumulative distribution function of the Exponential distribution
EXPINV - inverse of the cumulative distribution function of the exponential distribution
EXPONDIST - exponential distribution that is equivalent to the function used in EXCEL
EXPPRED - predicted value for a dependent variable using the coeffiecients from a previously run mutlivariate exponential regression
F_DIST - probability density or the lower cumulative probability of an F-distribution for x and degrees of freedom for 2 independent random variables
F_DIST_RT - upper cumulative probability of an F-distribution for x and degrees of freedom for 2 independent random variables
F_INV - inverse of the F lower probability distribution
F_INV_RT - inverse of the F upper probability distribution
FACTLN - natural logarithm of a factorial
FACTORIALPOWER - rising or falling factorials
FDIST - F probability distribution
FINV - inverse of the F probability distribution
FISHER - Fisher transformation at x
FISHERINV - inverse of the Fisher transformation
FORECAST - future value by using existing values
FORECAST_q - future value by using existing values
FPDF - probability density function of the F distribution
FTEST - result of an F-test
FTEST_q - result of an F-test
GAMMA - invoke the (complete) gamma function Γ(x)
GAMMADIST - gamma distribution
GAMMAINC - incomplete gamma function
GAMMAINV - inverse of the cumulative gamma distribution
GAMMALN - natural logarithm of the (complete) gamma function Γ(x)
GAMMAP - regularized gamma function P(a
GAMMAQ - regularized gamma function Q(a
GEOMEAN - geometric mean of a dataset
GEOMEAN_q - geometric mean of a dataset
GEOMETRIC - probability mass function of the geometric distribution
GEOMETRICINV - inverse of the cumulative distribution function of the geometric distribution
GEOMETRICP - cumulative distribution function of the geometric distribution
GROWTH - predicted exponential growth by using existing data
GROWTH_q - predicted exponential growth by using existing data
GROWTHMX - values along an exponential trend
GROWTHMX_q - values along an exponential trend
HARMEAN - harmonic mean of a dataset
HARMEAN_q - harmonic mean of a dataset
HYPGEOM_DIST - pmf or the cdf of the hypergeometric distribution
HYPGEOM_INV - quantiles of the hypergeometric distribution
HYPGEOMDIST - hypergeometric distribution
HYPGEOMDISTP - lower cumulative distribution of the hypergeometric function
HYPGEOMDISTPINV - inverse of the cumulative distribution function of the hypergeometric distribution
HYPGEOMDISTQ - upper cumulative distribution of the hypergeometric function
ICC - intra-class coefficient
ICC_TV - intra-class coefficient
INTERCEPT - point at which a line will intersect the y-axis by using existing x-values and y-values
INTERCEPT_q - point at which a line will intersect the y-axis by using existing x-values and y-values
INVGAMMAP - inverse of the incomplete gamma function P(a
IPR - inter-percentile range
IQR - inter-quartile range
KAPPA_COHEN - Cohen’s kappa (κ) or weighted kappa as an index of inter-rater agreement between 2 raters
KAPPA_COHEN_TV - Cohen’s kappa (κ) or weighted kappa as an index of inter-rater agreement between 2 raters
KAPPA_FLEISS - Fleiss’ kappa (κ) as an index of inter-rater agreement between m raters on categorical data
KAPPA_FLEISS_TV - Fleiss’ kappa (κ) as an index of inter-rater agreement between m raters on categorical data
KENDALLT - Kendall’s tau (τ)
KENDALLT_TV - Kendall’s tau (τ)
KENDALLW - Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data
KENDALLW_TV - Kendall’s coefficient of concordance (w) as an index of inter-rater reliability for ordinal data
KMEANS - k-means clustering in N-dimensions
KSccdf - complementary cumulative probability P[Dn >= x] of the Kolmogorov-Smirnov distribution with sample size n at x
KScdf - cumulative probability P[Dn >= x] of the Kolmogorov-Smirnov distribution with sample size n at x
KSP - Kolmogorov-Smirnov (KS) cumulative distribution function
KSPINV - inverse of the Kolmogorov-Smirnov (KS) cumulative distribution function
KSQ - complementary Kolmogorov-Smirnov (KS) cumulative distribution function
KSQINV - inverse of the complementary Kolmogorov-Smirnov (KS) cumulative distribution function
KSTEST - compare a sample with a reference probability distribution
KSTEST_q - compare a sample with a reference probability distribution
KSTEST2 - two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples
KSTEST2_q - two-sample Kolmogorov-Smirnov test to compare the distributions of the values in two samples
KURT - kurtosis of a dataset
KURT_q - kurtosis of a dataset
KURTOSIS_P - population kurtosis
KURTOSIS_S - sample kurtosis
LAPLACE - probability density function or the lower cumulative distribution function of the Laplace distribution
LAPLACEINV - inverse lower cumulative distribution of the Laplace distribution
LARGE - kth largest value in a dataset
LARGE_q - kth largest value in a dataset
LCHOOSE - natural logarithm of the binomial coefficient
LINEST - ordinary least squares (OLS) solution for a series of x- and y-values
LINEST_q - ordinary least squares (OLS) solution for a series of x- and y-values
LMPRED - predicted value for a dependent variable using the coefficients from a previously run multivariate linear regression
LOGEST - exponential curve that best fits a series of x- and y-values
LOGEST_q - exponential curve that best fits a series of x- and y-values
LOGINV - inverse of the lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation
LOGISTIC - probability density function or the lower cumulative distribution function of the logistic distribution
LOGISTICINV - inverse lower cumulative distribution of the logistic distribution
LOGIT - binary logistic regression coefficients from a table of x-values (the independent variables) and dichotomous y-values (the dependent variable)
LOGITPRED - probability that Y = 1 given a set of coefficients from a logistic regression and a set of x-values
LOGITPROB - probability that Y = 1 given a set of coefficients from a logistic regression and a set of x-values
LOGITSUM - binary logistic regression coefficients from a table of grouped x-values (the independent variables) with counts of the successes and failures for each group
LOGNORM_DIST - probability density function or the cumulative distributive function of the normal distribution of x
LOGNORM_INV - inverse of the lognormal distribution function of x
LOGNORMDIST - lognormal cumulative distribution function of x where ln(x) is normally distributed within the parameters mean and standard deviation
LOGNORMPDF - probability density function of the lognormal distribution
LPERMUT - natural logarithm of the PERMUT function
LPERMUTA - natural logarithm of the PERMUTATIONA function
MCNEMAR - McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table
MCNEMAR_TV - McNemar’s chi-squared test for symmetry of rows and columns in a two-dimensional contingency table
MEDIAN - median value in a dataset
MEDIAN_q - median value in a dataset
MODE - mode (most frequent value) of a dataset
MODE_q - mode (most frequent value) of a dataset
MULTINOM - to calculate the probability distribution of the outcomes of a multinomial experiment
NCFCDF - lower cumulative distribution function of the non-central F distribution
NCFINV - inverse of the lower cumulative distribution function of the non-central F distribution
NCFPDF - probability density function of the non-central F distribution
NCHISQPDF - probability density function of the non-central chi square distribution
NCTCDF - lower cumulative distribution function of the non-central T distribution
NCTINV - inverse of the lower cumulative distribution function of the non-central T distribution
NCTPDF - probability density function of the non-central T distribution
NEGBINOM_DIST - probability mass function or the cumulative distributive function of the negative binomial distribution
NEGBINOMDIST - negative binomial distribution
NEGBINOMDISTP - cumulative distribution function of the negative binomial distribution
NEGBINOMINV - smallest value of x such that NEGBINOMDISTP(x
NEGHYPGEOM_DIST - probability mass function or the cumulative distributive function of the negative hypergeometric distribution
NEGHYPGEOM_INV - quantiles of the negative hypergeometric distribution
NORM_S_DIST - probability density function or the lower cumulative distribution function of the standard normal distribution in SQL Server
NORMAL - probability density function for the standard normal distribution
NORMDIST - normal distribution for the specified mean and standard deviation
NORMINV - inverse of the normal cumulative distribution function (cdf)
NORMSDIST - standard normal cumulative distribution function
NORMSINV - inverse of the standard normal distribution in SQL Server
PEARSON - Pearson product-moment coefficient between two datasets
PEARSON_q - Pearson product-moment coefficient between two datasets
PERCENTILE - percentile
PERCENTILE_EXC - percentile
PERCENTILE_q - percentile
PERCENTILES - any number of percentiles from a set of values
PERCENTRANK - rank of a value in a dataset as a percentage of the dataset
PERCENTRANK_EXC - rank of a value in a dataset
PERCENTRANK_q - rank of a value in a dataset as a percentage of the dataset
PERCENTRANKS - relative standing of values within a dataset
PERMUT - number of permutations for a given number objects that can be selected from a number of objects
PERMUTATIONA - number of permutations with replacement
POISSON - Poisson distribution
POISSON_DIST - probability mass function or the lower cumulative probability of a Poisson distribution for a given number of events occurring in a fixed interval given the rate
POISSONINV - inverse of the cumulative distribution function of the Poisson distribution
PROB - probability that values in a range are between two limits
PROB_q - probability that values in a range are between two limits
PSIGNRANK - distribution function of the Wilcoxon Signed Rank statistic
QUARTILE - specified quartile of a dataset
QUARTILE_EXC - specified quartile of a dataset
QUARTILE_q - specified quartile of as dataset
RANGE - difference between the minimum and maximum values in a dataset
RANK - rank of a number in a list of numbers
RANK_AVG - ranks for a collection of x- and y-values
RANK_q - rank of a number in a list of numbers
RANKAVG - average rank of a number in a list of numbers
ROCTable - calculation of the area under the ROC curve
RSQ - Pearson product moment correlation coefficient through data points in known-y’s and known-x’s
RSQ_q - Pearson product moment correlation coefficient through data points in known-y’s and known-x’s
SFTEST - Shapiro-Francia test for the composite hypothesis of normality
SFTEST_q - Shapiro-Francia test for the composite hypothesis of normality
SKEW - degree of asymmetry of a distribution
SKEW_q - degree of asymmetry of a distribution
SKEWNESS_P - skewness for an entire population
SKEWNESS_S - sample skewness
SLOPE - slope of the linear regression through the data points in the known x-values and y-values
SLOPE_q - slope of the linear regression through the data points in the known x-values and y-values
SMALL - kth smallest value in a dataset
SMALL_q - kth smallest value in a dataset
SPEARMAN - Spearman’s rank correlation coefficient (ρ)
SPEARMAN_TV - Spearman’s rank correlation coefficient (ρ)
STANDARDIZE - normalized value from a distribution characterized by a mean and standard deviation
STDEV - estimated standard deviation based on a sample
STDEV_P - standard deviation for an entire population
STDEV_q - estimated standard deviation based on a sample
STDEV_S - estimated standard deviation based on a sample
STDEVP - standard deviation for an entire population
STDEVP_q - standard deviation for an entire population
STEYX - standard error of the predicted y-value for each x in a regression
STEYX_q - standard error of the predicted y-value for each x in a regression
STIRLING1 - stirling number of the first kind
STIRLING2 - stirling number of the second kind
STUDENTST - Student’s t-distribution
SWTEST - Shapiro and Wilk’s W statistic and its p-value
SWTEST_q - Shapiro and Wilk’s W statistic and its p-value
T_DIST - probability density function and the left-tailed cumulative probability distribution of Student's t-distribution
T_DIST_2T - two-tailed cumulative probability distribution of Student's t-distribution
T_DIST_RT - right-tailed cumulative probability distribution of Student's t-distribution
T_INV - inverse of the left-tailed cumulative probability distribution of Student's t-distribution
T_INV_2T - inverse of the two-tailed distribution of Student's t-distribution
TDIST - probability for the Student t-distribution where a numeric value (x) is a calculated value of t for which the probability is to be computed
TINV - t-value of the Student's t-distribution as a function of the probability and the degrees of freedom
TPDF - probability density function of the T distribution
TREND - values along a linear trend
TREND_q - values along a linear trend
TRENDMX - values along a linear trend
TRENDMX_q - values along a linear trend
TRIGAMMA - trigamma(z) the second derviative of the natural log of the gamma function
TRIMMEAN - mean of the interior of a dataset
TRIMMEAN_q - mean of the interior of a dataset
TTEST - probability associated with Student’s t-test
TTEST_INDEP - t-test on data in two samples assuming equal variance
TTEST_INDEPU - t-test on data in two samples assuming unequal variance
TTEST_PAIRED - t-test on data in two samples assuming unequal variance
TTEST_q - probability associated with Student’s t-test
UNIFORM - probability density function or the lower cumulative distribution function of the uniform distribution
UNIFORMINV - inverse of the lower cumulative distribution of the uniform distribution
VAR - estimate variance based on a sample
VAR_P - variance for an entire population
VAR_q - estimate variance based on a sample
VAR_S - estimate variance based on a sample
VARP - variance for an entire population
VARP_q - population variance
VIF - R-squared
WEIBULL - Weibull distribution
WEIBULLINV - inverse of the cumulative distribution function of the Weibull distribution
WLS - Weighted least squares solution for a series of x- and y-values and their associated weights
WLS_q - Weighted least squares solution for a series of x- and y-values and their associated weights
WMPSR - Wilcoxon matched-pair signed-rank test
WMPSR_TV - Wilcoxon matched-pair signed-rank test
XLDB_STATISTICS_VERSION - version information for the XLeratorDB/statistics module
ZTEST - one-tailed probability of a Z-test
ZTEST_q - one-tailed probability of a Z-test
BINOM_DIST
View Topic History