Data Science & Machine Learning

Hello - We are considering moving some life-sciences research data to an Oracle database, including moving the researchers' reports off of Excel. I am currently trying to duplicate one of their reports to demonstrate that their reports can be done in Oracle.

The issue is: I can't find an Oracle statistics function to duplicate what I am told is a simple chi-square goodness-of-fit test, where we provide a set of qualitative values, a set of observed values, and a set of expected values. The scientists currently do this test using the Excel function: CHITEST(<some range of observed values>,<some range of expected values>), which "returns the value from the chi-squared (χ2) distribution for the statistic and the appropriate degrees of freedom." I can find free-ware modules outside of Oracle to do this, but not within Oracle.

It was suggested by an Oracle person that I look at the STATS_CROSSTAB Oracle function. Unfortunately, that function appears to not be valid for our application. It seems to want only two sets of data: ‘qualitative’ data (such as gender) for the first parameter, and quantitative data for the second parameter.

I would like to move the researchers to some database, preferably Oracle, so any assistance is greatly appreciated.