finelybook
Mathematical Modeling with Excel (Textbooks in Mathematics)
by 作者: Brian Albright and William P Fox
Pages: 370 pages
Publisher Finelybook 出版社: Chapman and Hall/CRC; 2 edition (6 Nov. 2019)
Language 语言: English
ISBN-10 书号: 1138597074
ISBN-13 书号: 9781138597075
Book Description
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.
Contents
Preface
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
Appendix A: Spreadsheet Basics
Index
