Linear Regression Sqd
The determination coefficient is a quality measure of value description for last time periods by the help of linear regression line. If the regression coefficient is closer to 1, then the value has a strong positive linear dependence of time. If the regression coefficient is closer to –1, then the value has a strong negative linear dependence of time. If the regression coefficient is closer to 0, then the value has a weak linear dependence of time.
Linear Regression Sqd(Parameters)
- Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
- Output range. The cell reference for the range of output data.
- Period. Number of values used for calculation.
Linear Regression Sqd(Syntax)
LinearRegressionSqd(RANGE;PERIOD;DIRECTION)
Example
=LinearRegressionSqd(A1:A10;10;0)
|
