Six Sigma Calculator
developed using the Six Sigma features of @RISK,
software for risk analysis using Monte Carlo simulation

Palisade’s Six Sigma Calculator allows you to create a function that models the performance of a process with uncertain elements. It allows you to include uncertainty around design factors through the use of probability distributions. It was built by Palisade Custom Development using the @RISK Developer’s Kit (RDK) to perform a Monte Carlo simulation so the following process capability metrics can be calculated: Cpk, Cpk Upper, Cpk Lower, Sigma Level, DPM, Cp, Ppk, Pp.

The RDK is Palisade’s widely-used risk analysis programming toolkit. It uses the features and functions of @RISK for Excel - the industry-leading risk analysis tool for spreadsheets. The RDK allows you to build Monte Carlo simulation models in your own applications using Windows and .NET programming languages, such as C, C#, C++, Visual Basic, or Visual Basic .NET. Examples of programs written in Windows and .NET programming languages are provided.

Palisade Custom Development services are used to build tailored applications for individual client needs using @RISK and other technology.

» More about using @RISK for Six Sigma
» More about using @RISK
» Palisade Custom Development

1. Design Factors
You may use up to 5 variables. Each variable can be modeled as a probability distribution. Name the variable, and select a distribution. Then select parameters to describe the distribution. Once done successfully, you will see a button with the name of the variable just above the calculator. For example: We have a system performance described by two variables, A and B. A is normally distributed, with parameters of mean = 10 and std dev = 5, and B is uniformly distributed with parameters of min = 2 and max = 4.
Variable 1 name: Mean Std Dev
Variable 2 name: Mean Std Dev
Variable 3 name: Mean Std Dev
Variable 4 name: Mean Std Dev
Variable 5 name: Mean Std Dev

2. Formula
• Now construct the formula that describes the system performance. Use the calculator buttons to write the formula. You must use at least one of the variables that you constructed above. For example, our formula could be: A * B, or A * 7, or B + 5.
• Click the "Check Formula" button to make sure that the formula was built properly. The "Run Analysis" button will be visible once the formula is validated.
3. Six Sigma Properties
• Select the number of iterations (i.e., 1000).
• Click "Run Analysis" and view results!
Target
LSL
USL
Iterations
(Results will appear below)