Login Register

postgres.aggregates.RegrSXY

class RegrSXY(y, x) [source]

Returns sum(x*y) - sum(x) * sum(y)/N (“sum of products” of independent times dependent variable) as a float, or None if there aren’t any matching rows.

Links:

https://docs.djangoproject.com/en/1.10/ref/contrib/postgres/aggregates/#django.contrib.postgres.aggregates.RegrSXY

doc_Django

2025-01-10 15:47:30

Comments

Leave a Comment

Please login to continue.

Popular Articles

postgres.aggregates.BitAnd class BitAnd(expression, **extra) [source] Returns an int of the bitwise AND of all non-null input values, or None if all values are null.

postgres.aggregates.CovarPop 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 optio

postgres.aggregates.BoolOr 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

postgres.aggregates.RegrAvgY 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.

postgres.aggregates.RegrSXX 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