Discover an engaging and authentic approach to mathematical modeling with *Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel®*. This comprehensive guide emphasizes real-world applications, helping readers solve relevant and practical problems through a blend of mathematical techniques and Excel skills.
The book begins with a clear, step-by-step introduction to discrete dynamical systems—mathematical models that describe how a quantity evolves from one point in time to the next. Readers are guided through the necessary language, notation, and construction of these models, along with their implementation in Excel. It explores single-compartment models in contexts such as population growth, personal finance, and body weight, providing a solid foundation before advancing to more complex, multi-compartment models. These are applied across diverse fields, including military combat, infectious disease epidemics, and ranking methods.
*Models for Life* features a modular organization that allows readers to explore chapters in any order after the initial chapter, fostering flexible learning. It includes numerous practical examples and exercises designed to personalize the models using individual data, enhancing understanding and application. The book also presents carefully selected real-world scenarios—such as predicting blood alcohol concentration, ranking sports teams, and tracking credit card debt—that motivate the mathematical concepts.
Throughout the text, references to disciplinary research underpin the models and parameters, providing authenticity and avenues for further study. Relevant Excel concepts are explained with step-by-step guidance and screenshots, making technical skills accessible. The book covers both mathematical and graphical techniques for understanding key concepts like equilibrium values, fixed points, disease endemicity, maximum sustainable yield, and a drug’s therapeutic window.
A companion website complements the book by offering the referenced Excel spreadsheets, select solutions to homework problems, and an instructor’s manual with solutions, project ideas, and a test bank.
Ideal for undergraduate non-mathematics majors enrolled in courses such as introductory mathematical modeling, applications of mathematics, survey of mathematics, discrete mathematical modeling, and mathematics for liberal arts, this book also serves as a valuable resource for honors or independent study courses in mathematical modeling and mathematical biology.
Author Jeffrey T. Barton, PhD, is a Professor of Mathematics at Birmingham-Southern College. A member of the American Mathematical Society and the Mathematical Association of America, his research interests include approximation theory, analytic number theory, mathematical biology, mathematical modeling, and the history of Wiley
Product Type: ABIS_BOOKAuthor: Jeffrey T. BartonGenre: MathematicsBinding: HardcoverLanguage: EnglishPublication Date: 2016Pages: 496
When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.