Page Tools:
  • print-friendly version

Mathematical Modeling with Excel

Author(s): Brian Albright, Concordia University
Details:
  • ISBN-13: 9780763765668
  • Hardcover    286 pages      © 2010
Price: International Sales $84.95 US List
Add to Cart Request a Review Copy

Overview

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.

 

ShowKey Features

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.

Back to top

ShowTable of Contents

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
Back to top

ShowAbout the Author(s)

Brian Albright-Concordia University

Brian Albright grew up in Colby, KS.  He atteded college at Emporia State University where he studied mathematics and secondary education. He went to graduate school at Washington University in St. Louis.  Currently he teaches at Concordia University where he lives with his wife and children.

Back to top

ShowAppropriate 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.

Back to top

ShowResources

Back to top