The “Statistical Tools” section of the SPC for Excel software contains a variety of statistical techniques. There are six sections as shown on the SPC for Excel ribbon. Select the link to go to the section’s homepage.
- Descriptive Statistics
- Sample Tests
- One sample z and t tests for a mean
- One sample variance test
- z and t tests for difference in two means
- t test for paired samples comparison
- One proportion test
- Two proportion test
- Power and sample size
- Comparing Processes
- Fisher’s LSD Method for Means
- Tukey’s Method for Means
- Bonferroni’s Method for Means
- Box and Whisker Plots
- Bartlett’s Test for Equality of Variances
- Modified Levene’s Test for Equality of Variances
- Correlation
- Correlation Coefficients
- Failure Mode and Effects Analysis
- Plot Multiple Y Variables Against One X Variable
- Scatter Plot Matrix
- Waterfall Chart
- BACI Charts
- Nonparametric techniques
- One sample sign test
- One sample Wilcoxon signed rank test
- Mann-Whitney test for two samples
- Kruskal-Wallis test for multiple samples
- Miscellaneous Tools
- Chi Square Goodness of Fit Test
- Chi Square Test for Association
- Side by Side Histogram
- Item Analysis
- Random Number Generator
Leave a Reply