Mathematical Modeling with Excel

Name: Mathematical Modeling with Excel
Price: 288.74 USD
Availability: InStock
ISBN: 9780763765668

ISBN-10: 076376566X

ISBN-13: 9780763765668

Edition: 2010

Authors: Brian Albright

List price: $93.95

30 day, 100% satisfaction guarantee!

Marketplace

1 new & used from $288.74

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

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…

Book details

List price: $93.95
Copyright year: 2010
Publisher: Jones & Bartlett Learning, LLC
Publication date: 7/31/2009
Binding: Hardcover
Pages: 286
Size: 7.50" wide x 9.25" long x 0.75" tall
Weight: 1.694
Language: English



Preface



What is Mathematical Modeling?



Definitions



Purpose



The Process



Assumptions


For Further Reading


References



Proportionality and Geometric Similarity



Introduction



Using Data



Modeling with Proportionality



Fitting Straight Lines Analytically



Geometric Similarity


For Further Reading


References



Empirical Modeling



Introduction



Linearizable Models



Coefficient of Determination



Polynomials



Multiple Regression



Spline Models


For Further Reading


References



Discrete Dynamical Systems



Introduction



Long-Term Behavior and Equilibria



Growth of a Bacteria Population



A Linear Predator--Prey Model



A Nonlinear Predator--Prey Model



Epidemics


For Further Reading


References



Differential Equations



Introduction



Euler's Method



Quadratic Population Model



Volterra's Principle



Lanchester Combat Models



Eigenvalues


For Further Reading


References



Simulation Modeling



Introduction



Basic Examples



The Birthday Problem



Random Number Generators



Modeling Random Variables



Approximating Density Functions



A Theoretical Queuing Model



A Coffee Shop Queuing Model



A Scheduling Model



An Inventory Model


For Further Reading


References



Optimization



Introduction



Linear Programming



The Transportation Problem



The Assignment Problem and Binary Constraints



Solving Linear Programs



The Simple Method



Sensitivity Analysis



The Gradient Method


For Further Reading


References



Spreadsheet Basics



Basic Terminology



Entering Text, Data, and Formulas



Creating Charts and Graphs



Scroll Bars



Array Formulas



Built-In Functions


Index