Limit search to available items
Book Cover
Book
Author Neuwirth, Erich.

Title The active modeler : mathematical modeling with Microsoft Excel / Erich Neuwirth, Deane Arganbright
Published Belmont, CA : Thomson--Brooks/Cole, [2004]
©2004

Copies

Location Call no. Vol. Availability
 W'PONDS  511.8 Neu/Amm  AVAILABLE
Description xvii, 471 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.)
4 3/4 in
Contents Machine derived contents note: Prologue. Preface. 1. Introductory Models. Fibonacci Numbers. Growth Models. Extended Growth Models. Comparing Different Growth Models. 2. Dynamical Models and Difference Equations. Simple Epidemics. Harvesting Models. Population Dynamics. A Predator-Prey Model. Iterated Maps and Functions. More about Iterated Functions. The Feigenbaum Diagram. Sierpinski's Triangle. 3. Physics Applications. Simple Projectile Motion. Projectile Motion with Air Resistance. Planetary Orbits: Half Step Method. The Shape of the Moon's Orbit. Heat Propagation. 4. Number Theory. Numbers in Different Bases. Decimal Expansions. Greatest Common Divisor. Sieve of Eratosthenes. 5. Functions and Graphing. Graphing I: Basic Techniques. Graphing II: Polar and Parametric Equations. Bezier Curves. Bisection Algorithm. The Newton and Secant Methods. Fitting a Curve to Data. The Binomial Coefficients. 6. Creative Mathematics in Everyday Settings. A Bicycle Investigation. Ski Racing. The Golden Ratio. Paper Formats. Game of Life. Problems to Solve by Yourself. 7. Combinatorics and Probability. Birthday Problem. Birth Control: The Geometric Distribution. Genetics: The Hardy-Weinberg Principle. Simulation. 8. Finding Optimal Solutions. Optimal Bridge Location. Apportionment Algorithms. Medicine Dosage. Inventory Control. Game Theory. Appendices: 1. Spreadsheet Basics and Book Conventions. 2. Functions and Additional Spreadsheet Features. 3. Spreadsheet Graphing Fundamentals. 4. Additional Spreadsheet Graphing Techniques. 5. Interactive Spreadsheet Tools. 6. Reformatting Models for User Interaction. 7. Adding Interactive Tools to Excel Models
Bibliography Includes bibliographical references (pages 463-465) and index
Notes Minimum system requirement: Microsoft Windows 98+, MAC OS X, 128MB RAM, 20MB free hard drive space, 266Mhz processor, 4X CD-ROM
System requirements for accompanying computer optical disc:
SUBJECT Microsoft Excel (Computer file) http://id.loc.gov/authorities/names/n86025775
Subject Mathematical models -- Data processing.
Mathematical models.
Computer simulation.
Author Arganbright, Deane.
LC no. 2003114962
ISBN 0534420850
0534421016 disc
Other Titles Mathematical modeling with Microsoft Excel
OTHER TI Microsoft Excel
Other Titles Excel files and video lessons for the active modeler : mathematical modeling with Microsoft® Excel