Select the statistics to store for Response Optimizer

You can save statistics from your analysis to a worksheet so that you can use them in other analyses, graphs, and macros.

Save the best K solutions to a new worksheet

Select this option to store the predictor settings and composite desirability values.

K =

Specify a positive integer to store 1 or more solutions in a new worksheet.

Worksheet

Specify a name for the new worksheet. The analysis stores the solutions in the new worksheet.

Save composite desirability values for these settings

Select this option to store desirability values for the predictor settings in the active worksheet.

In the table, enter the columns that contain your prediction values. You must have one column for each predictor.

The predictor columns must be the same length and must be the same type as the original predictor variable.