Click here to see a video on how experimental designs are performed using SPC for Excel

Our experimental design software, SPC for MS Excel, contains two-level full factorial designs (up to 7 factors), fractional factorial designs (29 different designs, up to 15 factors), and Plackett-Burman designs (up to 27 factors). The ANOVA output from the program is shown above. Additional output examples are given below. The software includes a full residual analysis as well as the ability to easily change the effects to include in the model. The experimental design features are given below along with additional examples of the output.

Experimental Design Features

• Full factorials
• Fractional factorials
• Plackett- Burman
• Design table analysis
• ANOVA Table for factors and interactions
• ANOVA for model
• Model for coded and actual factors
• Design statistics
  • Average
  • Standard deviation
  • Coefficient of variation
  • R square
  • Adjusted R square
  • PRESS
  • R square prediction
• Normal plot of effects
• Half-normal plot of effects
• Effects charts
• Two factor charts
• Residuals analysis
  • Residuals
  • Leverage
  • Standardized residuals
  • Internally studentized residuals
  • Externally studentized residuals
  • DFFITS
  • Cook's distance
  • Potential outliers in red
• Residuals charts (raw, standardized, internally or externally studentized residuals)
  • Normal plot
  • Versus predicted values
  • Versus actual run number
• Other charts
  • Predicted vs actual
  • DFFITS, Cook's distance and leverage versus actual run number
• DOE optimization chart
• Easily select effects to include/exclude in the analysis
• p values < 0.05 in red

Other Experimental Design Output

ANOVA for Model and DOE Statistics

Factor Statistics

Effects Charts

Two Factor Charts

Portion of the Residuals Analysis Worksheet

Normal Plot of Residuals

Externally Studentized Residuals versus Predicted Values

DOE Optimization