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
PredictX calculates the predicted value of x for the y in column2 using the regtype regression model.
PredictX operates in exactly the same manner as Predict and all three parameters are optional. In the example, column C has been generated using PredictX using the same data as shown for PredictY. PredictX can predict x values for y values not in the data set in the same way that Predict can predict y values for x values not in the data set.
Note: If you type decimals using a comma (eg 3,2) you should enter this formula as PredictX(A; B; 1) - using the ; as a separator