Page 389 - Six Sigma Demystified
P. 389

Part 3  S i x   S i g m a  To o l S        369



                           The quadratic terms are significant. Contour and/or surface plots are generated
                           using Stat/DOE/Response Surface/Contour Surface Plots to reveal a maxima in
                           the region of the last data value (B = 0; E = 14.6989).
                           Use Stat/DOE/Response Surface/Response Optimizer. The optimal condition is
                           predicted at (B = –0.51; E = 12), resulting in a predicted maximum response of
                           10,010.

                           Excel

                           Using Black Belt XL Add-On
                           Use New Chart\Designed Experiment to select the response column and analyze
                           results. Use the “Terms” button to specify only first-order terms for the initial
                           screening analysis and to define terms in each subsequent pass as described
                           above for Minitab.

                           Select  Excel’s  Data\Solver  to  use  the  regression  function  (from  the  DOE
                           analysis) to determine an optimal condition for the response. The Set Target Cell
                           references  a  cell  containing  the  regression  function,  for  example,  “=8632  +
                           (–4152*B3) + (3184*B4) + (–8496*B3^2) + (–1848*B4^2) + (4377*B3*B4),” where
                           B3 and B4 refer to cells containing the starting value for factors B and E (respec-
                           tively), which are selected in the By Changing Cells field. The starting values for these
                           cells may be entered as the values of B and E that produce the optimal observed
                           response (but often can be left empty). The Min, Max, and Value of x options are used
                           to define the desired response as a maximum, minimum, or target.



                    run-Test rules


                           The Western Electric run-test rules add sensitivity to a control chart. These run
                           tests, developed by Western Electric, with some improvements by statistician
                           Lloyd Nelson, apply statistical tests to determine if there are any patterns or
                           trends in the plotted points.

                           When to Use


                           Use tests 1 through 8 on  X  and individual-X control charts; use tests 1 through
                           4 on attribute (P, U, Np, and C) charts. Run tests cannot be applied when the
                           underlying data or the plotted statistic is autocorrelated, such as in EWMA
                           charts.
   384   385   386   387   388   389   390   391   392   393   394