SigmaXL Version 6.1 Feature List Summary
Compatible with Excel 2010: 32 & 64 bit**
Menu Layout: Classical or DMAIC
Data
Manipulation:
- Team/Project Charter
- SIPOC Diagram
- Flowchart Toolbar
- Data Measurement Plan
- Cause & Effect (Fishbone) Diagram and Quick Template
- Cause & Effect (XY) Matrix with Pareto**
- Failure Mode & Effects Analysis (FMEA) with RPN Sort**
- Quality Function Deployment (QFD)
- Pugh Concept Selection Matrix
- Control Plan
- Sample Size – Discrete and Continuous
- 1 Sample t Confidence Interval for Mean**
- 2 Sample t-Test (Assume Equal and Unequal Variances)**
- 1 Sample Confidence Interval for Standard Deviation
- 2 Sample F-Test (Compare 2 StDevs)**
- 1 Proportion Confidence Interval (Normal and Exact)
- 2 Proportions Test & Fisher’s Exact**
- Normal, Lognormal, Exponential, Weibull
- Binomial, Poisson, Hypergeometric
- 2 to 5 Factors
- 2-Level Full and Fractional-Factorial designs
- Main Effects & Interaction Plots
- 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, Dotplots
- Run Charts (with Nonparametric Runs Test allowing you to test for Clustering, Mixtures, Lack of Randomness, Trends and Oscillation)
- Overlay Run Chart
Measurement Systems Analysis:
- Create Gage R&R (Crossed) Worksheet:
- Generate worksheet with user specified number of parts, operators, replicates
- Analyze Gage R&R (Crossed)
- ANOVA, %Total, %Tolerance (with upper and/or lower specifications), %Process, Variance Components, Number of Distinct Categories
- Gage R&R Multi-Vari and X-bar R Charts
- Confidence Intervals for %Total, %Tolerance, %Process and Standard Deviations Handles unbalanced data
- Attribute MSA (Binary)
- Any number of samples, appraisers and replicates
- Within Appraiser Agreement, Each Appraiser vs Standard Agreement, Each Appraiser vs Standard Disagreement, Between Appraiser Agreement, All Appraisers vs Standard Agreement; Fleiss' kappa
- Multiple Histograms and Process Capability
- Capability Combination Report for Individuals/Subgroups:
- Histogram, Normal Probability Plot and Normality Test
- Capability Report (Cp, Cpk, Pp, Ppk, Cpm, ppm, %)
- Control Charts
- 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
- All valid distributions and transformations reported with histograms, curve fit and probability plots
- Within Appraiser Agreement, Each Appraiser vs Standard Agreement, Each Appraiser vs Standard Disagreement, Between Appraiser Agreement, All Appraisers vs Standard Agreement; Fleiss' kappa
Statistical
Tools:
-
Accepts continuous and/or categorical (discrete) predictors
- Interactive Predicted Response Calculator with 95% Confidence
Interval and 95% Prediction Interval
- Residual Plots: histogram, normal probability plot, residuals vs.
time, residuals vs. predicted and residuals vs. X factors
- Residual types include Regular, Standardized, Studentized (Deleted
t) and Cook's Distance (Influence), Leverage and DFITS
- Highlight of significant outliers in residuals
- Durbin-Watson Test for Autocorrelation in Residuals with p-value
- ANOVA report for categorical predictors
- Pure Error and Lack-of-Fit report
- Collinearity Variance Inflation Factor (VIF) and Tolerance report
- Fit Intercept is optional
- Powerful and user-friendly logistic regression.
- Report includes a calculator to predict the response event
probability for a given set of input X values.
- Categorical (discrete) predictors can be included in the model in
addition to continuous predictors.
- Model summary and goodness of fit tests include Likelihood Ratio
Chi-Square, Pseudo R-Square, Pearson Residuals Chi-Square, Deviance
Residuals Chi-Square, Observed and Predicted Outcomes – Percent
Correctly Predicted.
- Stored data includes Event Probabilities, Predicted Outcome, Observed-Predicted, Pearson Residuals, Standardized Pearson Residuals, and Deviance Residuals.
-
1 Sample Sign and 1 Sample Wilcoxon
- 2 Sample Mann-Whitney
- Kruskal-Wallis and Mood’s Median Test
- Kruskal-Wallis and Mood’s include a graph of Group Medians and 95% Median Confidence Intervals
- Runs Test
-
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).
Design of Experiments:
- Generate 2-Level Factorial and Plackett-Burman Screening Designs
- User-friendly dialog box
- 2 to 19 Factors; 4,8,12,16,20 Runs
- Unique “view power analysis as you design”
- Randomization, Replication, Blocking and Center Points
- 2 to 5 Factors, 2-Level Full and Fractional-Factorial designs
- Automatic update to Pareto of Coefficients
- Easy to use, ideal for training part
- Used in conjunction with Recall Last Dialog, it is very easy to
iteratively remove terms from the model
- Interactive Predicted Response Calculator with 95% Confidence
Interval and 95% Prediction Interval.
- ANOVA report for Blocks, Pure Error, Lack-of-Fit and Curvature
- Collinearity Variance Inflation Factor (VIF) and Tolerance report
- Residual plots: histogram, normal probability plot, residuals vs.
time, residuals vs. predicted and residuals vs. X factors
- Highlight of significant outliers in residuals
- Durbin-Watson Test for Autocorrelation
- 2 to 5 Factors
- Central Composite and Box-Behnken Designs
- Easy to use design selection sorted by number of runs
Control Charts:
-
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
-
Weibull Analysis
- Complete and Right Censored data
- Least Squares and Maximum Likelihood
- Output includes percentiles with confidence intervals, survival probabilities, and Weibull probability plot.
Download the SigmaXL Workbook containing all this information and more
Our CTO and Co-Founder, John Noguera, regularly hosts free Webinars covering a variety of topics relevant to the world of Six Sigma. Watch them here!
Wikipedia