3 Factor Design of Experiments

This spreadsheet allows the user to perform a complete 3 factor, full
factorial Design of Experiments (DOE).  DOE can be used to identify
what inputs in your process are effecting variation in your products.  
Stop guessing!  Most people experiment by changing one factor at a
time, however, this practice is costly, time consuming and fails to
identify interactions.  DOE can be used to find the correct settings to
maximize process yields, minimize scrap or correctly target your
process.  DOE can also be used in design by generating a predictive
mathematical equation.  After completing the DOE, what-if settings of
the input factors can be evaluated using the spinner buttons.
Features Include:

  • Up to three input factors can be studied
  • The process average can be analyzed to maximize,
    minimize or optimize your process
  • The standard deviation can be analyzed to find settings
    that reduce variation and improve process capability.
  • Main Effect and Interaction charts are generated to
    easily identify important factors
  • The Analysis of Variance table tells you which input
    factors are significant.
  • Repeated or Replicated values can now be used.
  • A 3D scatter plot is generated that can be rotated in
    three axes.
  • What-if analysis
Quality Dimensions
3 Factor DOE