Uncertainty Quantification and Stochastic Modelling with EXCEL

English | 2022 | ISBN: 3030777561 | 536 pages | True PDF EPUB | 165.54 MB
This book presents techniques for determining uncertainties in numerical solutions with applications in the fields of business administration, civil engineering, and economics, using Excel as a computational tool. Also included are solutions to uncertainty problems involving stochastic methods. The list of topics specially covered in this volume includes linear and nonlinear programming, Lagrange multipliers (for sensitivity), multi objective optimization, and Game Theory, as well as linear algebraic equations, and probability and statistics. The book also provides a selection of numerical methods developed for Excel, in order to enhance readers' understanding. As such, it offers a valuable guide for all graduate and undergraduate students in the fields of economics, business administration, civil engineering, and others that rely on Excel as a research tool.