Virtual Menu

SigmaXL - Powerful Statistical and Graphical Analysis

- Category Subset
- Random Subset
- Numerical Subset
- Date Subset
- Transpose Data
- Stack Subgroups Across Rows
- Stack Columns
- Unstack Columns
- Random Data >>
- Box-Cox Transformation
- Standardize Data
- Convert to Discrete
- Frequency Conversion >>
  - Convert Raw Data to Frequency
  - Convert Frequency to Raw Data
- Data Preparation >>
  - Remove Blank Rows and Columns
  - Change Text Data Format to Numeric
- DMAIC & DFSS
  Templates >>
- Lean >>
- Basic Graphical
  Templates >>
- Basic Statistical
  Templates >>
- Probability Distribution Calculators >>
  - Normal
  - Inverse Normal
  - Lognormal
  - Exponential
  - Weibull
  - Binomial
  - Poisson
  - Hypergeometric
- Basic MSA Templates >>
- Basic Process Capability Templates >>
- Basic DOE Templates >>
- Basic Taguchi DOE Templates >>
- Control Chart Templates >>
  - Basic >>
    - Individuals Chart
    - C (Count) Chart
  - Rare Events >>
  - Time Weighted >>
    - EWMA
    - CUSUM
  - Trend
  - Average Run Length (ARL Calculators>>
- Hypothesis Test Selection Guide
- Basic Statistical
  Templates >>
  - Sample Size - Discrete
  - Sample Size - Continuous
  - Minimum Sample Size for Robust t-Tests & ANOVA
  - 1 Sample Z-Test & Confidence Interval for Mean
  - 1 Sample t-Test & Confidence Interval for Mean
  - 2 Sample t-Test & Confidence Interval (Compare 2 Means)
  - 1 Sample Equivalence Test for Mean
  - 2 Sample Equivalence Test (Compare 2 Means)
  - 1 Sample Chi-Square Test & CI for Standard Deviation
  - 2 Sample F-Test and CI (Compare 2 Standard Deviations)
  - 1 Proportion Test & Confidence Interval
  - 2 Proportion Test & Confidence Interval
  - 2 Proportion Equivalence Test
  - 1 Poisson Rate Test & Confidence Interval
  - 2 Poisson Rates Test & Confidence Interval
  - One-Way Chi-Square & Goodness-of-Fit Test
  - One-Way Chi-Square & Goodness-of-Fit Test - Exact
- Descriptive Statistics
- 1 Sample t-Test & Confidence Intervals
- Paired t-Test
- 2-Sample t-Test
- 2-Sample Comparison Tests
- One-Way ANOVA & Means Matrix
- Welch's ANOVA (Assume Unequal Variances)
- Two-Way ANOVA
- Equal Variance Tests >>
  - Bartlett
  - Levene
  - Welch's ANOVA (Assume Unequal Variances)
- Correlation Matrix
- Regression >>
  - Multiple Regression
  - Binary Logistic Regression
  - Ordinal Logistic Regression
- Advanced Multiple Regression >>
  - Fit Multiple Regression Model
  - Multiple Response Optimization
- General Linear Model >>
  - Fit General Linear Model
  - GLM Multiple Response Optimization
- Chi-Square Tests >>
  - One-Way Chi-Square Goodness-of-Fit Template
  - Chi-Square Test
  - Chi-Square Test - Two-Way Table Data
- Chi-Square Tests - Exact >>
  - One-Way Chi-Square Goodness-of-Fit-Exact Template
  - Chi-Square Test - Fisher's Exact
  - Chi-Square Test Two-Way Table Data - Fisher's Exact
- Nonparametric Tests >>
  - 1 Sample Sign
  - 1 Sample Wilcoxon
  - 2 Sample Mann-Whitney
  - Kruskal-Wallis Median Test
  - Mood's Median Test
  - Friedman Test
  - Runs Test
- Nonparametric Tests - Exact >>
  - 1 Sample Wilcoxon - Exact
  - 2 Sample Mann-Whitney - Exact
  - Kruskal-Wallis Median Test - Exact
  - Mood's Median Test - Exact
  - Friedman Test - Exact
  - Runs Test - Exact
- Power & Sample Size Calculators >>
  - 1 Sample t-Test Calculator
  - 2 Sample t-Test Calculator
  - One-Way ANOVA Calculator
  - 1 Proportion Test Calculator
  - 2 Proportions Test Calculator
- Power & Sample Size with Worksheets >>
  - 1 Sample t-Test
  - 2 Sample t-Test
  - One-Way ANOVA
  - 1 Proportion Test
  - 2 Proportions Test
- Power & Sample Size Chart
- Basic Process Capability Templates >>
- Histograms & Process Capability
- Capability Combination Report (Individuals)
- Capability Combination Report (Subgroups)
- Nonnormal >>
- Basic DOE Templates >>
- Basic Taguchi DOE Templates >>
- 2-Level
  Factorial/Screening >>
- Response Surface >>
- Control Chart Selection Guide
- Control Chart Templates >>
  - Basic >>
    - Individuals Chart
    - C (Count) Chart
  - Rare Events >>
  - Time Weighted >>
    - EWMA
    - CUSUM
  - Trend
  - Average Run Length (ARL Calculators>>
- Individuals
- Individuals & Moving Range
- X-Bar & R
- X-Bar & S
- Attribute Charts >>
  - P
  - NP
  - C
  - U
  - P' (Laney)
  - U' (Laney)
- Nonnormal >>
- I-MR-R
- I-MR-S
- 'Tests for Special Causes' Defaults
- Run Chart
- Autocorrelation (ACF/PACF) Plots
- Cross Correlation (CCF) Plots
- Spectral Density Plot
- Seasonal Trend Decomposition Plots
- Exponential Smoothing Forecast >>
  - Forecast
  - Multiple Seasonal Decomposition Forecast
- Exponential Smoothing Control Chart >>
  - Control Chart
  - Multiple Seasonal Decomposition Control Chart
- ARIMA Forecast >>
- ARIMA Control Chart >>
- Utilities >>

Excel Spreadsheet