| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Uncertainty | Charts and Charting in Excel | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Formula uncertainty | Excel Worksheet Functions | |||
| Despite data existing in Excel 2002 spreadsheet Find doesn't find | Excel Discussion (Misc queries) | |||
| How to make a Line Chart with shaded uncertainty band | Charts and Charting in Excel | |||
Threaded Mode
