solver - Using the Microsoft Excel Solver for Dual Response...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Using the Microsoft Excel Solver for Dual Response Optimization The Excel spreadsheet program, available on both Windows and Mac platforms, has an NLP routine that is quite simple to use for dual response optimization. This routine, called Solver (under the “Tools” menu) uses the generalized reduced gradient (GRG) algorithm that is described in detail in Del Castillo and Montgomery (JQT 1993). A lesson on the use of the Solver routine for solving the example problem of “target is best” is shown. In this example, we wish to simultaneously optimize two equations for two different response variables. Although this example uses equation models for a mean and a standard deviation response for a single response variable, these two models could just as easily be two responses, such as cost and yield, that you wish to simultaneously optimize. (We use a standard ANOVA or regression program to create these equations prior to entering the Solver routine.) For multiple response problems, the process expert
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/27/2011 for the course EIN 4905 taught by Professor Staff during the Spring '08 term at University of Florida.

Page1 / 2

solver - Using the Microsoft Excel Solver for Dual Response...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online