Statistical Tools

spc logoThe “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

Your email address will not be published. Required fields are marked *