RegressionSlope

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.

📘

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

Syntax

RegressionSlope(y, x)

Function arguments

yThe dependent variable, expected to change as a result of changes in x.
xThe 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.