Category: Transform / Advanced
This action calculates the simple linear regression for a series of values.
Setting | Description |
---|---|
Category | Select the category column. |
Series | Select the series column. |
Mode | Select 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 columns | When selected, choose the columns from the list to group the results by. |