Uncertainty Arithmetic on Excel Spreadsheets: Add-In for Intervals, Probability Distributions, and Probability Boxes

التفاصيل البيبلوغرافية
العنوان: Uncertainty Arithmetic on Excel Spreadsheets: Add-In for Intervals, Probability Distributions, and Probability Boxes
المؤلفون: William L. McGill, Scott Ferson, James Mickley
المصدر: Vulnerability, Uncertainty, and Risk.
بيانات النشر: American Society of Civil Engineers, 2011.
سنة النشر: 2011
مصطلحات موضوعية: Software, Numeric precision in Microsoft Excel, Theoretical computer science, Syntax (programming languages), business.industry, Computer science, Computation, Scalar (physics), Probability distribution, Function overloading, Arithmetic, business, Argument of a function
الوصف: Despite their limitations as a platform for calculations, Microsoft Excel spreadsheets enjoy widespread use throughout much of engineering and science, and they have emerged as a lingua franca for computations in some quarters. Given their ubiquity, it would be useful if Excel spreadsheets could express uncertainty in inputs and propagate uncertainty through calculations. We describe an add-in for Microsoft Excel that supports arithmetic on uncertain numbers, which include intervals, probability distributions, and p-boxes (i.e., bounds on probability distributions). The software enables native calculations in Excel with these objects and ordinary scalar (real) numbers. The add-in supports basic arithmetic operations (+, , /, +, ^, min, max), standard mathematical functions (exp, sqrt, atan, etc.), and Excel-style cell referencing for both function arguments and uncertain number results. Graphical depictions of uncertain numbers are created automatically. Using function overloading, the standard Excel syntax is extended for uncertain numbers so that the software conducts uncertainty analyses almost automatically and does not require users to learn entirely new conventions or special-purpose techniques.
DOI: 10.1061/41170(400)9
URL الوصول: https://explore.openaire.eu/search/publication?articleId=doi_________::72ee8da33b38a62e2b0e7aa492aacaab
https://doi.org/10.1061/41170(400)9
رقم الانضمام: edsair.doi...........72ee8da33b38a62e2b0e7aa492aacaab
قاعدة البيانات: OpenAIRE