Linear Regression

Function Performed — Straight-line linear regression. Looks at all occurrences of the specified argument, and uses a linear regression algorithm to calculate a 'straight line' through the occurrences.
Number of Arguments — One member or calculation.
Options — Whether missing values should be set to 0 in the calculation.

Example — Consider a spreadsheet with Actual as a column and Jan, Feb, Mar as rows. If the Actual values for these time periods were 100, 300, and 600, the Linear Regression column would be 83, 333, 583. Notice that there is now a constant difference between each value (250). All points in the sequence are adjusted. A chart of these numbers would produce a straight line that goes through the original data points.