| What the name means | "Linear Regression"
| | Syntax | LinReg ( LRSwitch, YValues, XValues )
| | Description | Solves the slope and intercept of a Linear Regression problem.
| | Auto Array Function | This function can be used as an array function as well as a normal function, by pluralising the first variable (in this case LRSwitch) to give an answer array. See Array Functions.
|
Defaults and Values The variable(s) of this function have certain defaults and/or switch values associated with them. Click here to see more. | Type of Value | Value | Description | Detail | | Default(s)
| LRSwitch | 0 | Correlation Coefficient (R squared) | | Switches
| LRSwitch | 0 | Correlation Coefficient (R squared)
| | | 1 | Intercept
| | | 2 | Slope
| | | 3 | Covariance
| | | 4 | Variance (y)
| | | 5 | Variance (x) |
Range Handling and ConstraintsThis function has range inputs that are subject to range handling procedures to help reduce input errors and increase flexibility and speed. Click here to see more. The variables affected are as follows (in order): | Variable | Type of Handling | Explanation | | XValues YValues | Trailing Zero Size (2 or more ranges) | If the ranges are of different lengths, the longer will be shortened to the size of the shorter range. Then, if both corresponding elements at the end of the ranges are zero, the ranges are shortened further. For instance ({20,30,0,0,0},{0,10,10,0,0}) would be shortened to ({20,30,0},{0,10,10}) | | YValues | Trailing Blank Size (one range, and will not shorten to a range length less than 1) | If this range has trailing blanks (as opposed to zeros, a blank is a cell with nothing in it), the range will be shortened to the last non-blank element. |
Key Points | X-axis values= Values1
Y-axis values=Values2 |
Examples | - Preview of the LinReg example.
- The above spreadsheet can be accessed from the Quick Reference (on the Business Functions menu), on the Examples menu, or in the Business Functions\Component Examples directory
|
| 