![IEE 475: Simulating Stochastic Systems artwork](https://is4-ssl.mzstatic.com/image/thumb/Features/v4/5f/88/96/5f8896e9-9be5-529a-af14-cc807367568a/mza_1382744875394257421.png/100x100bb.jpg)
Lecture B3 (2022-09-06): DES Examples, Part II, plus Post-Lab2 Reflections
IEE 475: Simulating Stochastic Systems
English - September 06, 2022 22:38Courses Education simulation stochastic des dess discrete event system industrial engineering modeling Homepage Download Apple Podcasts Google Podcasts Overcast Castro Pocket Casts RSS feed
In this lecture, we close out our review of DES fundamentals and hand simulation. After going through a hand-simulation example one last time, we show how to implement a Discrete Event System (DES) simulation using a spreadsheet tool like Microsoft Excel without any "macros" (VBA, etc.). This involves defining relationships ACROSS TIME that allow the spreadsheet to (in a declarative fashion) reconstruct the trajectory that is the output of the simulation. We then pivot to discussing the previous "Lab 2 (Muffin Oven Simulation)", which lets us discuss common random numbers (CRNs), statistical blocking, requirements of 2-sample and paired t-tests, and more sophisticated statistical methods that better characterize PRACTICAL significance (and take into account the multiple comparisons problem). Thus, the post-lab2 reflections are largely a preview of future topics in the course.