The Elsmar Cove Business Systems and Standards Discussion Forums Uncertainty Calculation in Excel - Please review my calculation
 Forum User Name Keep Me Logged In Password
 Register Photo Albums Blogs FAQ Social Groups Calendar Search Today's Posts Mark Forums Read

 Elsmar Cove Forum Visitor Notice(s) It is the start of the Memorial Day holiday weekend in the US so activity in the forum will be slow through the weekend. Since Memorial Day is observed on Monday I expect activity here to be slow through the weekend and on Memorial Day.

# Uncertainty Calculation in Excel - Please review my calculation

 Elsmar XML RSS Feed Monitor the Elsmar Forum Sponsor Links Courtesy Quick Links Links that Cove visitors will find useful in your quest for knowledge: International Standards Bodies - World Wide Standards Bodies International Standards Organization - ISO Standards and Information Quality Digest

Post Number #1
25th August 2010, 05:12 AM
 ghosh1975 Total Posts: 2
Uncertainty Calculation in Excel - Please review my calculation

Hello Experts,

I am working with a Rotameter manufacturing company. we have recently calibrated our Master flow Instruments from a Laboratory.

The said laboratory report I am tabulate in excel but some variation come in decimal in following points.

1) Type A standared Uncertainty 7.84E-02 slpm instead of report says 7.86E-02.
2) Combine Uncertainty 3.09E-03 instead of report says 3.06E-03
3) Effective degree of Freedom 36019 instead of report says 34968

Please find attachment and correct me, if any formula error or this error comes due to number of decimal points hide in report etc.

Regards
Tapas Ghosh
Attached Files: 1. Scan for viruses before using, 2. Please report any 'bad' files by Reporting this post, 3. Use at your Own Risk.
 Uncertainty in Excel.xls (38.0 KB, 546 views)

Post Number #2
25th August 2010, 03:33 PM
 zamclachia Total Posts: 62
Re: Uncertainty Calculation in Excel - Please review my calculation

Quote:
 In Reply to Parent Post by ghosh1975 Hello Experts, 1) Type A standared Uncertainty 7.84E-02 slpm instead of report says 7.86E-02. 2) Combine Uncertainty 3.09E-03 instead of report says 3.06E-03 3) Effective degree of Freedom 36019 instead of report says 34968
Have you looked at the effect of rounding. Where you have used a value of 0.00167 (Cell H6) in the manual calculation, the calculated formula gives you 0.0016723535694697 (Cell H33) which is been used in the final result calculation.
Post Number #3
26th August 2010, 01:18 AM
 ghosh1975 Total Posts: 2
Re: Uncertainty Calculation in Excel - Please review my calculation

Quote:
 In Reply to Parent Post by zamclachia Have you looked at the effect of rounding. Where you have used a value of 0.00167 (Cell H6) in the manual calculation, the calculated formula gives you 0.0016723535694697 (Cell H33) which is been used in the final result calculation.
Yes Sir, you are right.
I have seen this effect, because Cell H6 is the lab report, which I have received as printed format from lab .Cell H33 and all Green color field in both of sheet "REPORT & BUDGET", I have calculate through formula

So please review my formula, and correct me if any error.

I am also assumed the deviation with Lab report and calculate value comes due to rounding effect.

Any one can HELP me that how the column “Sensitivity coefficient” value calculate. Is it comes from Student T Table? If so, please clarify when these values comes negative.

Thanks
Tapas Ghosh

 The Elsmar Cove Business Systems and Standards Discussion Forums Uncertainty Calculation in Excel - Please review my calculation

 Bookmarks

 Visitors Currently Viewing this Thread: 1 (0 Registered Visitors (Members) and 1 Unregistered Guest Visitors)

 Forum Posting Settings You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Emoticons are On [IMG] code is On HTML code is Off Forum Rules

 Similar Discussion Threads Discussion Thread Title Thread Starter Forum Replies Last Post or Poll Vote JAltmann Measurement Uncertainty (MU) 9 8th February 2017 12:38 PM harendrasinhsolanki Measurement Uncertainty (MU) 1 3rd January 2014 03:52 PM NickF Measurement Uncertainty (MU) 3 16th July 2013 08:40 AM raghu_1968 General Measurement Device and Calibration Topics 26 30th August 2011 09:27 AM LenaRuiz General Measurement Device and Calibration Topics 5 20th May 2011 03:42 AM

The time now is 03:25 PM. All times are GMT -4.