This video demonstrates the simulation data analysis and reporting features of Simulation Master. Simulation Master is an Excel add-in for Monte Carlo simulation. For more information, please visit the Simulation Master product page.
Probability analysis of an existing simulation data set.
Create a summary report of an existing simulation data set.
Create a correlation report.
Create scatter plots of inputs vs. output.
This video demonstrates how to analyze data from a previous simulation using Simulation Master. We’ll also cover how to create a correlation report and scatter plots of input variables vs. output variables.
Analyze Existing Data Set
So let’s assume we’ve already run a simulation and saved the data. We can analyze probabilities and create a summary report by clicking the analyze existing data button on the ribbon.
First enter data bin information. Then select a data sheet from the drop down box.
The simulation statistics and histogram will appear.
To determine the probability of the output being greater than or equal to X, enter X in the upper limit box and click update.
To determine the probability of a range, enter the lower and upper range values and click update. The probabilities inside and outside the range will be shown.
Create a Report
A summary report can be created by clicking the Create Report button. The report will be created on a new worksheet.
A correlation report containing the Pearson and Rank correlation coefficients of each input variable with output variable can be created by clicking the Correlation Report button on the ribbon. The report will be created on a new worksheet.
Select a simulation data sheet in the drop down box. Then select the input variables to include in the report.
Tornado charts of the correlation coefficients can also be included.
We can also create scatter plots of inputs vs. output by clicking the scatter plots button on the ribbon. The scatter plots will be created on a new worksheet.
Select a simulation data sheet in the drop down box. Then select the input variables to plot.
Excel is a registered trademark of Microsoft Corporation. Used with permission from Microsoft.