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

Introduces uncertainty quantification techniques to professionals, researchers and students who use Excel as a computational tool Applies methods such as linear and nonlinear programming, multi-objective optimization, and game theory to economics, business administration, and civil engineering Offers a selection of numerical methods developed specifically for Excel

Autorentext

Eduardo Souza De Cursi is a professor at the National Institute for Applied Sciences (INSA) in Rouen, France, where he serves as Dean of International Affairs and Director of the Laboratory of Mechanics of Normandy. He is also the Editor-in-Chief of "Computational and Applied Mathematics", a journal of the Brazilian Society of Computational and Applied Mathematics that is published with Springer. Prof. De Cursi holds a PhD in Sciences/Mathematics from the Université des Sciences et Techniques Du Languedoc, USTL, France, and has over 35 years' experience in research, teaching and technology transfer.

Inhalt

Chapter 1: Some tips to use EXCEL.- Chapter 2: Some useful Numerical Methods.- Chapter 3: Probabilities with EXCEL.- Chapter 4: Stochastic Processes.- Chapter 5: Representation of Random Variables.- Chapter 6: Uncertain Algebraic Equations.- Chapter 7: Random Differential Equations.- Chapter 8: UQ in Game Theory.- Chapter 9: Optimization under uncertainty.- Chapter 10: Reliability.- Bibliography.- Index.