Statistical Tools in SPC for Excel
The statistical charts, tools and techniques included in SPC for Excel are given below. Click on any of the links for more information on the statistical tool including a video showing how to use the tool. The video at the bottom of this page highlights the features in the software.
SPC for Excel Statistical Tools
- Pareto Diagrams – Frequency, Defect, Variable
- Histograms – Basic, Multiple, Group
- Control Charts - Variables (Subgroups, Individuals, Between/Within, Time Weighted, Multivariate) and Attributes
- Process Capability – Normal, Nonnormal, Snapshot, Poisson, Binomial
- Scatter Diagrams
- Cause and Effect (Fishbone) Diagrams
- Regression - Multiple Linear, Stepwise, Forward Selection, Backward Elimination, Best Subsets, Poisson and Binary Logistic
- Gage R&R – EMP, ANOVA, Average/Range, Nested, Type 1, Attribute, Equivalency of Instruments, Linearity, Bias, Bland-Altman and Deming Regression
- Experimental Design – Two Level Full Factorial, Fractional Factorial, Plackett-Burman
- ANOVA
- Box-Cox and Johnson Transformations
- Distribution Fitting
- Hypothesis Testing - One/Two Sample, Equivalence Tests, Proportions Tests, Poisson Rate Tests, Outlier Test, Sample Size Calculator
- Comparing Multiple Processes – Fisher, Tukey, Bonferroni, Bartlett, Levene, Box-Whisker)
- Correlation Analysis Techniques - Correlation Coefficients, Scatter Plot Matrix, Waterfall Charts, BACI charts, Plot Multiple Y against One X, FMEA)
- Descriptive Statistics
- ANOM, ANOX – Analysis of Means and Individuals
- Time Series Analysis
- Nonparametric Tests – One Sample Sign, One Sample Wilcoxen Signed Rank, Mann-Whitney, Kruskal-Wallis
- Miscellaneous Tools – Chi Square Goodness of Fit, Random Number Generator, Side by Side Histogram, Item Analysis, Individual/Interval/Beeswarm Plots
- Normal Probability Plot
Watch a Quick Video Highlighting the Key Features in SPC for Excel
SPC for Excel is easy to use as a stand alone or in Lean Six Sigma and Process Improvement Projects. With help files, example files, and how-to videos. Affordable and Powerful for manufacturing, businesses, and education. Includes free builds, no maintenance fees and two download per user!