Multiple Response Optimization with Design of Experiments (DOE)
Design of experiments, is a systematic experimentation, with a process critical factors, in order to correlate these factors to process responses. In DOE with Excel we obtained a linear relationship, between several factors and one response. In Response Surface DOE this was extended to non-linear relations. In both cases we were optimizing one single response. Now we will analyse some cases where more than one response needs to be optimized. Problem Description Download file Multiple Response.xlsm from OneDrive to your PC. We want to maximize yield and minimize cost in a process where we have identified three critical factors which may affect both. These are the factors and levels we want to experiment with: Full Factorial DOE We start with a full factorial with two central points DOE and run a simulation of the experiments in sheet YieldCost Simul we then add the interaction columns (green headers) for the analysis: We now use Excel Data Analysis > ...