Rearranging an Fit model equation in an automated script
Aug 2, 2018 10:18 AM(1341 views)
I have a simple problem but for some reason i'm drawing a blank on how to solve it haha. I basically created a fit model for some data and had it output the formula into a column. Now I want to set Y and all the factors except one to values and solve for the unknown. In the example below, I want to solve for :RH assuming I have column data for all the other Variables. I can do algebra by hand and probably use the desirability manuallly..but neither seem ideal for automating the process. Any suggestions? Thanks in advance.
You might also take a look at the Inverse Prediction function. Click the top most red triangle (assuming LS fit) after fitting your model and select Estimates->Inverse Prediction... (Note that this option may be located under a different red triangle menu depending upon which fit personality you choose). This function is also accessible via scripting if you wish to automate it further.