Mathematical Modeling with Excel

Brian Albright, William P Fox (Autoren)

Buch | Softcover

370 Seiten

2023 | 2nd edition
CRC Press (Verlag)
978-1-032-47512-7 (ISBN)

Artikel merken

This text presents a wide variety of common and new types of models. Sections begin with a general description of the scenario being modeled. The model is built using the appropriate tools. Then it is implemented and analyzed. Students are tasked to modify or refine the existing model, analyze it further, or adapt it to similar scenarios.

This text 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.

Brian Albright grew up in Colby, KS; received undergraduate degrees in mathematics and secondary education from Emporia State University, Emporia, KS; and 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 Exceland Essentials of Mathematical Statistics; has written two articles for The College Mathematics Journal; and has written ancillary material for several textbooks.

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

Erscheinungsdatum	11.01.2023
Reihe/Serie	Textbooks in Mathematics
Zusatzinfo	369 Illustrations, black and white
Verlagsort	London
Sprache	englisch
Maße	178 x 254 mm
Gewicht	700 g
Themenwelt	Informatik ► Office Programme ► Excel
Themenwelt	Mathematik / Informatik ► Mathematik ► Angewandte Mathematik
ISBN-10	1-032-47512-9 / 1032475129
ISBN-13	978-1-032-47512-7 / 9781032475127
Zustand	Neuware