My Account
View Cart
Log-out
0
17 years of Excellence
SUBJECTS
ADV. SEARCH
Home
>
Subjects
>
Others
Mathematical Modeling With Excel
by Brian Albright
Price :
Rs
395.00
Your Price :
Rs
355.50
10
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
Payment accepted by All Major Credit and Debit Cards, Net Banking, Cash Cards, Paytm, UPI, Paypal. Our payment gateways are 100% secure.
Check Delivery
Pls. enter your postal pincode.
Pls. enter valid Indian Postal Pincode.
Books of Similar Interest
10%
Pro Spring 3
by Ho
22%
Discover India:Food, Culture and Peop
by Mehta, Sonia
18%
Cyber Crime: Criminal Threats from Cyberspace
by Susan W. Brenner
10%
CASES IN MARKETING MANAGEMENT
by CLOW
10%
Viva Value Education, New & Revised Edition - 8
by Jaya Krishnaswamy
Support
Phone :
+91-9266663909
Email :
support [at] bestbookmart.com
Timing :
10:00 AM to 6:00 PM (Mon-Fri)
Quick Links
View Cart
My Account
Terms & Conditions
Privacy Policy
Return Policy
More Links
Our Subjects
Our Publishers
Powered By