Linear regression gradient

Supported in: Batch

Returns the slope of the linear regression line for non-null pairs in a group. Returns null if there are insufficient non-null pairs or if the variance of the independent variable is zero.

Expression categories: Aggregate

Declared arguments

• Left: The independent variable.
  Expression<Numeric>
• Right: The dependent variable.
  Expression<Numeric>

Output type: Double

Examples

Example 1: Base case

Argument values:

• Left: left
• Right: right

Given input table:

Outputs: -1.0

---

Example 2: Base case

Argument values:

• Left: left
• Right: right

Given input table:

Outputs: 0.0

---

Example 3: Base case

Argument values:

• Left: left
• Right: right

Given input table:

Outputs: null

---

Example 4: Null case

Argument values:

• Left: left
• Right: right

Given input table:

Outputs: -1.0

---