Aggregate functions for statistics are typically used for statistical analysis. Oxla supports the following functions:

FunctionsDescription
CORRCalculates the Pearson correlation coefficient between two sets of number pairs
COVAR_POPCalculates the population covariance between two sets of number pairs
COVAR_SAMPCalculates the sample covariance between two sets of number pairs
REGR_AVGXCalculates the average of the independent variable (sum(X)/N)
REGR_AVGYCalculates the average of the dependent variable (sum(Y)/N)
REGR_COUNTCalculates the number of input rows in which both expressions are non-null
REGR_INTERCEPTCalculates the y-intercept of the univariate linear regression line for a group of data points
REGR_R2Calculates the coefficient of determination (R2) for a linear regression model
REGR_SLOPECalculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs
REGR_SXXCalculates the sum(X2) - sum(X)2/N (“sum of squares” of the independent variable)
REGR_SXYCalculates the sum(X*Y) - sum(X) * sum(Y)/N (“sum of products” of independent times dependent variable)
REGR_SYYCalculates the sum(Y2) - sum(Y)2/N (“sum of squares” of the dependent variable)
STDDEVCalculates the sample standard deviation of a set of numeric values
STDDEV_POPCalculates the population standard deviation of the input values
STDDEV_SAMPCalculates the sample standard deviation of the input values
VARIANCECalculates the the sample variance of a set of numeric values.
VAR_POPCalculates the population variance of the input values (square of the population standard deviation)
VAR_SAMPCalculates the sample variance of the input values (square of the sample standard deviation)
OverviewCORR