Skip to main content
U.S. flag

An official website of the United States government

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

Open-Source Excel Tools For Statistical Metrology

Author(s)

Hung-Kung Liu, William F. Guthrie, Juan Soto

Abstract

In this paper we introduce an approach to construct statistical metrology tools with a Microsoft Excel based interface that use the open source statistical package R as the computational engine. These metrology tools will enable Excel users to access a larger array of specialized statistical tools for metrology. We will describe our general approach and demonstrate one tool - an automated uncertainty calculator. This uncertainty calculator provides users with a simple and flexible tool for estimating measurement uncertainty using the methods outlined in the ISO Guide to the Expression of Uncertainty in Measurement, popularly known as the ISO GUM. The uncertainty calculator is easy for scientists who are comfortable with spreadsheets to use, can handle a variety of typical correlation structures, and performs a validity check on the results by simulating the coverage probabilities actually attained by the uncertainty intervals.
Proceedings Title
IMEKO Conference Proceedings
Conference Title
XVIII IMEKO World Congress

Citation

Liu, H. , Guthrie, W. and Soto, J. (1970), Open-Source Excel Tools For Statistical Metrology, IMEKO Conference Proceedings (Accessed June 20, 2024)

Issues

If you have any questions about this publication or are having problems accessing it, please contact reflib@nist.gov.

Created August 26, 2016, Updated February 17, 2017