Oracle PLSQL Tutorial Statistical Functions 10 codes

1 Avg

2 Corr calculates the correlation coefficient of a set of paired observations

3 Corr_K calculates a rank correlation

4 Corr_S calculates a rank correlation

5 COVAR_POP(expr1, expr2) returns a population covariance between expr1 and expr2

6 COVAR_SAMP(expr1, expr2) returns a sample covariance between expr1 and expr2

7 Cume_Dist calculates the cumulative probability of a value for a given set of observations

8 For significance level of one-sided test

9 For significance level of two-sided test

10 MEDIAN(expr1) returns the median from a group of numbers