Histogram Plot

A histogram plot can be created from the Results Viewer Insert ribbon by clicking this icon:

 

The following is an example of a simple histogram plot:

  • Single variable: overlay mode is off (so radio buttons allow selection of only one variable)

  • Using bars, not lines

  • Sliders switched on (the sliders can be dragged left and right to new value positions, or the values edited by clicking in the blue bar areas)

  • Default title (the text and format can be edited directly on screen by right clicking)

  • No legend

The horizontal axis shows the possible value of the variable, and the vertical axis shows the relative likelihood of that value occurring. In technical terms, the probability scale refers to the probability of lying within the range of the relevant bar. In practice, the scale can (and should be) largely ignored – instead focus on what the plot says about the range and most likely value (the location of the peak on the x-axis).

The following is an example of a more complex histogram plot:

  • Multiple variables: overlay mode is on (so check boxes allow selection of multiple variables)
  • Using lines, not bars
  • Sliders switched off
  • Edited title (the title can be edited directly on screen by right clicking)
  • Legend included
  • Mean markers added

The variables to be plotted are selected from the list of inputs and outputs in the windows on the left. Selecting more than one simulation will plot all selected variables together for all selected simulations. When a variable’s name is clicked in either the Inputs or Outputs window, the active cell in Excel will move to display the relevant cell in the model for easy verification that the right variable has been chosen.

The format of the plot can be comprehensively adjusted by clicking on the various control buttons in the Histogram Options tab:
 

 

The following editing tabs are available:

 

ModelRisk

Monte Carlo simulation in Excel. Learn more

Tamara

Adding risk and uncertainty to your project schedule. Learn more

Navigation

FREE MONTE CARLO SIMULATION SOFTWARE

For Microsoft Excel

Download your free copy of ModelRisk Basic today. Professional quality risk modeling software and no catches

Download ModelRisk Basic now

FREE PROJECT RISK SOFTWARE

For Primavera & Microsoft Project

Download your free copy of Tamara Basic today. Professional quality project risk software and no catches.

Download Tamara Basic now
-->