PO.RES.MC.Percentiles


Description

Summarises a column of Monte Carlo outcomes (STOIIP, GIIP, recoverable volume, NPV) in the petroleum convention: P90 is the low estimate, the value exceeded with 90% probability; P50 the median; P10 the high estimate, exceeded with 10% probability; and the mean. Returns four cells in a row: {P90, P50, P10, mean}, in the unit of the outcomes.

Formula

=LAMBDA(X, HSTACK(PERCENTILE.INC(X, 0.1), PERCENTILE.INC(X, 0.5), PERCENTILE.INC(X, 0.9), AVERAGE(X)))

Parameters

Parameter Unit Description
X outcome unit The outcomes, one column (or any range or array of numbers)

Examples

Invocation Expected
=PO.RES.MC.Percentiles({3;1;4;1;5;9;2;6;5;3}) [1, 3.5, 6.3, 3.9]
=PO.RES.MC.Percentiles({12;7;30;18}) [8.5, 15, 26.4, 16.75]
=PO.RES.MC.Percentiles(SEQUENCE(1000)) [100.9, 500.5, 900.1, 500.5]

Need a custom LAMBDA? Suggest a New Lambda