Are there any plans to extend the list of statistical tests available in Oracle SQL Developer?
Specifically, I have a dataset in which I have ordinal data and need to do a correlation between two such variables. I need Spearman Rank correlation coefficient. Pearson's correlation coefficient is a workaround, but ordinal data violates the assumptions behind Pearson's test, which requires interval or ratio scaled data.
Additionally, I have done a chi-squared analysis on a 4 x 2 matrix, but the minimum expected value of every cell needs to be 5 to be 100% valid. One of my cells violates this assumption, so I need to perform a Fisher's Exact test.
Neither Spearman Rank nor Fisher's Exact is currently available in the STATS_ functionality. Is this something that can be included as an enhancement request please?
I can export the data and use SPSS, R or Python, but I'd rather keep everything in Oracle.
Many thanks