Now launched: Percentiles and Sample Run functions

Feature Pack 2 of Studio 9 Modelling tools includes a set of very useful new functions.


New functions in Feature Pack 2 of Studio 9

In the new Feature Pack, several new functions will be introduced. These functions are available to all customers with a valid SUA.

If you do not have SUA, or not Powersim Studio 9, take advantage of our on-going Campaign to upgrade.

Percentile functions

Previously in Powersim Studio, you could present percentiles in combination with a Risk Analysis. Now a set of new functions allows you to access such functionality within your Simulation as well.

In the time graph below, we have illustrated an example using percentiles. The simulation model runs 15 parallel scenarios. they differ in regards to uncertainties about the severity of unwanted incidents that occur in a workplace. When such incidents occur often, there is a tendency that more incidents happen if the situations are not attended to. 

We have ran 15 scenarios and included a 40th (orange dotted line) and 60th (green dotted line) percentile. The yellow coloured area indicates that there is a likelihood that between 40% to 60% of the simulations will give a result within this area.

The tree new functions for calculation of percentiles all use different algorithms:

  • ARRPERCENTILE uses an algorithm which is referred to as "linear interpolation between closest ranks"
  • ARRPERCENTILINC corresponds to Excel's PERCENTILE.INC and uses an algorithm described by National Institute of Standards and Technology (NIST)
  • ARRPERCENTILEEXC corresponds to Excel's PERCENTILE.EXC and is the primary method recommended by NIST

In addition, you may also choose to use these three methods to calculate percentiles within Risk Analysis or Risk Management.

Sample run function

Under Simulation settings, you may set up a number of runs for your simulation. When you hit the Toggle Play button once, the Simulation loops through all the preset runs. Now our development team has added a function that allows you to collect a variable's value at the end of each run and save it before starting the next run. In fact, you will end up with a vector with as many values as you have number of runs.

In the below Chart you can see on the x-axis the 10 runs from the simulation, and for each run, a resulting Risk Indicator of Incidents. We have used the function RUNINDEX to refer to the actual run number as part of the uncertainty calculation, in this way we can see how sensitive the simulation model is to changes in this factor.

The figure above illustrates the use of SAMPLERUNS. The variable allows you to hold the value of a variable between different runs.

You will notice while using this function that the Dimensions field for such a variable is RUNRANGE, which simply means that this is a Range defined to hold values from 1 until the number of x you have chosen. Maximum number of runs are 1 million.


Copyright Powersim Software AS © 2017 - webmaster@powersim.no