Mathematical Modeling with Excel, Second Edition, presents a wide variety of common types of models found in other mathematical modeling texts, as well as some new types. However, the models are presented in a very unique format. A typical section begins with a general description of the scenario being modeled. The model is then built using the appropriate mathematical tools. Then it is implemented and analyzed in Excel via step-by-step instructions. In the exercises, we ask students to modify or refine the existing model, analyze it further, or adapt it to similar scenarios.
Chapter 1 -- What is Mathematical Modeling?
Chapter 2 -- Proportionality and Geometric Similarity
Chapter 3 -- Empirical Modeling
Chapter 4 -- Discrete Dynamical Systems
Chapter 5 -- Differential Equations
Chapter 6 -- Simulations
Chapter 7 -- Optimization