ANOVA and SPC for Excel

 

anova table

 

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 oveall 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 Square
  • F Calculation Information
    • Source, error degrees of freedom, error mean square, errro 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

 

Our 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 ANOVA output for the factors and models is shown above. More of the ANOVA output is shown below. Our software includes, among the features listed below, a full residual analysis with potential outliers in red. It also includes three methods for determining which means are significantly different as well as two methods for checking the equality of variances.

 

Examples of ANOVA Output

ANOVA Statistics

anova stats

 

Treatment Statistics

treatment means confidence interval

 

Bonferroni's Method for Differences in Means

bonferroni

 

Pairwise Treatment Mean Plots

pairwise mean plot

Bartlett's Test for Equality of Variances

 

bartlett

 

Variability Chart

variability chart

 

Variability Chart - Color Coded by Factor Levels

variabilitiy color coded

 

Xbar-R Control Chart

xbar chart

range chart

 

Components of Variance Chart

Components of Variance

Expected Mean Squares and F Calculation Information

expected mean squares

Portion of Residuals Analysis Worksheet

 

residauls table

Normal Plot of Raw Residuals

 

noraml probablity plot

 

 

Externally Studentized Residuals versus Predicted Values

 

externally studentized residuals

 

 

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.

 

 Buy SPC for Excel Now

 

Watch our SPC for Excel Introductory Video

 

Overview of SPC for Excel

At only $219 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

User Support, Upgrades, Systems Requirements

Customer Feedback

Software Videos ("How to")

Ordering Information

 

Download Free SPC for Excel Demo

 

 Buy SPC for Excel Now

 

Watch our SPC for Excel Introductory Video