Mathematical Modeling with Excel

3. Auflage 2027
ISBN: 978-1-041-31504-9
Verlag: Taylor & Francis Ltd

Buch, Englisch, 416 Seiten, Format (B × H): 178 mm x 254 mm

Reihe: Textbooks in Mathematics

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.

Zielgruppe

Undergraduate Advanced

Autoren/Hrsg.

Albright, Brian

Fox, William P.

Fachgebiete

• Mathematik | Informatik Mathematik Numerik und Wissenschaftliches Rechnen Angewandte Mathematik, Mathematische Modelle
• Wirtschaftswissenschaften Betriebswirtschaft Unternehmensforschung

Inhaltsverzeichnis

1. What is Mathematical Modeling? 2. Proportionality and Geometric Similarity 3. Linear Algebra 4. Discrete Dynamical Systems 5. Differential Equations 6. Simulations 7. Linear Optimization 8. Nonlinear Optimization 9. Decision Theory with MADM and Game Theory

Über Autor(innen)

Brian Albright received a D.Sc. in systems science and mathematics from Washington University in St. Louis. In early 2004 he worked as a civilian transportation analyst at the United States Transportation Command. Since 2004 he has taught all levels of undergraduate mathematics at Concordia University, Seward, NE. He has published two textbooks, Mathematical Modeling with Excel and Essentials of Mathematical Statistics.

William P. Fox is an emeritus professor in the Department of Defense Analysis at the Naval Postgraduate School. Currently, he is an adjunct professor, Department of Mathematics, the College of William and Mary. He received his Ph.D. at Clemson University and has many publications and scholarly activities including twenty books and over one hundred and fifty journal articles.