Login     Register

        Contact Us     Search

XLeratorDB - Statistics Package

  Realize the full power of SQL Server with in-database analytics. XLeratorDB 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 - Documentation

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.



"Any company currently using the Excel kernel within its applications to handle complex calculations will find XLeratorDB most beneficial, It’s an overall great product – flexible, yet reliable."

Chet Cotter
Director of Financial Systems
Newland Communities, LLC

"This is a very data processing intensive system that would not be possible without the use of XLeratorDB and SQL Server. XLeratorDB has made us a 15X return and it offers 500 times the processing that Excel is capable of."

Kenneth Jones
Founder and Managing Partner
Fusion Ventures

“Before XLeratorDB, there was no easy-to-use, built in solution for XIRR calculation in SQL Server, XLeratorDB is the first product to bridge that gap and streamlines the process for us.

Munish Kumar
Investment Analyst
The Sentient Group

"We’ve saved as much as 20-30 percent of total development time thanks to XLeratorDB, With XLeratorDB, we can give our clients the means to automate many of their underwriting decisions, lowering their costs and reducing errors."

Jason Daniels
Chief Operating Officer
Verde International

Copyright 2008-2013 WestClinTech LLC         Privacy Policy        Terms of Service