Mathematical Modeling with Excel, Second Edition, presents a wide variety of common types and some new models 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 numerous exercises, students are encouraged to modify or refine the existing model, analyze it further, or adapt it to similar scenarios. The main idea in the text is that Excel is a valuable tool which furthers the goal of building and analyzing mathematical models. The authors present different ways of doing this in a format that can be read by students, not just instructors.
Features:
Devoted to helping students develop the critical ability to analyze and adapt mathematical models
Utilizes a unique, step-by-step pedagogical approach
Employs Excel to analyze models
Presents a wide variety of types of models including empirical, dynamical system, differential equation, simulation, and optimization
Includes project ideas to help students develop their own projects and improve their problem solving skills
Contains over 375 exercises
About the Authors:
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.
Dr. 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.