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
financialoptions
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)
Oneyear nonrecurring license
pricing
SuitePLUS
incl: all Suite packages PLUS
financialoptions
pricing
SuitePLUS (Developer)
requires SQL Server Developer Edition, also incl:
financialoptions
pricing
SuitePLUS (Subscription)
Oneyear nonrecurring license, also incl:
financialoptions
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
financialoptions
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  interpercentile range
IQR  interquartile 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  chisquare (χ2) statistic
CHISQ_q  chisquare (χ2) statistic
CHISQ2  chisquare (χ2) statistic
CHISQ2_q  chisquare (χ2) statistic
CHISQN  chisquare (χ2) statistic for data in thirdnormal form
CHISQN_q  chisquare (χ2) statistic for data in thirdnormal form
CHISQN2  chisquare (χ2) statistic for data in thirdnormal form
CHISQN2_q  chisquare (χ2) statistic for data in thirdnormal form
CHITEST  Pearson chisquare test for independence
CHITEST_q  Pearson chisquare test for independence
CHITEST2  Pearson chisquare test for independence
CHITEST2_q  Pearson chisquare test for independence
CHITESTN  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN_q  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN2  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN2_q  Pearson chisquare test for independence on data in thirdnormal form
FTEST  result of an Ftest
FTEST_q  result of an Ftest
KSTEST  compare a sample with a reference probability distribution
KSTEST_q  compare a sample with a reference probability distribution
KSTEST2  twosample KolmogorovSmirnov test to compare the distributions of the values in two samples
KSTEST2_q  twosample KolmogorovSmirnov test to compare the distributions of the values in two samples
SFTEST  ShapiroFrancia test for the composite hypothesis of normality
SFTEST_q  ShapiroFrancia test for the composite hypothesis of normality
SWTEST  Shapiro and Wilk’s W statistic and its pvalue
SWTEST_q  Shapiro and Wilk’s W statistic and its pvalue
TTEST  probability associated with Student’s ttest
TTEST_q  probability associated with Student’s ttest
TTEST_INDEP  ttest on data in two samples assuming equal variance
TTEST_INDEPU  ttest on data in two samples assuming unequal variance
TTEST_PAIRED  ttest on data in two samples assuming unequal variance
ZTEST  onetailed probability of a Ztest
ZTEST_q  onetailed probability of a Ztest
Correlation and Regression Analysis
Correlations
CORREL  correlation coefficient between two datasets
CORREL_q  correlation coefficient between two datasets
PEARSON  Pearson productmoment coefficient between two datasets
PEARSON_q  Pearson productmoment 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 knowny’s and knownx’s
RSQ_q  Pearson product moment correlation coefficient through data points in knowny’s and knownx’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 yaxis by using existing xvalues and yvalues
INTERCEPT_q  point at which a line will intersect the yaxis by using existing xvalues and yvalues
LINEST  ordinary least squares (OLS) solution for a series of x and yvalues
LINEST_q  ordinary least squares (OLS) solution for a series of x and yvalues
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 yvalues
LOGEST_q  exponential curve that best fits a series of x and yvalues
SLOPE  slope of the linear regression through the data points in the known xvalues and yvalues
SLOPE_q  slope of the linear regression through the data points in the known xvalues and yvalues
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 yvalues and their associated weights
WLS_q  Weighted least squares solution for a series of x and yvalues and their associated weights
Logistic Regressions
LOGIT  binary logistic regression coefficients from a table of xvalues (the independent variables) and dichotomous yvalues (the dependent variable)
LOGITPRED  probability that Y = 1 given a set of coefficients from a logistic regression and a set of xvalues
LOGITPROB  probability that Y = 1 given a set of coefficients from a logistic regression and a set of xvalues
LOGITSUM  binary logistic regression coefficients from a table of grouped xvalues (the independent variables) with counts of the successes and failures for each group
ROCTable  calculation of the area under the ROC curve
VIF  Rsquared
Data Collection
Sampling
KMEANS  kmeans clustering in Ndimensions
STEYX  standard error of the predicted yvalue for each x in a regression
STEYX_q  standard error of the predicted yvalue for each x in a regression
Interobserver Agreement
ICC  intraclass coefficient
ICC_TV  intraclass coefficient
KAPPA_COHEN  Cohen’s kappa (κ) or weighted kappa as an index of interrater agreement between 2 raters
KAPPA_COHEN_TV  Cohen’s kappa (κ) or weighted kappa as an index of interrater agreement between 2 raters
KAPPA_FLEISS  Fleiss’ kappa (κ) as an index of interrater agreement between m raters on categorical data
KAPPA_FLEISS_TV  Fleiss’ kappa (κ) as an index of interrater 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 interrater reliability for ordinal data
KENDALLW_TV  Kendall’s coefficient of concordance (w) as an index of interrater reliability for ordinal data
MCNEMAR  McNemar’s chisquared test for symmetry of rows and columns in a twodimensional contingency table
MCNEMAR_TV  McNemar’s chisquared test for symmetry of rows and columns in a twodimensional contingency table
PSIGNRANK  distribution function of the Wilcoxon Signed Rank statistic
RANK_AVG  ranks for a collection of x and yvalues
SPEARMAN  Spearman’s rank correlation coefficient (ρ)
SPEARMAN_TV  Spearman’s rank correlation coefficient (ρ)
WMPSR  Wilcoxon matchedpair signedrank test
WMPSR_TV  Wilcoxon matchedpair signedrank 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 noncentral chisquare distribution
CHI2NCINV  inverse of the lower cumulative distribution function of the noncentral chisquare distribution
CHIDIST  onetailed probability of the chisquare distribution
CHIINV  inverse of the onetailed probability of the chisquare distribution
CHISQ_DIST  probability density or the lower cumulative probability of a chisquared distribution for x and a number of degrees of freedom
CHISQ_DIST_RT  upper distribution of a chisquared distribution for x and a number of degrees of freedom
CHISQ_INV  inverse of the lefttailed probability of a chisquared distribution
CHISQ_INV_RT  inverse of the righttailed probability of a chisquared 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 Fdistribution for x and degrees of freedom for 2 independent random variables
F_DIST_RT  upper cumulative probability of an Fdistribution 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 KolmogorovSmirnov distribution with sample size n at x
KSccdf  complementary cumulative probability P[Dn >= x] of the KolmogorovSmirnov distribution with sample size n at x
KSP  KolmogorovSmirnov (KS) cumulative distribution function
KSPINV  inverse of the KolmogorovSmirnov (KS) cumulative distribution function
KSQ  complementary KolmogorovSmirnov (KS) cumulative distribution function
KSQINV  inverse of the complementary KolmogorovSmirnov (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 noncentral F distribution
NCFINV  inverse of the lower cumulative distribution function of the noncentral F distribution
NCFPDF  probability density function of the noncentral F distribution
NCHISQPDF  probability density function of the noncentral chi square distribution
NCTCDF  lower cumulative distribution function of the noncentral T distribution
NCTINV  inverse of the lower cumulative distribution function of the noncentral T distribution
NCTPDF  probability density function of the noncentral 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 tdistribution
T_DIST  probability density function and the lefttailed cumulative probability distribution of Student's tdistribution
T_DIST_2T  twotailed cumulative probability distribution of Student's tdistribution
T_DIST_RT  righttailed cumulative probability distribution of Student's tdistribution
TDIST  probability for the Student tdistribution where a numeric value (x) is a calculated value of t for which the probability is to be computed
T_INV  inverse of the lefttailed cumulative probability distribution of Student's tdistribution
T_INV_2T  inverse of the twotailed distribution of Student's tdistribution
TINV  tvalue of the Student's tdistribution 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 noncentral chisquare distribution
CHI2NCINV  inverse of the lower cumulative distribution function of the noncentral chisquare distribution
CHIDIST  onetailed probability of the chisquare distribution
CHIINV  inverse of the onetailed probability of the chisquare distribution
CHISQ  chisquare (χ2) statistic
CHISQ_DIST  probability density or the lower cumulative probability of a chisquared distribution for x and a number of degrees of freedom
CHISQ_DIST_RT  upper distribution of a chisquared distribution for x and a number of degrees of freedom
CHISQ_INV  inverse of the lefttailed probability of a chisquared distribution
CHISQ_INV_RT  inverse of the righttailed probability of a chisquared distribution
CHISQ_q  chisquare (χ2) statistic
CHISQ2  chisquare (χ2) statistic
CHISQ2_q  chisquare (χ2) statistic
CHISQN  chisquare (χ2) statistic for data in thirdnormal form
CHISQN_q  chisquare (χ2) statistic for data in thirdnormal form
CHISQN2  chisquare (χ2) statistic for data in thirdnormal form
CHISQN2_q  chisquare (χ2) statistic for data in thirdnormal form
CHISQPDF  probability density function of the chi square distribution
CHITEST  Pearson chisquare test for independence
CHITEST_q  Pearson chisquare test for independence
CHITEST2  Pearson chisquare test for independence
CHITEST2_q  Pearson chisquare test for independence
CHITESTN  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN_q  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN2  Pearson chisquare test for independence on data in thirdnormal form
CHITESTN2_q  Pearson chisquare test for independence on data in thirdnormal 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 Fdistribution for x and degrees of freedom for 2 independent random variables
F_DIST_RT  upper cumulative probability of an Fdistribution 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 Ftest
FTEST_q  result of an Ftest
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  intraclass coefficient
ICC_TV  intraclass coefficient
INTERCEPT  point at which a line will intersect the yaxis by using existing xvalues and yvalues
INTERCEPT_q  point at which a line will intersect the yaxis by using existing xvalues and yvalues
INVGAMMAP  inverse of the incomplete gamma function P(a
IPR  interpercentile range
IQR  interquartile range
KAPPA_COHEN  Cohen’s kappa (κ) or weighted kappa as an index of interrater agreement between 2 raters
KAPPA_COHEN_TV  Cohen’s kappa (κ) or weighted kappa as an index of interrater agreement between 2 raters
KAPPA_FLEISS  Fleiss’ kappa (κ) as an index of interrater agreement between m raters on categorical data
KAPPA_FLEISS_TV  Fleiss’ kappa (κ) as an index of interrater 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 interrater reliability for ordinal data
KENDALLW_TV  Kendall’s coefficient of concordance (w) as an index of interrater reliability for ordinal data
KMEANS  kmeans clustering in Ndimensions
KSccdf  complementary cumulative probability P[Dn >= x] of the KolmogorovSmirnov distribution with sample size n at x
KScdf  cumulative probability P[Dn >= x] of the KolmogorovSmirnov distribution with sample size n at x
KSP  KolmogorovSmirnov (KS) cumulative distribution function
KSPINV  inverse of the KolmogorovSmirnov (KS) cumulative distribution function
KSQ  complementary KolmogorovSmirnov (KS) cumulative distribution function
KSQINV  inverse of the complementary KolmogorovSmirnov (KS) cumulative distribution function
KSTEST  compare a sample with a reference probability distribution
KSTEST_q  compare a sample with a reference probability distribution
KSTEST2  twosample KolmogorovSmirnov test to compare the distributions of the values in two samples
KSTEST2_q  twosample KolmogorovSmirnov 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 yvalues
LINEST_q  ordinary least squares (OLS) solution for a series of x and yvalues
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 yvalues
LOGEST_q  exponential curve that best fits a series of x and yvalues
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 xvalues (the independent variables) and dichotomous yvalues (the dependent variable)
LOGITPRED  probability that Y = 1 given a set of coefficients from a logistic regression and a set of xvalues
LOGITPROB  probability that Y = 1 given a set of coefficients from a logistic regression and a set of xvalues
LOGITSUM  binary logistic regression coefficients from a table of grouped xvalues (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 chisquared test for symmetry of rows and columns in a twodimensional contingency table
MCNEMAR_TV  McNemar’s chisquared test for symmetry of rows and columns in a twodimensional 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 noncentral F distribution
NCFINV  inverse of the lower cumulative distribution function of the noncentral F distribution
NCFPDF  probability density function of the noncentral F distribution
NCHISQPDF  probability density function of the noncentral chi square distribution
NCTCDF  lower cumulative distribution function of the noncentral T distribution
NCTINV  inverse of the lower cumulative distribution function of the noncentral T distribution
NCTPDF  probability density function of the noncentral 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 productmoment coefficient between two datasets
PEARSON_q  Pearson productmoment 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 yvalues
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 knowny’s and knownx’s
RSQ_q  Pearson product moment correlation coefficient through data points in knowny’s and knownx’s
SFTEST  ShapiroFrancia test for the composite hypothesis of normality
SFTEST_q  ShapiroFrancia 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 xvalues and yvalues
SLOPE_q  slope of the linear regression through the data points in the known xvalues and yvalues
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 yvalue for each x in a regression
STEYX_q  standard error of the predicted yvalue for each x in a regression
STIRLING1  stirling number of the first kind
STIRLING2  stirling number of the second kind
STUDENTST  Student’s tdistribution
SWTEST  Shapiro and Wilk’s W statistic and its pvalue
SWTEST_q  Shapiro and Wilk’s W statistic and its pvalue
T_DIST  probability density function and the lefttailed cumulative probability distribution of Student's tdistribution
T_DIST_2T  twotailed cumulative probability distribution of Student's tdistribution
T_DIST_RT  righttailed cumulative probability distribution of Student's tdistribution
T_INV  inverse of the lefttailed cumulative probability distribution of Student's tdistribution
T_INV_2T  inverse of the twotailed distribution of Student's tdistribution
TDIST  probability for the Student tdistribution where a numeric value (x) is a calculated value of t for which the probability is to be computed
TINV  tvalue of the Student's tdistribution 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 ttest
TTEST_INDEP  ttest on data in two samples assuming equal variance
TTEST_INDEPU  ttest on data in two samples assuming unequal variance
TTEST_PAIRED  ttest on data in two samples assuming unequal variance
TTEST_q  probability associated with Student’s ttest
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  Rsquared
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 yvalues and their associated weights
WLS_q  Weighted least squares solution for a series of x and yvalues and their associated weights
WMPSR  Wilcoxon matchedpair signedrank test
WMPSR_TV  Wilcoxon matchedpair signedrank test
XLDB_STATISTICS_VERSION  version information for the XLeratorDB/statistics module
ZTEST  onetailed probability of a Ztest
ZTEST_q  onetailed probability of a Ztest
History for
COUNT_q
...
Select what version of this topic you want to review.
Topic
Title
Updated By
Updated On
COUNT_q
COUNT_q
Joe Stampf (admin)
10/19/2016 5:08:45 PM

<< Back
