Excel VBA, solver, and other advanced worksheet tools
Abstract
In general, there are two ways in which Excel is used within the book. One way is to use Excel typically as a calculator, with all the Excel built-in functions already available. The other way is to use Excel as an optimizer, and this will be used massively within the book, since the mathematical economics essentially deals with the static and the dynamic optimization problems. For example, the Linear Algebra will use the Excel mainly as a calculator rather than an optimizer, while in the Calculus of Variations and the Theory of Optimal Control using the Solver as optimizer is of key importance. Also, the VBA macros implemented here are mainly iterative procedures ...
Get Elements of Numerical Mathematical Economics with Excel now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
