SigmaXL Version 7.0 Feature List Summary

Compatible with Excel 2010/2013: 32 & 64 bit

Menu Layout: Classical or DMAIC

Recall Last Dialog

- Subset by Category, Random, Number, or Date
- Transpose Data
- Stack Subgroups Across Rows
- Stack and Unstack Columns
- Standardize Data
- Random Number Generator
- Data Preparation
- Box-Cox Transformation

- DMAIC & DFSS Templates
- Lean Templates
- Graphical Templates
- Statistical Templates
- Sample Size – Discrete and Continuous
- Minimum Sample Size for Robust t-Tests and ANOVA*
- 1 Sample t-Test and Confidence Interval for Mean
- 2 Sample t-Test and Confidence Interval (Compare 2 Means)
- 1 Sample Chi-Square Test and CI for Standard Deviation*
- 2 Sample F-Test and CI (Compare 2 Standard Deviations) *
- 1 Proportion Test and Confidence Interval
- 2 Proportion Tests and Confidence Interval
- 1 Poisson Rate Test and Confidence Interval
- 2 Poisson Rates Test and Confidence Interval
- One-Way Chi-Square and Goodness of Fit Test*
- One-Way Chi-Square and Goodness of Fit Test - Exact**
- Probability Distribution Calculators
- MSA Templates
- Process Sigma Level – Discrete and Continuous
- Process Capability & Confidence Intervals
- DOE Templates
- 2 to 5 Factors
- 2-Level Full and Fractional-Factorial designs
- Main Effects & Interaction Plots
- Control Chart Templates
- Individuals
- C-Chart

- Basic and Advanced (Multiple) Pareto Charts
- EZ-Pivot/Pivot Charts: Easily create Pivot Tables and Charts
- Basic Histogram
- Multiple Histograms and Descriptive Statistics (includes Confidence Interval for Mean and StDev., and Anderson-Darling Normality Test)
- Multiple Histograms and Process Capability

(Pp, Ppk, Cpm, ppm, %) - Multiple Boxplots, Dotplots
- Run Charts (with Nonparametric Runs Test allowing you to test for Clustering, Mixtures, Lack of Randomness, Trends and Oscillation)
- Overlay Run Chart
- Multiple Normal Probability Plots (with 95% confidence intervals to ease interpretation of normality/non-normality)
- Multi-Vari Charts
- Scatter Plots (with linear regression and optional 95% confidence intervals and prediction intervals)
- Scatter Plot Matrix

- Create Gage R&R (Crossed) Worksheet:
- Generate worksheet with user specified number of parts, operators, replicates
- Analyze Gage R&R (Crossed)
- Attribute MSA (Binary)*
- Attribute MSA (Ordinal)**
- Attribute MSA (Nominal)**
- Confidence Interval Graphs for Percent Agreement and Fleiss' Kappa Coefficient
- Kappa color highlight to aid interpretation: Green (>.9), Yellow (.7-.9) and Red (<.7)

**Process
Capability:**

- Multiple Histograms and Process Capability
- Capability Combination Report for Individuals/Subgroups:
- Capability Combination Report for Nonnormal Data (Individuals)
- Box-Cox Transformation (includes an automatic threshold option so that data with negative values can be transformed)
- Johnson Transformation
- Distributions supported: Half-Normal, Lognormal (2 & 3 parameter), Exponential (1 & 2), Weibull (2 & 3), Beta (2 & 4), Gamma (2 & 3), Logistic, Loglogistic (2 & 3), Largest Extreme Value, Smallest Extreme Value
- Nonnormal Process Capability Indices: Z-Score (Cp, Cpk, Pp, Ppk) and Percentile (ISO) Method (Pp, Ppk)
- Distribution Fitting Report

- P-Values turn red when results are
significant
(P-Value < alpha)

- Descriptive Statistics including Anderson-Darling Normality test,
Skewness and Kurtosis with P-Values
- Confidence Intervals
- 1 Sample t-test*

- 2 Sample t-test,
Paired t-test*
- 2 Sample comparison tests*:
- One-Way ANOVA and Means Matrix

- Two-Way ANOVA (Balanced and Unbalanced)

- Equal Variance Tests (Bartlett, Levene and Welch’s ANOVA)*

- Correlation Matrix (Pearson and Spearman’s Rank Correlation)*

- Multiple Linear Regression:
- Binary and Ordinal Logistic Regression
- Chi-Square Test* (Stacked Column data and Two-Way Table data)
- Chi-Square Test - Exact**
- Chi-Square Test - Fisher's Exact**
- Chi-Square Test Two-Way Table Data - Fisher's Exact**
- One-Way Chi-Square Goodness-of-Fit Exact Template
- Nonparametric Tests*:
- 1 Sample Sign and 1 Sample Wilcoxon

- 2 Sample Mann-Whitney

- Kruskal-Wallis and Mood’s Median Test
- Runs Test
- Nonparametric Tests - Exact**:

- Power and Sample Size Calculators for:
- 1 Sample
t-Test, 2 Sample t-Test*

- One-Way ANOVA*

- 1 Proportion Test,
2 Proportions Test*

- The Power and Sample Size Calculators allow you to solve for Power (1 – Beta), Sample Size, or Difference (specify two, solve for the third).
- Power and Sample Size Chart. Quickly create a graph showing the relationship between Power, Sample Size and Difference.

- Generate 2-Level Factorial and Plackett-Burman Screening Designs
- Basic DOE Templates
- Main Effects & Interaction Plots
- Analyze 2-Level Factorial and Plackett-Burman Screening Designs
- Contour & 3D Surface Plots
- Response Surface Designs

- Control Chart Selection Tool

- Individuals
- X-Bar & R, X-Bar & S

- I-MR-R, I-MR-S (Between/Within)

- P, NP, C, U
- P’ and U’ (Laney) to handle overdispersion

- Control charts include a report on tests for special causes.
Special causes are also labeled on the control chart data point. Set
defaults to apply any or all of Tests 1-8.
- Process Capability report (Pp, Ppk, Cp, Cpk) is available for I,
I-MR, X-Bar & R, X-bar & S charts.

Add data to existing charts for operator ease of use!

- Scroll through charts with user defined window size

- Advanced Control Limit options: Subgroup Start and End; Historical
Groups (e.g. split control limits to demonstrate before and after
improvement)
- Exclude data points for control limit
calculation
- Add comment to data point for
assignable cause
- ±
1, 2 Sigma Zone Lines
- Control charts for
Nonnormal data (Individuals)
- Box-Cox and Johnson Transformations

- 16 Nonnormal distributions supported (see Process Capability)

- Individuals chart of original data with percentile based control
limits
- Individuals/Moving Range chart for normalized data with optional tests for special causes

**Download the SigmaXL Workbook containing all this
information and more**

**New Features in SigmaXL 7.0

*Updated Features in SigmaXL 7.0