SigmaXL DiscoverSim

WHY CHOOSE DISCOVERSIM ?

Excel add-in for Monte Carlo Simulation and Optimization

Easy to use with Six Sigma language - specify Inputs (X's) and Outputs (Y's). Ideal for DFSS, Risk and Project Management.

Powerful - 53 continuous and 10 discrete distributions. Distribution Fitting with Automatic Best Fit, specify correlations between inputs.

Fast - accelerated calculations with Excel spreadsheet interpreter.

Identify important X's with Sensitivity Analysis based on correlation or stepwise regression - includes quadratic terms!

Discover solutions to difficult problems with Global Optimization.

Optimize statistics such as dpm or Ppk and allow for constraints.

DiscoverSim is also bundled with SigmaXL Version 7 for statistical and graphical analysis.

DiscoverSim Version 2.0

DiscoverSim™ Feature List Summary

DiscoverSim™ Version 2.0 Feature List Summary

Introduction to DiscoverSim™, Getting Started Tutorial and DiscoverSim™ Menu & Dialogs

Introduction to Monte Carlo Simulation and Optimization with DiscoverSim™

Components of Uncertainty

Selecting a Distribution

Specifying Truncation Values

Specifying Correlations

Optimization

DiscoverSim™ Getting Started Tutorial

Overview of DiscoverSim™ Menu and Dialogs

DiscoverSim Menu and Options

Create/Edit Input Distributions

Create/Edit Output Response

Copy Cell, Paste Cell, Clear Cells

Model Summary

Run Simulation

Distribution Fitting

Correlations

Optimization Inputs: Controls

Optimization Inputs: Constraints

Run Optimization

DiscoverSim™ Case Studies

Intro To Case Study 1, Basic Profit Simulation

Intro To Case Study 2, Magazine Production Optimization

Intro To Case Study 3, Six Sigma DMAIC Project Portfolio Selection

Intro To Case Study 4, Catapult Variation Reduction

Intro To Case Study 5, Robust New Product Design

Intro To Case Study 6, Multiple Response Optimization and Practical Tolerance Design, References

DiscoverSim™ Appendix: Statistical Details for Distributions and Optimization Methods

Statistical Details for Distributions and Optimization Methods

DiscoverSim™ Engine and Excel Formula Interpreter

Input Distribution Random Number Generation

Input Distribution Correlations

Input Distribution Sampling

Input Distribution Truncation

Optimization Methods

Distribution Fitting - Maximum Likelihood Estimation of Parameters

Summary of Distributions

Custom Distributions