SigmaXL^{® } Version
9 Feature List Summary

Compatible with Excel For Windows and Mac

- 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
- 1 Sample Z-Test and Confidence Interval for Mean
- 2 Sample t-Test and Confidence Interval (Compare 2 Means)
- 1 Sample Equivalence Test For Mean
- 2 Sample Equivalence Test (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 Proportions Tests and Confidence Interval
- 2 Proportions Equivalence Test
- 1 Poisson Rate Test and Confidence Interval
- 2 Poisson Rates Test and Confidence Interval
- 2 Poisson Rates Equivalence Test
- One-Way Chi-Square and Goodness of Fit Test (With Exact and Monte Carlo P-Value)
- One-Way Chi-Square and Goodness of Fit Test - Exact

- Measurement System Analysis (MSA) Templates
- Type 1 Gage Study
- Gage Bias and Linearity Study
- Gage R&R Study - with Multi-Vari Analysis
- Attribute Gage R&R (Attribute Agreement Analysis)
- Process Sigma Level - Discrete and Continuous
- Process Capability & Confidence Intervals
- Tolerance Interval Calculator (Normal Exact)
- DOE Templates
- 2 to 5 Factors
- 2-Level Full and Fractional-Factorial designs
- Main Effects & Interaction Plots
- Taguchi DOE Templates
- Taguchi L8 (2 Level) Three Factor - Robust Cake Example
- Taguchi L8 (2 Level) Four Factor - Catapult Example
- Taguchi L9 (3 Level) Four Factor - Paper Airplane Example
- L4, L8, L9, L12, L16, L18, L27
- Signal-to-Noise Ratios: Nominal is Best, Nominal is Best (Variance Only), Nominal is Best (Mean Square Deviation with Target), Larger is Better, Smaller is Better
- Pareto of Deltas (Effects) and ANOVA SS (Sum-of-Squares) % Contribution (for Main Effects and Two-Way Interactions)
- Main Effects and Interaction Plots
- Control Chart Templates

**
Graphical Tools:**

- 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, Multiple X 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

**
Measurement System Analysis:**

- Attribute MSA (Binary, Ordinal, Nominal)

**
Process Capability:**

- 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
- Automatic Best Fit based on AD p-value
- Nonnormal Process Capability indices: Z-Score (Cp, Cpk, Pp, Ppk) and Percentile (ISO) Method (Pp, Ppk)

**
Statistical Tools:**

- P-Values turn red when results are significant (P-Value < alpha)
- Descriptive Statistics including Anderson-Darling Normality test, Skewness and Kurtosis with P-Values
- Descriptive Statistics Options:
- Percentile Report and Percentile Ranges
- Percentile Confidence and Tolerance Intervals
- Additional Descriptive Statistics and Normality Tests (Shapiro-Wilk and Doomik-Hansen Normality)
- Outlier (Boxplot and Grubbs) and Randomness (Nonparametric Runs) Tests

- One-Way ANOVA and Means Matrix
- Multiple Comparison of Means Probability Methods (Post-Hoc): Fisher, Tukey, Dunnett With Control
- Automatic Assumptions Check for One Sample, Two-Sample, Paired T-tests and One-Way ANOVA
- Test report with color highlight: Green (OK), Yellow (Warning) and Red (Serious Violation)
- Test each sample for Normality. If not, check minimum sample size of robustness of test
- Check each sample for Outliers: Potential (Tukey's Boxplot 1.5*IQR); Likely (2.2*IQR); Extreme (3*IQR)
- Randomness (Nonparametric Runs Test)
- Equal Variance (for 2 or more samples)
- Two-Way ANOVA (Balanced and Unbalanced)

- Equal Variance Tests (Bartlett, Levene and Welch's ANOVA)
- Multiple Comparison of Variances Probability Methods (Post-Hoc): F-Test (with Bonferroni Correction), Levene, Tukey ADM (Absolute Deviation for Medians)
- Welch Multiple Comparison of Means Probability Methods (Post-Hoc): Welch Pairwise, Games Howell
- Correlation Matrix (Pearson and Spearman's Rank Correlation)
- Automatic normality check for correlation utilizing the powerful Doornik-Hansen bivariate normality test
- Yellow highlight to recommend significant Pearson or Spearman correlation - Pearson is highlighted if the data are bivariate normal, otherwise Spearman is highlighted

- Chi-Square Test (Stacked Column data and Two-Way Table data)
- With Fisher Exact (utilizing permutations and fast networks algorithms) and Monte Carlo P-Values
- Options: Advanced Tests and Measures of Association for Nominal & Ordinal Categories
- Nonparametric Tests:
- 1 Sample Sign and 1 Sample Wilcoxon
- 2 Sample Mann-Whitney
- Kruskal-Wallis and Mood's Median Test (With graph of Group Medians and 95% Median Confidence Intervals)
- Runs Test
- With Exact and Monte Carlo P-Value
- Nonparametric Tests - Exact:

- Power and Sample Size Calculators for:
- 1 and 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

**
Design of Experiments:**

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

**
Control Charts:**

- Control Chart Selection Tool
- Individuals, Individuals & Moving Range
- 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

- Control Chart Templates: Rare Events**
- Control Chart Templates: Time-Weighted**
- Control Chart Templates: Trend**

- Control Chart Templates: Average Run Length (ARL) Calculators**

**
Reliability/Weibull Analysis:**

**
Time Series Forecasting and Control Charts for Autocorrelated Data****

- Autocorrelation (ACF/PACF) Plots
- Cross Correlation (CCF) Plots
- Spectral Density Plot
- Seasonal Trend Decomposition Plots
- Exponential Smoothing Forecast
- Exponential Smoothing – Multiple Seasonal Decomposition (MSD) Forecast
- Exponential Smoothing Control Chart
- Exponential Smoothing Multiple Seasonal Decomposition (MSD) Control Chart
- ARIMA Forecast
- ARIMA Forecast with Predictors
- ARIMA – Multiple Seasonal Decomposition (MSD) Forecast
- ARIMA Control Chart
- ARIMA Control Chart with Predictors
- ARIMA Multiple Seasonal Decomposition (MSD) Control Chart
- Utilities – Difference Data
- Utilities – Lag Data
- Utilities – Interpolate Missing Values

Our CTO and Co-Founder, John Noguera, regularly hosts free Web Demos featuring SigmaXL and DiscoverSim**Click here to view some now!**

**Ph: **1.888.SigmaXL (744.6295)

**Support: **Support@SigmaXL.com

**Sales: **Sales@SigmaXL.com

**Information: **Information@SigmaXL.com