Statistical Analysis with Oracle
The ANSI SQL offers analytical capabilities useful for advanced data analysis like linear regression and correlation. Beyond supporting the standard SQL functions Oracle provides additional vendor-specific functions that enable to perform statistical analysis such as descriptive statistics and hypothesis testing. In the attached presentation we will put into practice the main statistical built-in functions from Oracle 10g release 2. We will also show an example of a user-defined function.