What is SigmaXL Software?
SigmaXL was meticulously crafted to serve as an affordable, potent, and user-friendly solution. It empowers individuals to gauge, scrutinize, enhance, and manage their service, transactional, and manufacturing procedures. By seamlessly integrating with the well-known Microsoft Excel, SigmaXL becomes exceptionally well-suited for Lean Six Sigma training as well as inclusion in college-level statistics curricula.
SigmaXL offers following features:
- Data Manipulation
- Templates & Calculators
- Graphical Tools
- Statistical Tools
- Measurement System Analysis
- Process Capability
- Design of Experiments
- Control Charts
- Reliability/Weibull Analysis
- Time Series Forecasting and Control Charts for Autocorrelated Data
SigmaXL Software Features
SigmaXL provides a huge number of features as follows:
-
Data Manipulation
- Subset by Category, Number, Date or Random
- Transpose Data
- Stack Subgroups Across Rows
- Stack and Unstack Columns
- Random Number Generator
- Normal
- Uniform (Continuous & Integer)
- Lognormal
- Weibull
- Triangular
- Box-Cox Transformation
- Standardize Data
- Convert to Discrete
- Data Preparation
- Remove Blank Rows and Columns
- Change Text Data Format to Numeric
- Convert Raw Data to Frequency (Tally)
- Convert Frequency to Raw Data
-
Templates and Calculators
- DMAIC & DFSS Templates
- Team/Project Charter
- SIPOC Diagram
- 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
- Lean Templates
- Takt Time Calculator
- Value Analysis/Process Load Balance
- Value Stream Mapping
- Graphical Templates
- Pareto Chart, Histogram, Run Chart
- Probability Distribution Calculators
- Normal, Lognormal, Exponential, Weibull
- Binomial, Poisson, Hypergeometric
- 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)
- GLM GageRR (Crossed) Metrics with/without Interaction; GLM GageRR (Nested) Metrics; GLM GageRR (Expanded) Metrics
- Orthogonal (Deming) Regression
- 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
- Individuals, C-Chart
- DMAIC & DFSS Templates
-
Graphical Tools
- Graphical Tool Selection Guide
- Basic and Advanced (Multiple) Pareto Charts
- EZ-Pivot/Pivot Charts: Easily create Pivot Tables and Charts
- Heatmap
- 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 Dotplots, Multiple Boxplots, Multiple X Boxplots
- Interval Plots and Multiple X Interval Plots
- Multiple Normal Probability Plots (with 95% confidence intervals to ease interpretation of normality/non-normality)
- Empirical/Normal CDF Plots
- Run Charts (with Nonparametric Runs Test allowing you to test for Clustering, Mixtures, Lack of Randomness, Trends and Oscillation)
- Overlay Run Chart
- Multi-Vari Charts
- Scatter Plots (with linear regression and optional 95% confidence intervals and prediction intervals)
- Scatter Plot Matrix
- XYZ Contour/Surface Plot**
- Automatic Interpolation Method Selection and XY Standardization using Cross-Validation
- Inverse Distance, Akima’s Polynomial and Biharmonic Spline Interpolation
- Analysis of Means (ANOM) Charts
- ANOM Normal One-Way
- ANOM Normal Two-Way (with Main Effects and Slice Charts)
- ANOM Binomial Proportions One-Way
- ANOM Binomial Proportions Two-Way
- ANOM Poisson Rate One-Way
- ANOM Poisson Rate Two-Way
- Nonparametric Transformed Ranks
- Variances & Levene Robust Variances
-
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
- Hypothesis Test Selection Guide**
- 1 Sample t-test and Confidence Intervals
- Paired t-test, 2 Sample t-test
- 2 Sample comparison tests:
- Reports AD Normality, F-test and Levene's for variance, t-test assuming equal and unequal variance, Mann-Whitney test for medians
- Recommended tests are highlighted based on sample size, normality, and variance
- 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
- General Linear Model: Extends Advanced Multiple Regression to include:
- Fixed and Random Factors
- Nested Factors
- Covariates (can be Nested)
- For Random or Mixed Random/Fixed Factors with a balanced design, the ANOVA and Variance Components (VC) report is given based on Expected Mean Squares. VC confidence intervals using Restricted Maximum Likelihood (REML) are included.
- If the design is unbalanced or model is non-hierarchical, REML is used to compute the VC values and confidence intervals. Fixed Effects Tests are based on Satterthwaite approximation degrees of freedom.
- Main Effects with Confidence Intervals and Interaction Plots of Fitted Means for Non-Nested Fixed Factors
- Tukey and Fisher Pairwise Comparison of Means for Non-Nested Fixed Factors
- Predicted Response Calculator
- Multiple Response Optimization for Nested or Non-Nested Fixed Factors
- Advanced Multiple Regression:
- Standardization and coding of continuous predictors
- Option to display regression equation with unstandardized coefficients
- (1, 0) or (-1,0,+1) coding of categorical predictors
- Box-Cox Transformation
- Specify confidence level
- Residual Plots (Regular, Standardized, Studentized – Deleted t)
- Main Effects and Interaction Plots (Fitted Means)
- Contour and Surface Plots
- Optimization with optional constraints
- Automatic removal of extreme VIF or collinear terms (with alias and removal report)
- Specify interactions, quadratic and higher orders (all interactions or up to 3-Way)
- ANOVA Type I and/or Type III Sum-of-Squares with Pareto of Percent Contribution and Standardized Effects
- Lenth Pseudo Standard Error for Saturated Models (Orthogonal or Non-Orthogonal) with Monte Carlo or Student T P-Values
- Specify Test/Withhold Sample for R-square Test & StDev Test Validation
- R-Square Predicted (Leave-One-Out Cross Validation)
- R-Square K-Fold & StDev K-Fold (K-Fold Cross Validation)
- Test for Constant Variance: Breusch-Pagan. Anderson-Darling Normality test is applied to residuals in order to automatically select
- Normal or Koenker (Robust) version. Report includes the Overall test and Individual predictors as well.
- White robust standard errors for non-constant variance (Heteroskedasticity-Consistent)
- Durbin-Watson test for autocorrelation in residuals with P-Values
- Newey-West robust standard errors for non-constant variance with autocorrelation (Heteroskedasticity and Autocorrelation-Consistent)
- White or Newey-West automatically selected based on Durbin-Watson P-Values
- Stepwise/Best Subsets Regression:
- Forward/Backward with alpha-to-enter, alpha-to-remove
- Forward Selection with alpha-to-enter
- Backward Elimination with alpha-to-remove
- Forward, Backward Criterion: Minimize AICc, BIC; Maximize R-Square Adjusted, R-Square Predicted, R-Square K-Fold
- Best Subsets utilizes the powerful MIDACO Solver (Mixed Integer Distributed Ant Colony Optimization) to solve best subsets with upto hundreds of continuous or categorical variables, including interactions and higher order terms. This feature gives SigmaXL a significant advantage over competitors with Best Subsets limited to 30 continuous variables.
- Best Subsets Criterion: Minimize AICc, BIC; Maximize R-Square Adjusted
- Hierarchical option
- Detailed report with additional statistics such as Condition Number and Mallows’ Cp.
- Multiple Response Optimization:
- Multiple Response Optimization with Desirability
- Multistart Nelder-Mead Simplex
- MIDACO
- Multiple Response Optimization with Desirability
- Multiple Linear Regression:
- 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
- Binary and Ordinal Logistic Regression:
- 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
- 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:
- 1 Sample Wilcoxon - Exact
- 2 Sample Mann-Whitney - Exact
- Kruskal-Wallis Median Test - Test
- Mood's Median Test - Test
- Runs Test - 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
-
Measurement System 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, Ordinal, Nominal)
- Attribute MSA (Binary)
- Attribute MSA (Ordinal)
- Attribute MSA (Nominal)
- Create Gage R&R (Crossed) Worksheet:
-
Process Capability
- 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
- Distribution Fitting Report
- All valid distributions and transformations reported with histograms, curve fit and probability plots
- Sorted by AD P-value
- 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)
-
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
- Basic DOE Templates
- 2 to 5 Factors, 2-Level Full and Fractional-Factorial designs
- Automatic update to Pareto of Coefficients
- Easy to use, ideal for training
- Main Effects & Interaction Plots
- Contour & 3D Surface Plots
- Response Surface Designs
- 2 to 5 Factors
- Central Composite and Box-Behnken Designs
- Easy to use design selection sorted by number of runs
- Analyze 2-Level Factorial and Plackett-Burman Screening Designs
- 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
- Generate 2-Level Factorial and Plackett-Burman Screening Designs
-
Control Charts
- Control Chart Selection Guide
- 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
- Rare Events T Chart
- Rare Events G Chart
- Rare Events Prob G Chart
- Control Chart Templates: Time-Weighted
- Exponentially Weighted Moving Average (EWMA) Chart
- Tabular Cumulative Sum (CUSUM) Chart
- Control Chart Templates: Trend
- Trend Chart
- Control Chart Templates: Average Run Length (ARL) Calculators
- Average Run Length (ARL)
- Shewhart ARL
- Attribute P ARL
- Attribute C ARL
- EWMA ARL
- CUSUM ARL
-
Reliability/Weibull Analysis
- Weibull Analysis
- Complete and Right Censored data
- Least Squares and Maximum Likelihood
- Output includes percentiles with confidence intervals, survival probabilities, and Weibull probability plot
- Weibull Analysis
-
- Autocorrelation (ACF/PACF) Plots
- Cross Correlation (CCF) Plots
- Spectral Density Plot
- Seasonal Trend Decomposition Plots
- Seasonal Interaction 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
SigmaXL Software Dealer/Reseller
Factonity Systems Pvt Ltd is a full service dealer & reseller of SigmaXL softwares. Apart from software licensing, we also provide authentic SigmaXL training, local technical support and statistical consulting.
Please contact us for:
- Latest SigmaXL pricing information / quotation
- Demo of SigmaXL software and free initial consultation
- Lean Six Sigma + SigmaXL bundled training with licensed of demo software
- Post sales local technical support
Who uses SigmaXL Software?
SigmaXL finds application in both industrial and academic settings. It addresses the statistical analysis and visualization requirements of a diverse range of individuals, spanning from complete novices to experienced analytics professionals and Six Sigma black belts.
Do I need to be a statistical expert to use SigmaXL software?
Certainly not! Regardless of your expertise in statistics, SigmaXL simplifies the process of learning statistics by directing users' attention towards the analysis outcomes and the influence of these outcomes on real-world business scenarios. This approach saves users from investing time in mastering formulas and conducting intricate statistical computations.
SigmaXL is designed to:
- Assist newcomers in choosing appropriate tools
- Lead users through every stage of the analysis process
- Aid in understanding and showcasing the obtained outcomes.
Which industries use SigmaXL software?
SigmaXL software is employed by leading enterprises to scrutinize their data, enhance operational procedures, gain profound insights, devise experiments, and resolve some of the most challenging issues. Here are several sectors/industries that make use of SigmaXL::