SigmaXLDemonstration(共35页).ppt

1、Why SigmaXL? Powerful. User-Friendly. Cost-Effective. Priced at just $199 this tool will pay for itself on the first day of use! Quantity, Educational, and Training discounts are available.Why SigmaXL? Measure, Analyze, and Control your Manufacturing, Service, or Transactional Process. An add-in to

2、the already familiar Microsoft Excel, making it a great tool for Six Sigma training. Used by Motorola University and other leading providers. SigmaXL is rapidly becoming the tool of choice for Quality and Business Professionals.Data Manipulation Category Subsetting Numerical Subsetting Date Subsetti

3、ng Stack/Unstack Columns Normal Random Data GenerationTemplates & Calculators Cause & Effect (XY) Matrix Failure Mode & Effects Analysis (FMEA) Basic DOE Templates Sample Size Discrete & Continuous Gage R&R Attribute Agreement Analysis Process Sigma Discrete & Continuous Proc

4、ess Capability & Confidence Intervals 2 Proportions TestFailure Mode & Effects Analysis (FMEA)Basic DOE TemplatesSample Size CalculatorsProcess Sigma CalculatorsGage R&R TemplateTwo-Proportions TestGraphical Tools Basic & Advanced (Multiple) Pareto Charts Multiple Histograms & De

5、scriptive Statistics Multiple Histograms & Process Capability Multiple Boxplots Run Charts Normal Probability Plots Multi-Vari Charts Scatterplots Scatterplot MatrixMultiple Pareto ChartsMultiple Histograms & Descriptive StatisticsMultiple Histograms & Process CapabilityMultiple Boxplots

6、Multiple Normal Probability PlotsMulti-Vari ChartsMultiple Scatterplots with Linear RegressionScatterplot MatrixStatistical Tools Descriptive Statistics 1 Sample t-Test & Confidence Intervals Paired t-Test 2 Sample t-Test 2 Sample Comparison Tests Normality, Mean, Variance, Median Yellow Highlig

7、ht to aid Interpretation Means Matrix & One-Way ANOVA Kruskal-Wallis Medians Test Correlation Matrix Multiple Regression Chi-Square TestTwo-Sample Comparison TestsMeans Matrix & One-Way ANOVACorrelation MatrixMultiple Regression with Residual PlotsMultiple Regression with Residual PlotsChi-S

8、quare TestControl Charts Individuals Individuals & Moving Range X-bar & R X-bar & S P, NP, C, U I-MR-R (Between/Within) I-MR-S (Between/Within) Tests for Special Causes Process Capability Report (Short-Term/Long-Term) Add Data to Existing Charts Optional: Real Time Data Acquisition via S

9、erial PortIndividuals & Moving Range Charts32.58Mean CL: 49.0265.4629.3234.3239.3244.3249.3254.3259.3264.3269.3213579111315171921232527293133353739414345474951535557596163656769717375777981838587899193959799Individuals - Avg days Order to delivery time0.000006.1818220.196000.005.0010.0015.0020.0025.001MR - Avg days Order to delivery timeX-bar & R/S ChartsI-MR-R/S Charts (Between/Within)Use Historical Limits; Flag Special CausesSummary Report on Tests for Special CausesSigmaXL Shop Floor Optional Module: Real-Time