Mathematical Modeling with Excel, Third Edition introduces students to the art and practice of using mathematics to understand and solve real-world problems. The text presents a wide range of modeling methods through applications drawn from physics, engineering, business, economics, biology, and the social sciences. Students learn the modeling process while implementing models in Excel through step-by-step instructions. Topics include proportionality, regression, linear algebra, dynamical systems, differential equations, simulations, optimization, and decision theory.
Designed for undergraduate students in mathematics, engineering, computer science, and related quantitative disciplines, this text is ideal for an introductory course in mathematical modeling. Most topics in the text require only mathematical maturity, while others require knowledge of basic calculus, differential equations, or statistics, making the book suitable for sophomore- through senior-level students. No prior experience with Excel is required.
Features and Benefits
- Over 430 exercises, many of which introduce new concepts not discussed in the examples.
- Examples include detailed step-by-step instructions for implementing models in Excel 365.
- Includes a more thorough coverage of simulations than most introductory mathematical modeling textbooks.
- Emphasis is placed on building and analyzing models rather than the underlying mathematical theory.
- Ideas for student projects are scattered throughout the book.
- New to the Third Edition: updated Excel 365 instructions, numerous new exercises, a new section on transformations and a new chapter on Decision Theory with Multi-Attribute Decision Making (MADM) and Game Theory.
