Logo

Product image
XLeratorDB / statistics 2008

Realize the full power of SQL Server with in-database analytics. XLeratorDB / statistics lets you invoke dozens of advanced statistical functions within the database – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

Price: $599.99
Select Options
No. servers
Licensing Opt

You acknowledge that you agree to the End User License Agreement for XLeratorDB /statistics 2008

Realize the full power of SQL Server with in-database analytics. XLeratorDB / statistics lets you invoke dozens of advanced statistical functions within the database – without having to export data to another application, without having to use Reporting Services, and without having to write complicated T-SQL statements or stored procedures.

If you know T-SQL and have used Excel, you will find these familiar functions so easy to use that you could be getting results within minutes after installing them. SQL Server can handle more than a terabyte of critical information; XLeratorDB/statistics gives you the key to unlocking its full value.

XLeratorDB/statistics includes SQL Server functions for:

  • Descriptive statistics including:

    • Continuous data - MODE, GEOMEAN, etc.

    • Dispersion  - PERCENTILE, COVAR, etc.

    • Shape - KURT, SKEW, etc.

  • Statistical inference including:

    • specific tests - CHISQ, TTEST, etc.

  • Correlation and Regression Analysis including:

    • Correlation - CORREL, PROB, etc.

    • Linear regression - SLOPE, TREND, etc.

  • Data collection:

    • Sampling - STEYX

  • Probabilities including:

    • Distributions - BETADIST, LOGINV, etc.

    • Combinatory - BETAI, PERMUT, etc.

  • Interobserver Agreeement including:

    • Cohen's Kappa, Fleiss's Kappa (κ)

    • Intra Class Coefficient - ICC

    • Kendall's tau (τ), Kendall's coefficient of concordance (w)

    • Wilcoxon signed-rank and Wilcoxon matched-pair

    • McNemar, Spearman, etc.

XLeratorDB / statistics adds dozens of new statistical tools (that are precisely matched to Excel) to the native functions built into SQL Server. Plus, there are additional functions for the kind of large dataset analytics you wouldn’t dream of doing in a spreadsheet application.

XLeratorDB lets you apply the same sophisticated tools found in high-end analytic applications, but at a fraction of the cost and network overheads.

System Requirements

XLeratorDB 2008 requires SQL Server 2008 or greater. It does not require Excel, Analysis services, Reporting Services or any other packages.