- STAFF PICKS
- GIFTS + GIFT CARDS
- SELL BOOKS
- FIND A STORE
New Trade Paper
Ships in 1 to 3 days
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
More copies of this ISBN
The Active Modeler: Mathematical Modeling with Microsoft Excelby Erich Neuwirth
Synopses & Reviews
This is a hands-on introduction to modeling a wide variety of applications in Microsoft Excel. It features numerous tutorials and applications to illustrate how to model and solve problems in Excel. It can be used by itself or as a supplement to a text in Mathematical Modeling or Liberal Arts Mathematics. Neuwirth and Arganbright offer a more accessible and hands-on alternative than do other modeling texts.
Book News Annotation:
Neuwirth and Arganbright (credentials not listed) offer an introduction to modeling a variety of applications with Microsoft Excel. The text features numerous tutorials and applications to illustrate the use of Excel in modeling and solving problems. Chapters focus on topics like dynamical models and difference equations, physics applications, number theory, functions and graphing, everyday math, combinatorics and probability, and finding optimal solutions. A companion CD-ROM provides illustrations of mathematical modeling and practice exercises.
Annotation ©2004 Book News, Inc., Portland, OR (booknews.com)
This is a hands-on introduction to modeling a wide variety of applications in Microsoft Excel. It features numerous tutorials and applications to illustrate how to model and solve problems in Excel. Neuwirth and Arganbright offer a more accessible and hands-on alternative than do other modeling books. Illustrated examples provide instruction in concepts, applications, and methods of solving them.
About the Author
Deane Arganbright is currently Professor and Chair of the Department of Mathematics and Statistics at the University of Tennessee at Martin. Previously, he taught at Iowa State University, Whitworth College, and the University of Papua New Guinea. He has also authored MATHEMATICAL APPLICATIONS OF ELECTRONIC SPREADSHEETS, and PRACTICAL HANDBOOK OF SPREADSHEET CURVES AND GEOMETRIC CONSTRUCTIONS.
Table of Contents
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.
What Our Readers Are Saying
Other books you might like
Business » General