Included in Oracle 10g Database is
a compelling array of statistical functions. These include
descriptive statistics, hypothesis testing, correlations analysis,
test for distribution fit, cross tabs with Chi-square statistics,
analysis of variance (ANOVA), and Pareto analysis. Oracle
continues to expand its set of statistical functions for use
far beyond basic querying. In addition to embedded statistical
functions, Oracle Data Mining and Oracle OLAP (both Options
to the Database) make the database a sophisticated, scalable
and secure analytical engine.
The statistical functions in the database
can be used in a variety of ways, for example, users can call
Oracle's DBMS_STAT_FUNCS to obtain basic count, mean, max,
min and standard deviation information for their dataset;
or users can determine the strength of relationships using
hypothesis testing statistics such as a t-test, f-test or
ANOVA. Users are able to not only complete a wide range of
statistics, but also include these results in more advanced
SQL queries and analytical pipelines. Features include:
- Descriptive statistics
- Hypothesis testing
- Correlations analysis (parametric and nonparametric)
- Ranking functions
- Cross Tabulations with Chi-square statistics
- Linear regression
- ANOVA
- Test Distribution fit
- Window Aggregate functions
- Statistical Aggregates
- Pareto analysis
- LAG/LEAD functions
- Reporting aggregate functions
Bookmark
