Experimental Design and SPC for Excel

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

 

ANOVA Table

 

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

ANOVA for Model

 

Factor Statistics

Factor Statistics

 

Effects Charts

Main Effects

 

Two Factor Charts

Factors Plot

 

Portion of the Residuals Analysis Worksheet

Residuals

 

Normal Plot of Residuals

Normal Residuals

 

Externally Studentized Residuals versus Predicted Values

Externally Studentized Residuals

 

DOE Optimization

DOE Optimization

 

SPC for Excel

To learn more about the many other tools in SPC for Excel and/or download the demo, click the link below.

SPC for Excel

 

Order Information

For information on ordering SPC for Excel, click the link below. We offer a 30 day money back guarantee.

How to Order