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 RegrR2(y, x) [source] Returns the square of the correlation coefficient 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 RegrCount(y, x) [source] Returns an int of the number of input rows in which both expressions are not null.

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.

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

class CovarPop(y, x, sample=False) [source] Returns the population covariance as a float, or None if there aren’t any matching rows. Has one optional argument: sample By default CovarPop returns the general population covariance. However, if sample=True, the return value will be the sample population covariance.

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