Thursday, March 11, 2010 Register
Home

XLeratorDB/statistics

Use XLeratorDB/statistics for a wide variety of statistical and probality calculations. The feature-rich XLeratorDB statistics function library lets you include calculations in any T-SQL statement including SELECT, INSERT, UPDATE, DELETE, CREATE VIEW as well as in CTEs, stored procedures, user-defined functions, and computed columns.

XLeratorDB/statistics requires Microsoft  SQL Server®  2005 or later (which must be purchased separately). XleratorDB/statistics installs in minutes and can be used immediately after installation. Anyone familiar with the functions in Microsoft Excel® will immediately feel comfortable with XLeratorDB/statistics.

Function Reference - Statistical Functions
AVEDEV average of the absolute deviations
AVEDEV_q average of the absolute deviations
AVERAGE average (arithmetic mean)
AVERAGE_q average (arithmetic mean)
CHISQ Chi-square statistic
CHISQ_q Chi-square statistic
CHISQN Chi-square statistic on normalized tables
CHISQN_q Chi-square statistic on normalized tables
CHITEST Pearson chi-square test for independence
CHITEST_q Pearson chi-square test for independence
CHITESTN Pearson chi-square test for independence on normalized tables
CHITESTN_q Pearson chi-square test for independence on normalized tables
CORREL correlation coefficient
CORREL_q correlation coefficient
COUNT Number of rows in a table that contain numbers
COUNT_q Number of rows in a table that contain numbers
COVAR Covariance
COVAR_q Covariance
DEVSQ sum of the squares of deviations
DEVSQ_q sum of the squares of deviations
FORECAST calculate a future value
FORECAST_q calculate a future value
FTEST determine whether two samples have different variances
FTEST_q determine whether two samples have different variances
GEOMEAN geometric mean for a dataset containing positive numbers
GEOMEAN_q geometric mean for a dataset containing positive numbers
GROWTH predicted exponential growth
GROWTH_q predicted exponential growth
HARMEAN harmonic mean of a dataset containing positive numbers
HARMEAN_q harmonic mean of a dataset containing positive numbers
INTERCEPT calculate the point at which a line will intersect the y-axis
INTERCEPT_q calculate the point at which a line will intersect the y-axis
KURT calculate the kurtosis of a dataset
KURT_q calculate the kurtosis of a dataset
LARGE calculate the kth largest value in a dataset
LARGE_q calculate the kth largest value in a dataset
MEDIAN calculate the median value in a dataset
MEDIAN_q calculate the median value in a dataset
MODE calculate the most common value in a dataset
MODE_q calculate the most common value in a dataset
PEARSON Pearson correlation coefficient 
PEARSON_q Pearson correlation coefficient 
PERCENTILE calculate the kth percentile of value in a dataset
PERCENTILE_q calculate the kth percentile of value in a dataset
PERCENTRANK calculate rank of a value in a dataset as a percentage of the dataset
PERCENTRANK_q calculate rank of a value in a dataset as a percentage of the dataset
PROB calculate probability that values in a range are between two limits
PROB_q calculate probability that values in a range are between two limits
QUARTILE calculate the quartile of a dataset
QUARTILE_q calculate the quartile of a dataset
RANK calculate the rank of a number in a list of numbers
RANK_q calculate the rank of a number in a list of numbers
RSQ Pearson product moment correlation coefficient
RSQ_q Pearson product moment correlation coefficient
SKEW the degree of asymmetry of a distribution
SKEW_q the degree of asymmetry of a distribution
SLOPE slope of linear regression
SLOPE_q slope of linear regression
SMALL calculate the kth smallest value in a dataset
SMALL_q calculate the kth smallest value in a dataset
STDEV standard deviation
STDEV_q standard deviation
STDEVP standard deviation for an entire population
STDEVP_q standard deviation for an entire population
STEYX standard error
STEYX_q standard error
TREND calculate the values along a linear trend
TREND_q calculate the values along a linear trend
TRIMMEAN calculate the mean of the interior of a dataset
TRIMMEAN_q calculate the mean of the interior of a dataset
TTEST calculate the probability associated with Student’s t-test
TTEST_q calculate the probability associated with Student’s t-test
VAR variance
VAR_q variance
VARP variance for an entire population
VARP_q variance for an entire population
ZTEST calculate the one-tailed probability of a Z-test
ZTEST_q calculate the one-tailed probability of a Z-test

 

 

Function Reference - Probability Functions
BETA beta
BETADIST beta cumulative probability density
BETAI incomplete beta
BETAINV inverse of the beta cumulative probability density
BICO binomial coefficient
BINOMDIST binomial distribution
CHIDIST chi-squared distribution
CHIINV inverse of the chi-squared distribution
CONFIDENCE confidence interval
CRITBINOM criterion value for the cumulative binomial distribution
EXPONDIST exponential distribution
FACTLN natural logarithm of a factorial
FDIST F probability distribution
FINV inverse of the F probability distribution
FISHER Fisher transformation
FISHERINV inverse of the Fisher transformation
GAMMA complete gamma function
GAMMADIST gamma distribution
GAMMAINC incomplete gamma
GAMMAINV inverse  of the cumulative gamma distribution
GAMMALN natural logarithm of the complete gamma
GAMMAP regularized gamma function P(a, x)
GAMMAQ regularized gamma function Q(a, x)
HYPGEOMDIST hypergeometric distribution
INVGAMMAP inverse of the incomplete gamma function P(a,x)
LOGINV inverse of the lognormal cumulative distribution
LOGNORMDIST lognormal cumulative distribution
NEGBINOMDIST negative binomial distribution
NORMDIST normal distribution
NORMINV inverse of the normal cumulative distribution
NORMSDIST standard normal cumulative distribution
NORMSINV inverse of the standard normal cumulative distribution
PERMUT permutations
POISSON Poisson distribution
STANDARDIZE normalized value from a distribution
TDIST probability for the Student t-distribution
TINV t-value of the Student's t-distribution
WEIBULL Weibull distribution

 

 

Function Reference - Version Information
XLDB_STATISTICS_VERSION Version Information

 

 

XLDB Statistics Sample Data



 |  View Topic History  |
Privacy StatementTerms Of UseCopyright 2010 WestClinTech LLC

BorderBoxedGrayBoxedGreenBlue Small width layoutMedium width layoutMaximum width layoutMaximum textMedium textSmall textBack Top!