Differences

This shows you the differences between two versions of the page.

--- transformations:linearregression [2022/10/02 20:14] – change action category craigt
+++ transformations:linearregression [2025/02/27 17:15] (current) – add Example and Remark craigt
@@ Line 1: / Line 1: @@
 {{ transformations:LinearRegressionAction.png}}
 ======LINEAR REGRESSION======
-Category: Transform / Advanced\\
+Category: Transform / Math\\
 \\
@@ Line 15: / Line 15: @@
 |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.|
+\\
+=====Remarks=====
+The output of this action can be used to create the regression line in a chart.  (The chart below is sourced from the After table in the Example, below.)
+{{  transformations:regression_chart.png  }}
+\\
+=====Examples=====
+====Example #1====
+>Generate the simple linear regression for the following income statement.
+===Before (source table)===
+^Date ^Income ^
+|  01-Feb-2025|  21.53|
+|  02-Feb-2025|  17.99|
+|  03-Feb-2025|  23.89|
+|  04-Feb-2025|  24.49|
+|  05-Feb-2025|  39.98|
+|  06-Feb-2025|  24.74|
+===After (result table)===
+^Date ^Income ^Regression ^
+|  01-Feb-2025|  21.53|  19.535|
+|  02-Feb-2025|  17.99|  21.896|
+|  03-Feb-2025|  23.89|  24.256|
+|  04-Feb-2025|  24.49|  26.617|
+|  05-Feb-2025|  39.98|  28.978|
+|  06-Feb-2025|  24.74|  31.338|
+Regression values rounded for brevity.
+===Action parameters===
+>Category: Date
+>Series: Income
+>Mode: Linear trend
+>New column name: Regression