1 / 105

Introducing SigmaXL ® Version 6

Introducing SigmaXL ® Version 6. Powerful. User-Friendly. Cost-Effective. Priced at $249, SigmaXL is a fraction of the cost of any major statistical product, yet it has all the functionality most professionals need. Quantity, Educational, and Training discounts are available.

lane
Download Presentation

Introducing SigmaXL ® Version 6

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Introducing SigmaXL® Version 6 • Powerful. • User-Friendly. • Cost-Effective. Priced at $249, SigmaXL is a fraction of the cost of any major statistical product, yet it has all the functionality most professionals need. • Quantity, Educational, and Training discounts are available. • Visit www.SigmaXL.com or call 1-888-SigmaXL (1-888-744-6295) for more information.

  2. Why SigmaXL? • Measure, Analyze, and Control your Manufacturing, Service, or Transactional Process. • An add-in to the already familiar Microsoft Excel, making it a great tool for Lean Six Sigma training. Used by Motorola University and other leading consultants. • SigmaXL is rapidly becoming the tool of choice for Quality and Business Professionals.

  3. What’s Unique to SigmaXL? • User-friendly Design of Experiments with “view power analysis as you design”. • Measurement Systems Analysis with Confidence Intervals. • Two-sample comparison test - automatically tests for normality, equal variance, means, and medians, and provides a rules-based yellow highlight to aid the user in interpretation of the output. • Low p-values are highlighted in red indicating that results are significant.

  4. What’s Unique to SigmaXL? • Powerful Excel Worksheet Manager • List all open Excel workbooks • Display all worksheets and chart sheets in selected workbook • Quickly select worksheet or chart sheet of interest • Process Capability and Control Charts for Nonnormal data • Best fit automatically selects the best distribution or transformation! • Nonnormal Process Capability Indices include Pp, Ppk, Cp, and Cpk • Box-Cox Transformation with Threshold so that data with zero or negative values can be transformed!

  5. Recall Last Dialog • Recall SigmaXL Dialog • This will activate the last data worksheet and recall the last dialog, making it very easy to do repetitive analysis. • Activate Last Worksheet • This will activate the last data worksheet used without recalling the dialog.

  6. Worksheet Manager • List all open Excel workbooks • Display all worksheets and chart sheets in selected workbook • Quickly select worksheet or chart sheet of interest

  7. Recall Last Dialog • Recall SigmaXL Dialog • This will activate the last data worksheet and recall the last dialog, making it very easy to do repetitive analysis. • Activate Last Worksheet • This will activate the last data worksheet used without recalling the dialog.

  8. Data Manipulation • Subset by Category, Number, or Date • Random Subset • Stack and Unstack Columns • Stack Subgroups Across Rows • Standardize Data • Random Number Generators • Normal, Uniform (Continuous & Integer), Lognormal, Exponential, Weibull and Triangular. • Box-Cox Transformation

  9. Templates & Calculators • DMAIC & DFSS Templates: • Team/Project Charter • SIPOC Diagram • Flowchart Toolbar • Data Measurement Plan • Cause & Effect (Fishbone) Diagram and Quick Template • Cause & Effect (XY) Matrix • Failure Mode & Effects Analysis (FMEA) • Quality Function Deployment (QFD) • Pugh Concept Selection Matrix • Control Plan

  10. Templates & Calculators • Lean Templates: • Takt Time Calculator • Value Analysis/Process Load Balance • Value Stream Mapping • Basic Graphical Templates: • Pareto Chart • Histogram • Run Chart

  11. Templates & Calculators • Basic Statistical Templates: • 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 • Probability Distribution Calculators: • Normal, Lognormal, Exponential, Weibull • Binomial, Poisson, Hypergeometric

  12. Templates & Calculators • Basic MSA Templates: • Gage R&R Study – with Multi-Vari Analysis • Attribute Gage R&R (Attribute Agreement Analysis) • Basic Process Capability Templates: • Process Sigma Level – Discrete and Continuous • Process Capability & Confidence Intervals • Basic DOE Templates: • 2 to 5 Factors • 2-Level Full and Fractional-Factorial designs • Main Effects & Interaction Plots • Basic Control Chart Templates: • Individuals • C-Chart

  13. Templates & Calculators: Cause & Effect Diagram

  14. Templates & Calculators: Quality Function Deployment (QFD)

  15. Templates & Calculators: Pugh Concept Selection Matrix

  16. Templates & Calculators: Lean Takt Time Calculator

  17. Templates & Calculators: Value Analysis/Process Load Balance Chart

  18. Templates & Calculators: Value Stream Mapping

  19. Templates & Calculators: Pareto Chart Quick Template

  20. Templates & Calculators: Failure Mode & Effects Analysis (FMEA)

  21. Templates & Calculators: Cause & Effect (XY) Matrix

  22. Templates & Calculators: Sample Size Calculators

  23. Templates & Calculators: Sample Size Calculators

  24. Templates & Calculators: Process Sigma Level – Discrete

  25. Templates & Calculators: Process Sigma Level – Continuous

  26. Templates & Calculators: Two-Proportions Test & Fisher’s Exact

  27. Templates & Calculators: Normal Distribution Probability Calculator

  28. Graphical Tools • Basic and Advanced (Multiple) Pareto Charts • EZ-Pivot/Pivot Charts • Run Charts (with Nonparametric Runs Test allowing you to test for Clustering, Mixtures, Lack of Randomness, Trends and Oscillation.) • Basic Histogram • Multiple Histograms and Descriptive Statistics (includes Confidence Interval for Mean and StDev., as well as Anderson-Darling Normality Test) • Multiple Histograms and Process Capability (Pp, Ppk, Cpm, ppm, %)

  29. Graphical Tools • Multiple Boxplots and Dotplots • 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

  30. Graphical Tools: Multiple Pareto Charts

  31. Graphical Tools: EZ-Pivot/Pivot Charts – The power of Excel’s Pivot Table and Charts are now easy to use!

  32. Graphical Tools:Multiple Histograms & Descriptive Statistics

  33. Graphical Tools:Multiple Histograms & Process Capability

  34. Graphical Tools: Multiple Boxplots

  35. Graphical Tools:Run Charts with Nonparametric Runs Test

  36. Graphical Tools:Multiple Normal Probability Plots

  37. Graphical Tools:Multi-Vari Charts

  38. Graphical Tools:Multiple Scatterplots with Linear Regression Linear Regression with 95% Confidence Interval and Prediction Interval

  39. Graphical Tools: Scatterplot Matrix

  40. 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 • 1 Sample t-test and confidence intervals • Paired t-test, 2 Sample t-test • 2 Sample Comparison Tests • Normality, Mean, Variance, Median • Yellow Highlight to aid Interpretation

  41. Statistical Tools • One-Way ANOVA and Means Matrix • Two-Way ANOVA • Balanced and Unbalanced • Equal Variance Tests: • Bartlett • Levene • Welch’s ANOVA • Correlation Matrix • Pearson’s Correlation Coefficient • Spearman’s Rank

  42. Statistical Tools • Multiple Linear Regression • Binary and Ordinal Logistic Regression • Chi-Square Test (Stacked Column data and Two-Way Table data) • Nonparametric Tests • Power and Sample Size Calculators • Power and Sample Size Charts

  43. Statistical Tools: Two-Sample Comparison Tests P-values turn red when results are significant! Rules based yellow highlight to aid interpretation!

  44. Statistical Tools: One-Way ANOVA & Means Matrix

  45. Statistical Tools: Correlation Matrix

  46. Statistical Tools: Multiple Linear Regression • Accepts continuous and/or categorical (discrete) predictors. • Categorical Predictors are coded with a 0,1 scheme making the interpretation easier than the -1,0,1 scheme used by competitive products. • Interactive Predicted Response Calculator with 95% Confidence Interval and 95% Prediction Interval.

  47. Statistical Tools: Multiple Linear Regression • Residual plots: histogram, normal probability plot, residuals vs. time, residuals vs. predicted and residuals vs. X factors • Residual types include Regular, Standardized, Studentized • Cook's Distance (Influence), Leverage and DFITS • Highlight of significant outliers in residuals • Durbin-Watson Test for Autocorrelation in Residuals with p-value • Pure Error and Lack-of-fit report • Collinearity Variance Inflation Factor (VIF) and Tolerance report • Fit Intercept is optional

  48. Statistical Tools: Multiple Regression Multiple Regression accepts Continuous and/or Categorical Predictors!

  49. Statistical Tools: Multiple Regression Durbin-Watson Test with p-values for positive and negative autocorrelation!

More Related