Active Modeler Mathematical Modeling with Microsoft Excel

ISBN-10: 0534420850
ISBN-13: 9780534420857
Edition: 2004
List price: $129.95
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy

Description: 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  More...

what's this?
Rush Rewards U
Members Receive:
coins
coins
You have reached 400 XP and carrot coins. That is the daily max!

Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
Calculus 1 Online content $4.95 $1.99
Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99

Customers also bought

Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading
Loading

Book details

List price: $129.95
Copyright year: 2004
Publisher: Brooks/Cole
Publication date: 12/11/2003
Binding: Paperback
Pages: 496
Size: 7.25" wide x 8.75" long x 0.75" tall
Weight: 1.100
Language: English

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.

Prologue
Preface
Introductory Models
Fibonacci Numbers
Construction Summary: Fibonacci Numbers
Exercises
Growth Models
Construction Summary: Exponential Growth
Exercises
Extended Growth Models
Construction Summary: Logistic Growth
Exercises
Comparing Different Growth Models
Construction Summary: Comparing Growth Models
Exercises
Dynamical Models and Difference Equations
Simple Epidemics
Construction Summary: Simple Epidemics
Exercises
Harvesting Models
Constant Harvesting Policy
Introducing Mathematical Notation
Proportional Harvesting Policy
Construction Summary: Harvesting Models
Exercises
Population Dynamics
Further Mathematics: Experimenting with Population Dynamics
Construction Summary: Population Dynamics
Exercises
A Predator-Prey Model
Further Mathematics: Difference Equations versus Differential Equations
Construction Summary: A Predator-Prey Model
Exercises
Iterated Maps and Functions
Further Mathematics: Fixed Points and Calculus
Construction Summary: Function Iteration for Square Function
Construction Summary: Function Iteration for Nonlinear Function
Exercises
More about Iterated Functions
Further Mathematics: An Unanswered Question
Construction Summary: More about Iterated Functions
Exercises
The Feigenbaum Diagram
Construction Summary: The Feigenbaum Diagram
Exercises
Sierpinski's Triangle
Construction Summary: Sierpinski's Triangle
Exercises
Physics Applications
Simple Projectile Motion
Further Mathematics: A Calculus-Based Solution
Construction Summary: Simple Projectile Motion
Exercises
Projectile Motion with Air Resistance
Construction Summary: Projectile Motion with Air Resistance
Exercises
Planetary Orbits: Half-Step Method
Construction Summary: Planetary Orbits (Half-Step Method)
Exercises
The Shape of the Moon's Orbit
Construction Summary: Shape of the Moon's Orbit
Exercises
Heat Propagation
One-Dimensional Model
Construction Summary: Heat Flow in a Rod
Two-Dimensional Model
Construction Summary: Heat Flow in a Plate
Exercises
Number Theory
Numbers in Different Bases
Construction Summary: Simple Expansion
Construction Summary: Integer Expansion with Target Base > 10
Construction Summary: Integer Expansion with Source Base Different from 10
Exercises
Decimal Expansions
Construction Summary: Decimal Expansions
Exercises
Greatest Common Divisor
Further Mathematics: Euclid's Algorithm
Construction Summary: Greatest Common Divisor
Exercises
Sieve of Eratosthenes
Basic Model
Compact Version
Construction Summary: Sieve of Eratosthenes
Exercises
Functions and Graphing
Graphing I: Basic Techniques
Two Basic Examples
Construction Summary: Graphing Functions of One Variable
Interactive Graphing
Construction Summary: Graphing Functions with a Trace Point
Graphs of Several Functions
Construction Summary: Graphing Two Functions of One Variable
Exercises
Graphing II: Polar and Parametric Equations
Basic Construction
Incorporating Animation Effects
Construction Summary: Graphing Polar Equations
Exercises
Bezier Curves
Basic Construction
Construction Summary: Bezier Curves
An Alternate Approach
Construction Summary: Bezier Curves via Matrices
Exercises
Bisection Algorithm
Construction Summary: Bisection Algorithm
Exercises
The Newton and Secant Methods
Newton's Method
Construction Summary: Newton's Method
The Secant Method
Construction Summary: Secant Method
Exercises
Fitting a Curve to Data
Polynomial Interpolation
Construction Summary: Fitting a Curve to Data
A Matrix Approach to Interpolation
Construction Summary: Polynomial Interpolation via Matrices
A Glance at the Least-Squares Approximation
Construction Summary: Least-Squares Regression
Exercises
The Binomial Coefficients
Construction Summary: The Binomial Coefficients
Exercises
Creative Mathematics in Everyday Settings
A Bicycle Investigation
Construction Summary: Bicycle Investigation
Ski Racing
Construction Summary: Ski Racing
The Golden Ratio
Construction Summary: Golden Ratio (Direct), Compute Ratio Directly
Construction Summary: Golden Ratio (Iteration), Compute Ratio by Iteration
Paper Formats
Construction Summary: Paper Formats
Game of Life
Construction Summary: Game of Life
Exercises
Problems to Solve by Yourself
Exercises
Combinatorics and Probability
Birthday Problem
Construction Summary: Birthday Problem
Exercises
Birth Control: The Geometric Distribution
Construction Summary: Birth Control (Geometric Distribution)
Exercises
Genetics: The Hardy-Weinberg Principle
Further Mathematics: The Algebra of Hardy-Weinberg
Construction Summary: Genetics (Hardy-Weinberg Principle)
Exercises
Simulation
Simulating Bernoulli Trials and the Binomial Distribution
Construction Summary: Binomial Simulation
Rolling a Pair of Dice
Construction Summary: Dice Simulation
The Birthday Problem Revisited
Construction Summary: Birthday Problem Simulation
Exercises
Finding Optimal Solutions
Optimal Bridge Location
Construction Summary: Optimal Bridge Location, Part 1
Construction Summary: Optimal Bridge Location, Part 2
Exercises
Apportionment Algorithms
Hamilton's Method
Construction Summary: Apportionment Algorithms (Hamilton)
Jefferson's Method
Construction Summary: Apportionment Algorithms (Jefferson)
Exercises
Medicine Dosage
Construction Summary: Medicine Dosage, Basic Model
Construction Summary: Medicine Dosage, Data for Graph
Exercises
Inventory Control
Further Mathematics: Deriving Optimal Values Analytically
Construction Summary: Inventory Control
Exercises
Game Theory
Construction Summary: Game Theory
Exercises
Appendix
Spreadsheet Basics and Book Conventions
Functions and Additional Spreadsheet Features
Spreadsheet Functions
Data Table
Inserting and Deleting Rows and Columns
Conditional Formatting
Spreadsheet Graphing Fundamentals
Additional Spreadsheet Graphing Techniques
Labels
Additional Formatting
Three-Dimensional Graphs
Interactive Spreadsheet Tools
The Scroll Bar
Buttons and Macros
Goal Seek
Solver
Reformatting Models for User Interaction
General Layout
Formatting and Protection
Comments
Adding Interactive Tools to Microsoft Excel Models
Logistic Growth
Harvesting
References
Index

×
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.

×