Multiple Means and Variances Comparisons

SPC for Excel contains three major methods of determining if there are significant differences in the treatment (process) means. These include Fisher's LSD method, Tukey's method, and Bonferroni's method. Equality of variances is tested using Bartlett's method or Levene's method. In each method, the software clearly tells you if significant differences are found and which treatment means or variances are different. The software also contains the Analysis of Means method to determine if there are significant differences in treatment means. Box and Whisker plots give a visual picture of the median locations and the spread in the data.

Multiple Process Comparison Features

• Fisher LSD, Bonferroni and Tukey's Method
• Stacked or unstacked data entry
• ANOVA table
• Count, mean, standard deviation, variance by treatment
• Family confidence interval
• Individual confidence interval
• Confidence interval for each pair of treatments
• Yes/No decision if pairs are different or the same
• Yes in red if significant difference
• Plot of confidence intervals
• Bartlett's and Levene's Method
• Stacked or unstacked data entry
• Count, mean standard deviation, variance by treatment
• Test statistics
• Chi square critical value
• p value
• Decision if the variances are the same
• Analysis of Means
• Table of results including average, maximum, minimum, range, treatment variance, treatment degrees of freedom, overall average, average range, H, and lower/upper decision limits
• Control charts with different treatment means plotted in red
• Box and Whisker Plots
• Median
• 25% and 75% quartiles
• Minimum
• Maximum

Examples of Output

Confidence Interval Plot Bartlett's Test for Equality Analysis of Means Box and Whisker Plots

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 \$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