class RegrAvgY(y, x) [source] Returns the average of the dependent variable (sum(y)/N) as a float, or None if there aren’t any matching rows.

class RegrAvgX(y, x) [source] Returns the average of the independent variable (sum(x)/N) as a float, or None if there aren’t any matching rows.

class RegrCount(y, x) [source] Returns an int of the number of input rows in which both expressions are not null.

class RegrSXX(y, x) [source] Returns sum(x^2) - sum(x)^2/N (“sum of squares” of the independent variable) as a float, or None if there aren’t any matching rows.

class RegrSlope(y, x) [source] Returns the slope of the least-squares-fit linear equation determined by the (x, y) pairs as a float, or None if there aren’t any matching rows.

class RegrIntercept(y, x) [source] Returns the y-intercept of the least-squares-fit linear equation determined by the (x, y) pairs as a float, or None if there aren’t any matching rows.

class RegrR2(y, x) [source] Returns the square of the correlation coefficient as a float, or None if there aren’t any matching rows.

sample By default CovarPop returns the general population covariance. However, if sample=True, the return value will be the sample population covariance.

class BoolOr(expression, **extra) [source] Returns True if at least one input value is true, None if all values are null or if there are no values, otherwise False.

class BoolAnd(expression, **extra) [source] Returns True, if all input values are true, None if all values are null or if there are no values, otherwise False .