ExcelBanter - How do I find uncertainty?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I find uncertainty? (https://www.excelbanter.com/excel-discussion-misc-queries/178165-how-do-i-find-uncertainty.html)

Vagus

How do I find uncertainty?

hello
I have a problem in calculating the uncertainty (95% ci) of particulate mass
concentration. The weighings of the PM mass have been done 3 times in
different days under same conditions.
I hope you have the solution.

Bernie Deitrick

How do I find uncertainty?

I think something like this

=AVERAGE(A2:A20) +CONFIDENCE(0.05,STDEV(A2:A20),COUNT(A2:A20))
=AVERAGE(A2:A20) -CONFIDENCE(0.05,STDEV(A2:A20),COUNT(A2:A20))

See help on CONFICENCE

HTH,
Bernie
MS Excel MVP

"Vagus" wrote in message
...
hello
I have a problem in calculating the uncertainty (95% ci) of particulate mass
concentration. The weighings of the PM mass have been done 3 times in
different days under same conditions.
I hope you have the solution.

All times are GMT +1. The time now is 10:44 PM.