Login     Register

        Contact Us     Search

Menu

XLeratorDB - Statistics Functions for SQL Server

 

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.

 


 

Additional Information

Articles & Code Examples

Testimonials

Copyright 2008-2024 Westclintech LLC         Privacy Policy        Terms of Service