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

Pub Type

Conferences

Citation

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