Page Tools:

Mathematical Modeling with Excel

Author(s): Brian Albright, Concordia University
Details:
  • ISBN-13: 9780763765668
  • Paperback    286 pages      © 2010
Price: $134.95 US List
Add to Cart

Part of the International Series in Mathematics

Mathematical modeling is the use of applying mathematics to real-world problems and investigating important questions about their outcomes.  Mathematical Modeling with Excel presents various methods used to build and analyze mathematical models in a format that students can quickly comprehend.  Excel is used as a tool to accomplish this goal of building and analyzing the models. Ideal for math and secondary math education majors, this text presents a wide variety of common types of models, as well as some new types, and presents each in a unique, easy-to-understand format.  End-of-chapter exercises ask students to modify or refine the existing model, analyze it further, or adapt it to similar scenarios.

 

Features & Benefits

A user-friendly writing style makes the text appropriate for a wide range of students.

Covers topics in a unique way by beginning each section with a theoretical derivation of a model scenario, then showing step-by-step instructions for implementing and dynamically analyzing the model in Excel.

Includes an extensive section on simulation models.

The spreadsheets, built according to instruction, allow students to dynamically change the values of parameters and analyze changes in the behavior of the model.

Applicable Courses

This text is appropriate for a variety of introductory mathematical modeling courses offered within the department of mathematics. 

It is also ideal for use as a supplement title for courses in differential equations, operations research, and biological mathematical modeling.

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  Simulation Modeling
Chapter 7  Optimization

Brian Albright-Concordia University

Additional Titles by this Author

The following instructor resources are available to qualified instructors for download

ISBN-13: 9780763765668

Additional Resources for Instructors