## Experimental Design and SPC for Excel

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

Our experimental design software, SPC for 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
• 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

### SPC for Excel

Our SPC software, SPC for Excel, provides an easy way to perform statistical analysis in Microsoft Excel. This SPC software is very cost effective and user-friendly.

At the same time, it is a very powerful statistical package that meets the needs of most professionals - green belts, black belts, quality professionals, quality assurance, front-line personnel, supervisors, quality control, controllers, engineers, and laboratory personnel - anyone who wants to improve their data analysis.

### Overview of SPC for Excel

At only \$189 for a single user, SPC for Excel is an attractive alternative for many organizations. It is the perfect tool to use for statistical analysis, process improvement, problem solving and statistical training. Our SPC software is used internationally in over 60 countries. You also receive regular revisions to your version with no maintenance fees!  And we have great discounts for multiple users!

The software includes control charts, Pareto diagrams, histograms, scatter diagrams, fishbone diagrams, process capability analysis, measurement systems analysis, regression, experimental design, hyptoheses testing, nonparametric analysis and much more.    The software works with Excel 2000 through Excel 2010.

The links below provide more details on the SPC for Excel software.

Statistical Tools in SPC for Excel

Demo