Simplify Uncertainty Analysis With Excel Macros

Richard A. Davis


A simple classroom exercise is used to teach students about the law of propagation of uncertainty in experimental measurements and analysis. Students calculate the density of a rectangular wooden block with a hole from several measurements of mass and length using a ruler and scale. The ruler and scale give students experience with estimating fixed uncertainties from analog and digital instruments. The analysis is simplified using VBA macros in an Excel workbook that students create as a template for uncertainty analysis.

Full Text:



  • There are currently no refbacks.

The Florida OJ service is provided through the Florida Virtual Campus (FLVC), the Florida Academic Library Services Cooperative (FALSC), and the George A. Smathers Libraries. | FLVC Privacy Policy.