Description
Book SynopsisThis 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.
Table of ContentsChapter 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.
