0 votes

How does openLCA calculate uncertainty values?

The corresponding (ecoinvent) data quality system values are:

I suppose "σg" is the geometric mean. However, MS Excel returns `=GEOMEAN(1.05,1.1,1.5,1.1,1.2)` = 1.179911502.

How do I reproduce the given uncertainty value?

in openLCA by (420 points)

2 Answers

+1 vote
by (530 points)
selected by
Best answer


Check How to interpret the uncertainty fields in ecoinvent?

This helped me when I was stuck with a similar problem. Perhaps, it will help you too. There is also an excel file linked at the bottom of the answer to play around and understand things based on your use case.

Best regards,


by (420 points)
Thank you both for your responses!
+1 vote
by (93.1k points)
Hi, thank you for your question, it is not the mean but the standard deviation, quite some background is provided in our older project report (https://www.greendelta.com/wp-content/uploads/2017/03/Pedigree_report_final_May2012.pdf) - but you are right, we need to take the root of the amount openLCA lists here so far (or, instead, state that this is not sigma_g but the geometric variance) but we rather go for the first option. Therefore, thank you!
by (420 points)
Got it. Thank you!