0
17 years of experience17 years of Excellence
SUBJECTS
ADV. SEARCH
Indian Books on Discounts
  Mathematical Modeling with Excel
 

Mathematical Modeling With Excel

by Brian Albright

  Price : Rs 395.00
  Your Price : Rs 355.50
Discount
10
Out of Stock
  Description: Mathematical modeling is the practice of applying mathematics to real-world problems and investigating important questions about their outcomes. Mathematical Modeling with Excel presents the 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 not traditionally covered. Each is presented 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. With a flexible design and student-friendly writing style, Mathematical Modeling with Excel is the clear choice for engaging readers in important modeling techniques, mathematical concepts and application types.

Key features include:

· A user-friendly writing style makes the text appropriate for a wide range of students.

· Topics are covered 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 analytical spreadsheets, built according to instruction, allow students to dynamically change the values of parameters and analyze changes in the behavior of the model.

· Solutions, worksheets and the author-created Excel worksheet “ Linear Programming” are available on the text’s website.

Contents: 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 non-linear Predator-Prey model • Differential equations • Introduction • Euler’s Method • Quadratic Population Model • Volterra’s Principle • Lancester 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 simplex method • Sensitivity analysis • The gradient method • For Further reading • Reference • Spreadsheet basics • Basic terminology • Entering text, Data and Formulas • Creating charts and graphs • Array formulas.ISBN - 9789380108452
 


Pages : 300
Credit Cards
Payment accepted by All Major Credit and Debit Cards, Net Banking, Cash Cards, Paytm, UPI, Paypal. Our payment gateways are 100% secure.
Check Delivery
Books of Similar Interest
15%
Shivaji. The Great Maratha. 4 Volumes Set
by H S Sardesai
12%
Peace and Bread in Time of War
by Laura Jane Addams
10%
Physical Chemistry, 9/e
by Peter Atkins
12%
Abhijñana Sakuntalam (Shakuntala)
by Kalidasa
10%
Accounting A to Z Handbook, 3/e
by Ian Harrison
Best Book Mart
Support

Call Us Phone : +91-9266663909
Email Us Email : support [at] bestbookmart.com
Working Hours Timing : 10:00 AM to 6:00 PM (Mon-Fri)
Powered By
CCAvenue
SSL Protection