Calculating percentiles for experiment

Question

question

Tommy Heyser asked Mar 12, '20 Alexander M7 commented Apr 1, '21

Calculating percentiles for experiment

Is there a way to customise the performance measure report to include calculated percentiles, e.g. P10, P50, P90, from the results of an experiment?

The current plan is to take the dataset, e.g. average throughput for each replication in an experiment, and calculate the percentiles separately, but I'm wondering if the performance measure report can do that automatically.

Is the template that FlexSim uses to create the performance measure report something that I can customise? In particular, I'd like to include the percentiles in the summary table.

Software Version:

FlexSim 20.0.3

percentiles

Answer 1 · 2020-03-16T21:32:57Z

Jordan Johnson answered Mar 16, '20 Alexander M7 commented Apr 1, '21

In FlexSim you can query the Performance Measures Table:

SELECT * FROM Experiment.PerformanceMeasures

You can then export this table to Excel, and work with in there.

Within FlexSim, you can use window functions such as NTILE() to put pfms into buckets:

SELECT PFM1, NTILE(10) OVER (ORDER BY PFM1) AS Buckets 
FROM Experiment.PerformanceMeasures
ORDER BY PFM1

· 2

Braydn T commented · Mar 20, 2020 at 01:42 PM

@Tommy Heyser

Did Jordans answer help you? If it did, could you please click accept? If it didn't, could you tell us what else we can do to help you?

0 ·

Alexander M7 commented · Apr 01, 2021 at 07:56 AM

@Jordan Johnson Is it possible to provide a file to demonstrate this solution? I seek to display 95th Percentile values in the Experimenter/Optquest as well! =)

0 ·

question

Calculating percentiles for experiment

1 Answer

Write an Answer

Things to know…

question details