How do I find uncertainty?

  • Thread starter Thread starter Vagus
  • Start date Start date
V

Vagus

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make a Line Chart with shaded uncertainty band 2
Excel 2002 Analysis ToolPak Regression Analysis Help Requested 1
Conditional Formatting 3
Creat Schedule 1
How do I mass update formulas? 5
How do I make a single header/footer common across all worksheets? 1
convert worksheet to database 1
Weighed average if the adjecent column contains blanks 2

Back
Top