Login     Register

        Contact Us     Search

New Statistics Package

Sep 6

Written by: Charles Flock
9/6/2010 3:24 PM  RssIcon

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

 

Tags:
Categories:
Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service