Uncertainty Quantification and Stochastic Modelling with EXCEL

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...

Full description

Bibliographic Details
Main Author: Souza de Cursi, Eduardo
Format: eBook
Language:English
Published: Cham Springer International Publishing 2022, 2022
Edition:1st ed. 2022
Series:Springer Texts in Business and Economics
Subjects:
Online Access:
Collection: Springer eBooks 2005- - Collection details see MPG.ReNa
Description
Summary: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
Physical Description:XI, 531 p. 765 illus., 600 illus. in color online resource
ISBN:9783030777579