Variability ChartOur SPC software, SPC for Excel, performs ANOVA for one to five factors. ANOVA allows you to determine if there are significant differences between treatments.The software contains crossed, nested or mixed designs - as well as fixed or random factors.  The runs can be randomized.

The output includes the ANOVA table for the factor and for the model.  Also included is the variability chart - a chart that shows each run at each level of the factors.  This chart is easily revised to switch factor levels or can be colored-coded by factor.  A complete list of ANOVA features is given below.


ANOVA table


Watch a Video Highlighting SPC for Excel's Analysis of Variance (ANOVA) Methodology



Join those in over 80 countries using SPC for Excel!


 Buy SPC for Excel Download Free Trial


ANOVA Features

  • One to five factors
  • Crossed, nested or mixed designs
  • Fixed and/or random factors
  • Multiple responses
  • Randomization of runs
  • Option to visualize design
  • 1 to 25 Replications
  • ANOVA table for factors
  • ANOVA table for models
  • Statistics
    • Average
    • Standard deviation
    • Coefficient of variation
    • R square
    • Adjusted R square
  • 95% confidence intervals for treatment means (fixed factors)
  • Comparison of treatment means and variances (fixed factors)
    • Treatment means
      • Tukey's method
      • Bonferroni's method
      • Fisher's LSD method
      • Option to plot pairwise comparisons
    • Treatment  variances
      • Bartlett's Test
      • Levene's Method
  • Variability Plots
    • Plots each treatment versus factor levels
    • Option to plot treatment averages and overall averages
    • Option to re-order factors on plot
    • Option to color-code by a factor's levels
  • Components of Variance Plots
    • % of total by factor
    • Estimates of variance and standard deviation by factor
  • Xbar and R/s charts
    • Xbar: Plots treatment means
    • R: plots treatment ranges
    • s: plots treatment standard deviations
  • Expected Mean Squares
  • F Calculation Information
    • Source, error degrees of freedom, error mean square, error mean square calculation
  • Rollup Control Charts
    • Rollup control charts (primarily for nested designs)
  • Residuals analysis
    • Residuals
    • Leverage
    • Standardized residuals
    • Internally studentized residuals
    • Externally studentized residuals
    • DFFITS
    • Cook's distance
    • Potential outliers in red
  • Residuals charts (select 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
  • p values < 0.05 in red

 Have Questions? Contact Us

SPC for Excel

SPC Knowledge Base

subscribe button

Sign up for our FREE monthly publication featuring SPC techniques and other statistical topics.

Customer Stories

Click here to see what our customers say about SPC for Excel!

SPC Around the World

SPC for Excel is used in 80 countries internationally.  Click here for a list of those countries.


Connect with Us