How Can You Fix the Process and Improve Product Development with Simulated Data? See All the Scenarios with Monte Carlo

Minitab Blog Editor | 05 April, 2018

Topics: Monte Carlo Simulation, Project Tools, Statistics, Quality Improvement, Minitab Engage

How do you commit to realistic forecasts and timelines when resources are limited or gathering real data is too expensive or impractical? Can simulated data be trusted for accurate predictions? That’s when Monte Carlo Simulation comes in.  

Simulated data actually is routinely used in situations where resources are limited or gathering real data would be too expensive or impractical though. Monte Carlo simulation is a mathematical modeling technique that allows you to see all possible outcomes and assess risk to make data-driven decisions. Historical data is ran through a large number of random computerized simulations that project the probable outcomes of future projects under similar circumstances.

Minitab Engage is a software platform that combines a desktop app for executing quality projects with a web dashboard that makes reporting on your entire quality initiative literally effortless. Among the first-in-class tools in the desktop app is a Monte Carlo simulation tool that makes this method extremely accessible. 

The Monte Carlo method uses repeated random sampling to generate simulated data to use with a mathematical model. This model often comes from a statistical analysis, such as a designed experiment or a regression analysis

Suppose you study a process and use statistics to model it like this:

Regression equation for the process

With this type of linear model, you can enter the process input values into the equation and predict the process output. However, in the real world, the input values won’t be a single value thanks to variability.

Unfortunately, this input variability causes variability and defects in the output.

Design a better process while taking uncertainty into account

To design a better process, you could collect a mountain of data to determine how input variability relates to output variability under a variety of conditions. However, if you understand the typical distribution of the input values and you have an equation that models the process, you can easily generate a vast amount of simulated input values and enter them into the process equation to produce a simulated distribution of the process outputs.

You can also easily change these input distributions to answer "what if" types of questions. That's what Monte Carlo simulation is all about. In the example we are about to work through using Minitab Engage, we'll change both the mean and standard deviation of the simulated data to improve the quality of a product.

 

Step-by-Step Example of Monte Carlo Simulation using Minitab Engage

A materials engineer for a building products manufacturer is developing a new insulation product.

The engineer performed an experiment and used statistics to analyze process factors that could impact the insulating effectiveness of the product. For this Monte Carlo simulation example, we’ll use the regression equation shown above, which describes the statistically significant factors involved in the process.

Software like Minitab Engage and Minitab Workspace can give you the ability to  create a Failure Modes and Effects Analysis (FMEA). Talk to Minitab to learn  more.

Step 1: Define the Process Inputs and Outputs

The first thing we need to do is to define the inputs and the distribution of their values.

The process inputs are listed in the regression output and the engineer is familiar with the typical mean and standard deviation of each variable. For the output, they can copy and paste the regression equation that describes the process from Minitab Statistical Software into Engage's Monte Carlo tool.

It's an easy matter to enter the information about the inputs and outputs for the process as shown.

Defining the Monte Carlo Simulation model

Verify your model and then you can run a simulation (Engage very quickly runs 50,000 simulations by default, but you can specify a higher or lower number). 

Monte Carlo Simulation Results

Engage interprets the results for you using output that is typical for capability analysis — a capability histogram, percentage of defects, and the Ppk statistic. It correctly points out that our Ppk is below the generally accepted minimum value.

Engage didn’t only run the simulation and then let you figure what to do next – it determined that our process is not satisfactory and presented a smart sequence of steps to improve the process capability.

It also knows that it is generally easier to control the mean than the variability. Therefore, the next step that Engage presents is Parameter Optimization, which finds the mean settings that minimize the number of defects while still accounting for input variability.

Monte Carlo simulation next steps - parameter optimization

 

Step 2: Define the Objective and Search Range for Parameter Optimization

At this stage, we want Engage to find an optimal combination of mean input settings to minimize defects. You can use Parameter Optimization to specify your goal and use your process knowledge to define a reasonable search range for the input variables.

Define the Monte Carlo simulation's reasonable search range for the input variables

 

And, here are the simulation results.

Parameter Optimization results

At a glance, we can tell that the percentage of defects is down. We can also see the optimal input settings in the table. However, our Ppk statistic is still below the generally accepted minimum value. Fortunately, Engage has a recommended next step to further improve the capability of our process.

Recommended next step: Sensitivity analysis

 

Step 3: Control the Variability to Perform a Sensitivity Analysis

So far, we've improved the process by optimizing the mean input settings. That reduced defects greatly, but we still have more to do in the Monte Carlo simulation. Now, we need to reduce the variability in the process inputs to further reduce defects.

Reducing variability is typically more difficult. Consequently, you don't want to waste resources controlling the standard deviation for inputs that won't reduce the number defects. Fortunately, Engage includes an innovative graph that helps you identify the inputs where controlling the variability will produce the largest reductions in defects.

Sensitivity Analysis for Insulation

 

In this graph, look for inputs with sloped lines because reducing these standard deviations can reduce the variability in the output. Conversely, you can ease tolerances for inputs with a flat line because they don't affect the variability in the output.

In our graph, the slopes are fairly equal. Consequently, we'll try reducing the standard deviations of several inputs. You'll need to use process knowledge to identify realistic reductions. To change a setting, you can either click the points on the lines, or use the pull-down menu in the table.

 

Final Monte Carlo Simulation Results

Sensitivity Analysis results

Success! We've reduced the number of defects in our process and our Ppk statistic is 1.34, which is above the benchmark value. The assumptions table shows us the new settings and standard deviations for the process inputs that we should try. If we ran Parameter Optimization again, it would center the process and I'm sure we'd have even fewer defects.

Plus, all this was done without collecting any further data, because we know the typical distribution of the input values and have an equation that models the process.

 


Want to learn more about Monte Carlo simulation? Walk through an example predicting process capability and identifying the best strategy to determine optimal process settings using parameter optimization and sensitivity analysis in the on-demand webinar Seeing the Unknown: Identifying Risk and Quantifying Probability with Monte Carlo Simulation