Microsoft Office Tutorials and References
In Depth Information
Chapter 7
Modeling and Simulation: Part 1
Contents
7.1 Introduction ................................. 217
7.1.1 What is a Model? ........................... 219
7.2 How Do We Classify Models? ........................ 221
7.3 An Example of Deterministic Modeling .................... 223
7.3.1 A Preliminary Analysis of the Event ................... 224
7.4 Understanding the Important Elements of a Model ............... 227
7.4.1 Pre-Modeling or Design Phase ..................... 228
7.4.2 Modeling Phase ............................ 228
7.4.3 Resolution of Weather and Related Attendance .............. 232
7.4.4 Attendees Play Games of Chance .................... 233
7.4.5 Fr. Efia’s What-if Questions ....................... 235
7.4.6 Summary of OLPS Modeling Effort ................... 236
7.5 Model Building with Excel .......................... 236
7.5.1 Basic Model .............................. 237
7.5.2 Sensitivity Analysis .......................... 240
7.5.3 Controls from the Forms Control Tools .................. 247
7.5.4 Option Buttons ............................ 248
7.5.5 Scroll Bars .............................. 250
7.6 Summary .................................. 252
Key Terms .................................... 253
Problems and Exercises .............................. 254
7.1 Introduction
The previous six chapters have provided us with a general idea of what a model is
and how it can be used. Yet, if we are to develop good model building and anal-
ysis skills, we still need a more formal description, one that permits us a precise
method for discussing models. Particularly, we need to understand a model’s struc-
ture, its capabilities, and its underlying assumptions. So let us carefully re-consider
H. Guerrero, Excel Data Analysis , DOI 10.1007/978-3-642-10835-8_7,
C
217
Springer-Verlag Berlin Heidelberg 2010
Search JabSto ::




Custom Search