Hey Victor and Statman,
It will take some time to anonymize my data set.... I will try to describe the situation in better detail before I do that.
My experiment:
Reponse: Y - attribute of a part being built during the test.
3 Controlled Continuous Factors: CX1, CX2, CX3
1 Uncontrolled (Ambient Environmental) Continuous Factor: UX4
I designed an experiment around the CXi, and knew ahead of time that UX4 drifts in a somewhat predictable way over the course of a day, so if I timed by tests correctly I could capture close-to-repeatable values of it, to give its domain some sense of regularity.
I then built what appears to be a fairly well behaved model using the factors, to see how they effect the response Y. Y does have a target value I am trying to achieve per unit built.
What seems to be the case is that my optimized values for the CXi are dependent on the value of UX4, so the scheme I am trying to implement as we go to make a part is: measure UX4, feed that value into the profiler, and then maximize the desirability of the CXi with the UX4 value fixed. The operator will then set their tools to the optimized CXi values before building the part.
What I would like then, is to automate this optimization per arbitrary value of UX4. I would like to have a data table where I provide a column of UX4, and then the other columns in the data table will be auto-filled with the optimized values of the CXi, and the predicted value of Y associated with those factor settings.
Does that add some clarity to my request?