New Statistics Package
Sep
6
Written by:
Charles Flock
9/6/2010 3:24 PM
Information about the release of XLeratorDB/statistics version 1.06
We are pleased to announce the availability of XLeratorDB/statistics version 1.06, which contains 30 new statistical functions that you can add to SQL Server and which can’t be found in EXCEL. We benchmarked these functions against the R programming language and, like all XLeratorDB functions, they can be used in a variety of T-SQL statements, inside stored procedures, embedded in your own functions, in VIEWS; in any place where user-defined functions are permitted.
These function are analogous to the functions found in many statistical packages like R, MATLAB, SPSS, SAS, Mathematica, etc. In fact, it seems kind of odd that they are not in EXCEL (not even in Excel 2010). It seemed sensible to us that if you store data in your SQL Server data base then it would be far easier to use the functions where the data resides rather than invoking another package and connecting to the database (and possible running over the network and slowing things down).
These functions are available to all existing XLeratorDB/statistics users for free. Simply login to your account and download the latest version. Please make sure that you uninstall the old version before installing the new version. Of course, even though we have added all the new functionality, the price remains the same and is a huge bargain compared to some of these other packages (though we have to confess that R is free). These new functions are also available in XLeratorDB/Developer and XleratorDB/Express.
Here is a list of the functions with a brief description and the equivalent function name in R. For more information about the function, just go to the documentation section on the site.
|
XLeratorDB
Function Name
|
Description
|
R Function
Name
|
|
|
pdf of the beta distribution
|
pbeta
|
|
|
inverse (quantile) of the binomial distribution
|
qbinom
|
|
|
cdf or pdf of the Cauchy distribution
|
dcauchy
pcauchy
|
|
|
inverse (quantile) of the Cauchy distribution
|
qcauchy
|
|
|
cdf of the non-central chi-square distribution
|
dchisq
|
|
|
inverse (quantile) of the non-central chi-square distribution
|
qchisq
|
|
|
cdf or pdf of the exponential distribution
|
dexp
pexp
|
|
|
inverse (quantile) of the exponential distribution
|
qexp
|
|
|
pdf of the F distribution
|
pf
|
|
|
cdf or pdf of the geometric distribution
|
dgeom
pgeom
|
|
|
inverse (quantile) of the geometric distribution
|
qgeom
|
|
|
inverse of the pdf of the hypergeometric distribution
|
qhyper
|
|
|
cdf or pdf of the Laplace distribution
|
dlaplace
plaplace
|
|
|
inverse (quantile) of the Laplace distribution
|
qlaplace
|
|
|
cdf or pdf of the logistic distribution
|
dlogis
plogis
|
|
|
inverse (quantile) of the logistic distribution
|
qlogis
|
|
|
pdf of the lognormal distribution
|
plnorm
|
|
|
cdf of the non-central F distribution
|
df
|
|
|
inverse (quantile) of the non-central F distribution
|
qf
|
|
|
pdf of the non-central F distribution
|
pf
|
|
|
pdf of the non-central chi-square distribution
|
pchisq
|
|
|
cdf of the non-central T distribution
|
dt
|
|
|
inverse (quantile) of the non-central T distribution
|
qt
|
|
|
pdf of the non-central T distribution
|
pt
|
|
|
pdf of the negative binomial distribution
|
pnbinom
|
|
|
inverse (quantile) of the negative binomial distribution
|
qnbinom
|
|
|
inverse (quantile) of the Poisson distribution
|
qpois
|
|
|
cdf or pdf of the uniform distribution
|
dunif
punif
|
|
|
inverse (quantile) of the uniform distribution
|
qunif
|
|
|
inverse (quantile) of the Weibull distribution
|
qweibull
|