# How to perform and apply Monte Carlo simulation?

Monte Carlo simulation is an extension of statistical analysis where simulated data is produced. This method uses repeated sampling techniques to generate simulated data. For instance, a regression model analyzes the effect of independent variables X_{1 }and X_{2} on dependent variable Y. The regression equation is as follows:

Y = 0.076 + 0.0054X_{1}– 0.72X_{2}

The value of Y can be predicted from the above equation. Moreover, different values of X_{1 }and X_{2} will give different values of Y. Using this procedure helps generate infinite amount of data. This means variability among different values of X_{1} and X_{2} causes variability in its respective values of Y, hence affecting the output. In such cases, Monte Carlo simulation is useful as it simulates the data of X_{1 }and X_{2.} It removes the variability and optimizes the data so that it correctly estimates the value of Y. Therefore, it is broadly a technique to study how a model responds to randomly occurring inputs.

## Process of performing Monte Carlo simulation

There are three main steps in performing Monte Carlo simulation:

- Perform a regression with ‘N’ inputs (observations of X
_{1}and X_{2}). - Run a simulation for each of the ‘N’ inputs. Here simulation refers to the methods to analyze the mean, standard deviation and variance of series X
_{1}and X_{2}and optimize the same to obtain robust Y. - Aggregate and assess the output from the simulations.

## Step by step example of Monte Carlo simulation

In this example first the regression was run. Furthermore, the results from the predicted regression equation were moved to Monto Carlo simulation window (SPPS, Minitab or any other). This article presents Monte Carlo simulation in Minitab software.

When the Monte Carlo simulation window opens, it presents the below given fields:

Here, the model is defined and values of X_{1, }X_{2} and Y are expressed as per the estimated regression equation. Write the estimated regression equation. Also, using parameter optimization choose the appropriate lower and upper limit of mean and variation. This will help generate the value of Y as per those conditions (not present in the image below).

After inserting the values of all variables, click on ‘simulation’. The results will appear in the form of a histogram showing the value of Y with upper limit and lower limit. Here Monte Carlo simulation uses ‘Parameter Optimization’ with minimum mean settings so that number of defects will be minimum. Like in histogram shown in figure below, the value of Y focuses on the mean and carry minimum defects (variability).

## Application of Monte Carlo simulation

Monte Carlo Simulation is useful in probability, mathematical, statistical, physics and financial models. In short, the method is applicable when a variable is expected to be estimated from given random variables based on given equation. It is one of the most popular methods in estimating future stock prices as they follow a random path. Therefore, it can generate thousands and millions of such simulations. Moreover, taking average of these results, one can estimate a reasonable estimation of future stock prices.

## Software supporting Monte Carlo simulation

Software that support Monte Carlo simulation applications are SAS, MATLAB, STATA and SPSS. However, SPSS is less compatible than other software for Monte Carlo simulation. Therefore, other software are more popular for performing the test.

#### References

- Minitab Blog website (n.d.). “Monte Carlo Simulation”. [online]. Available at http://blog.minitab.com/blog/monte-carlo-simulation Last accessed on 6 Oct 2017.

Priya is the co-founder and Managing Partner of Project Guru, a research and analytics firm based in Gurgaon. She is responsible for the human resource planning and operations functions. Her expertise in analytics has been used in a number of service-based industries like education and financial services.

Her foundational educational is from St. Xaviers High School (Mumbai). She also holds MBA degree in Marketing and Finance from the Indian Institute of Planning and Management, Delhi (2008).

Some of the notable projects she has worked on include:

- Using systems thinking to improve sustainability in operations: A study carried out in Malaysia in partnership with Universiti Kuala Lumpur.
- Assessing customer satisfaction with in-house doctors of Jiva Ayurveda (a project executed for the company)
- Predicting the potential impact of green hydrogen microgirds (A project executed for the Government of South Africa)

She is a key contributor to the in-house research platform Knowledge Tank.

She currently holds over 300 citations from her contributions to the platform.

She has also been a guest speaker at various institutes such as JIMS (Delhi), BPIT (Delhi), and SVU (Tirupati).

## Discuss