Table of Contents

LINEAR REGRESSION

Category: Transform / Advanced


Description

This action calculates the simple linear regression for a series of values.


Action settings

SettingDescription
CategorySelect the category column.
SeriesSelect the series column.
ModeSelect the mode. Options: Linear trend (and enter a name for the new column) or Extra/interpolate empty values in series.
Add columns…Select additional columns to add to the dataset. Options: Add column with the alpha-coefficient (y-intercept) and Add column with the beta-coefficient (slope).
Group by selected columnsWhen selected, choose the columns from the list to group the results by.