Mathematical Modeling with Excel

This text presents a wide variety of common types of models found in other mathematical modeling texts, as well as some new types. However, the models are presented in a very unique format. A typical section begins with a general description of the scenario being modeled. The model is then built using the appropriate mathematical tools. Then it is implemented and analyzed in Excel via step-by-step instructions. In the exercises, we ask students to modify or refine the existing model, analyze it further, or adapt it to similar scenarios.

這段文字介紹了其他數學建模教材中常見的各種模型類型，以及一些新的類型。然而，這些模型以非常獨特的格式呈現。一個典型的部分以對正在建模的情境進行一般描述開始。然後使用適當的數學工具來建立模型。然後通過逐步指示在Excel中實施和分析模型。在練習中，我們要求學生修改或完善現有模型，進一步分析它，或將其適應類似情境。

Brian Albright grew up in Colby, KS; received undergraduate degrees in mathematics and secondary education from Emporia State University, Emporia, KS; and received a D.Sc. in systems science and mathematics from Washington University in St. Louis. In early 2004 he worked as a civilian transportation analyst at the United States Transportation Command. Since 2004 he has taught all levels of undergraduate mathematics at Concordia University, Seward, NE. He has published two textbooks, Mathematical Modeling with Exceland Essentials of Mathematical Statistics; has written two articles for The College Mathematics Journal; and has written ancillary material for several textbooks.

Brian Albright在堪薩斯州科爾比長大，並在堪薩斯州恩波里亞州立大學獲得數學和中等教育的學士學位，並在華盛頓大學聖路易斯分校獲得系統科學和數學的博士學位。2004年初，他在美國運輸司令部擔任民用運輸分析師。自2004年以來，他在內布拉斯加州西沃德的康科迪亞大學教授各個層次的本科數學。他出版了兩本教科書《使用Excel進行數學建模》和《數學統計學基礎》，並為《大學數學期刊》撰寫了兩篇文章，還為幾本教科書撰寫了附屬材料。