Overview

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

Functions	Description
CORR	Calculates the Pearson correlation coefficient between two sets of number pairs
COVAR_POP	Calculates the population covariance between two sets of number pairs
COVAR_SAMP	Calculates the sample covariance between two sets of number pairs
REGR_AVGX	Calculates the average of the independent variable (sum(X)/N)
REGR_AVGY	Calculates the average of the dependent variable (sum(Y)/N)
REGR_COUNT	Calculates the number of input rows in which both expressions are non-null
REGR_INTERCEPT	Calculates the y-intercept of the univariate linear regression line for a group of data points
REGR_R2	Calculates the coefficient of determination (R2) for a linear regression model
REGR_SLOPE	Calculates slope of the least-squares-fit linear equation determined by the (X, Y) pairs
REGR_SXX	Calculates the sum(X2) - sum(X)2/N (“sum of squares” of the independent variable)
REGR_SXY	Calculates the sum(X*Y) - sum(X) * sum(Y)/N (“sum of products” of independent times dependent variable)
REGR_SYY	Calculates the sum(Y2) - sum(Y)2/N (“sum of squares” of the dependent variable)
STDDEV	Calculates the sample standard deviation of a set of numeric values
STDDEV_POP	Calculates the population standard deviation of the input values
STDDEV_SAMP	Calculates the sample standard deviation of the input values
VARIANCE	Calculates the the sample variance of a set of numeric values.
VAR_POP	Calculates the population variance of the input values (square of the population standard deviation)
VAR_SAMP	Calculates the sample variance of the input values (square of the sample standard deviation)