ResidualX(column1, column2, regtype)
|Top Previous Next|
column1 contains the independent variable's data (usually x values)
column2 contains the dependent variable's data (usually y values)
regtype is the regression model
ResidualX calculates the residual value of x for the y in column2 using the regtype regression model.
ResidualX operates in exactly the same manner as Residual and all three parameters are optional. In the example, column C has been generated using ResidualX using the same data as shown for Residual.
Note: If you type decimals using a comma (eg 3,2) you should enter this formula as ResidualX(A; B; 1) - using the ; as a separator