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