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 Proportion Tests and Confidence Interval (With Fisher Exact P-Value)
- 2 Proportion 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
- 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
- Individuals, C-Chart

**
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

- Analysis of Means (ANOM) Charts
- All charts support balanced & unbalanced data
- Normal, Binomial Proportions and Poission Rates: One-Way & Two-Way with Main Effects and Slice Charts
- Slice Charts are a modified ANOM chart developed by Dr.Peter Wludyka that enables one to easily interpret the effects in the presence of an interaction. In collaboration, Peter Wludyka and John Nogurea of SigmaXL extended the Slice Charts to Binomial and Poisson. Yellow highlights automatically recommends Main Effects (if interaction is not significant) or Slice Chart(if interaction is significant)
- Nonparametric Transformed Ranks
- Variances & Levene Robust Variances

**
Measurement System Analysis:**

**
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:

- 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**

**
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