templates & calculators
DESCRIPTION
An overview of the Templates and Calculators in SigmaXL Established in 1998, SigmaXL Inc. is a leading provider of user friendly Excel Add-ins for Lean Six Sigma graphical and statistical tools and Monte Carlo simulation. SigmaXL® customers include market leaders like Agilent, Diebold, FedEx, Microsoft, Motorola and Shell. SigmaXL® software is also used by numerous colleges, universities and government agencies. Our flagship product, SigmaXL®, was designed from the ground up to be a cost-effective, powerful, but easy to use tool that enables users to measure, analyze, improve and control their service, transactional, and manufacturing processes. As an add-in to the already familiar Microsoft Excel, SigmaXL® is ideal for Lean Six Sigma training and application, or use in a college statistics course. DiscoverSim™ enables you to quantify your risk through Monte Carlo simulation and minimize your risk with global optimization. Business decisions are often based on assumptions with a single point value estimate or an average, resulting in unexpected outcomes. DiscoverSim™ allows you to model the uncertainty in your inputs so that you know what to expect in your outputs.TRANSCRIPT
Templates & Calculators-
SigmaXL® Version 6.1
Templates and Calculators: Overview
Cause & Effect Diagram & Matrix
Quality Function Deployment (QFD)
Pugh Concept Selection Matrix
Lean Takt Time Calculator
Value Analysis / Process Load Balance
Value Stream Mapping
Pareto Chart Template
Failure Mode & Effects Analysis (FMEA)
Sample Size Calculators
Process Sigma Level – Discrete & Continuous
Two Proportions Test & Fisher’s Exact
Normal Distribution Probability Calculator
Attribute MSA Template
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 Back to
Index
Templates & Calculators
Lean Templates:
Takt Time Calculator
Value Analysis/Process Load Balance
Value Stream Mapping
Basic Graphical Templates:
Pareto Chart
Histogram
Run Chart Back to Index
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 Back to Index
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 Back to Index
Templates & Calculators:
Cause & Effect Diagram
Back to Index
Templates & Calculators:
Cause & Effect (XY)
Matrix
Back to Index
Templates & Calculators:
Quality Function
Deployment (QFD)
Back to Index
Templates & Calculators:
Pugh Concept Selection
Matrix
Back to Index
Templates & Calculators:
Lean Takt Time Calculator
Back to Index
Templates & Calculators:
Value Analysis/
Process Load Balance Chart
Back to Index
Templates & Calculators:
Value Stream Mapping
Back to Index
Templates & Calculators:
Pareto Chart Quick Template
Pareto Chart
0
10
20
30
40
50
60
70
80
90
100
Return
-cal
ls
Difficu
lt-to
-ord
er
Ord
er-ta
kes-
too-
long
Wro
ng-c
olor
Not-ava
ilabl
e
Category
Co
un
t
0%
10%
20%
30%
40%
50%
60%
70%
80%
90%
100%
Back to Index
Templates & Calculators:
Failure Mode & Effects
Analysis (FMEA)
Back to Index
Templates & Calculators:
Sample Size Calculators
Back to Index
Templates & Calculators:
Sample Size Calculators
Back to Index
Templates & Calculators:
Process Sigma Level –
Discrete
Back to Index
Templates & Calculators:
Process Sigma Level –
Continuous
Back to Index
Templates & Calculators:
Two-Proportions Test &
Fisher’s Exact
Back to Index
Templates & Calculators:
Normal Distribution
Probability Calculator
Back to Index
Templates and
Calculators: Attribute
MSA Template
Back to Index