Solutions Manual to Accompany Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft Office Excel(Paperback)

Jeffrey T. Barton

  • 出版商: Wiley
  • 出版日期: 2016-03-07
  • 售價: $1,600
  • 貴賓價: 9.5$1,520
  • 語言: 英文
  • 頁數: 182
  • 裝訂: Paperback
  • ISBN: 1119040027
  • ISBN-13: 9781119040026
  • 相關分類: Excel
  • 海外代購書籍(需單獨結帳)

相關主題

商品描述

A solutions manual to accompany An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel®

With a focus on mathematical models based on real and current data, Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel® guides readers in the solution of relevant, practical problems by introducing both mathematical and Excel techniques.

The book begins with a step-by-step introduction to discrete dynamical systems, which are mathematical models that describe how a quantity changes from one point in time to the next. Readers are taken through the process, language, and notation required for the construction of such models as well as their implementation in Excel. The book examines single-compartment models in contexts such as population growth, personal finance, and body weight and provides an introduction to more advanced, multi-compartment models via applications in many areas, including military combat, infectious disease epidemics, and ranking methods. Models for Life: An Introduction to Discrete Mathematical Modeling with Microsoft® Office Excel® also features:

  • A modular organization that, after the first chapter, allows readers to explore chapters in any order
  • Numerous practical examples and exercises that enable readers to personalize the presented models by using their own data
  • Carefully selected real-world applications that motivate the mathematical material such as predicting blood alcohol concentration, ranking sports teams, and tracking credit card debt
  • References throughout the book to disciplinary research on which the presented models and model parameters are based in order to provide authenticity and resources for further study
  • Relevant Excel concepts with step-by-step guidance, including screenshots to help readers better understand the presented material
  • Both mathematical and graphical techniques for understanding concepts such as equilibrium values, fixed points, disease endemicity, maximum sustainable yield, and a drug’s therapeutic window
  • A companion website that includes the referenced Excel spreadsheets, select solutions to homework problems, and an instructor’s manual with solutions to all homework problems, project ideas, and a test bank

商品描述(中文翻譯)

《微軟® Office Excel 離散數學建模入門》解答手冊

以真實且最新的數據為基礎,生活模型:微軟® Office Excel 離散數學建模入門通過介紹數學和 Excel 技巧,引導讀者解決相關實際問題。

本書首先逐步介紹離散動態系統,這些數學模型描述了一個數量如何從一個時間點變化到下一個時間點。讀者將了解構建這些模型所需的過程、語言和符號,以及在 Excel 中實現它們的方法。本書還通過在人口增長、個人財務和體重等情境中探討單一隔室模型,介紹了更高級的多隔室模型,並應用於軍事戰鬥、傳染病流行和排名方法等多個領域。《生活模型:微軟® Office Excel 離散數學建模入門》還包括:

- 模塊化組織,讓讀者在第一章後可以按任意順序探索各章節
- 大量實際例子和練習,讓讀者可以使用自己的數據個性化呈現的模型
- 精心挑選的真實應用,激發數學材料的興趣,如預測血液中的酒精濃度、排名運動隊和追蹤信用卡債務
- 整本書中引用的學科研究,這些研究為所呈現的模型和模型參數提供真實性和進一步研究的資源
- 相關的 Excel 概念和逐步指導,包括屏幕截圖,幫助讀者更好地理解所呈現的材料
- 用於理解平衡值、固定點、疾病流行、最大可持續產量和藥物治療窗口等概念的數學和圖形技巧
- 附帶網站,包括引用的 Excel 試算表、部分作業問題的解答和教師手冊,其中包含所有作業問題的解答、項目想法和測試題庫