RegressionSlope

📘
This function isn't compatible with all data platform connections. To check if your connection supports it, see Supported data platforms and feature compatibility.

The RegressionSlope function calculates the slope of the linear regression line. This slope can be used to estimate how changes in one variable affects another.

📘
The RegressionSlope function is an aggregate function.
Aggregate functions evaluate one or more rows of data and return a single value.

In a table element, the aggregate is calculated for each grouping. For information on how to add a grouping with an aggregate calculation to a table, see Group columns in a table.

In a table with no groupings, the aggregate is calculated for each row. For information on how to calculate summary statistics across all rows in a table, see Add summary statistics to a table.

To learn more about using aggregate functions, see Building complex formulas with grouped data.

Syntax

RegressionSlope(y, x)

Function arguments


y	The dependent variable, expected to change as a result of changes in `x`.
x	The independent variable.

Notes

The function returns null if the arguments used provide only a single data point.

Example

A table contains an AdSpend column (tracking monthly advertising spend) and a Revenue column (tracking month revenue). You can use the RegressionSlope function to find the linear trend of Revenue as a function of AdSpend.

RegressionSlope([Revenue], [AdSpend])

A positive output means that as monthly advertising spend increases, monthly revenue increases. A negative output that as monthly advertising spend increases, monthly revenue decreases.