Tuesday, September 8, 2026

Lecture B3 (2026-09-08): Discrete-Event Simulation Examples, Part II

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.

If time permits, this lecture slot will be used to pivot to discussing the previous "Lab 2 (Muffin Oven Simulation)", which lets us introduce 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.

As an introduction to next week's lab, this lecture also links to an interactive Monte Carlo method concept explorer for students to engage with offline. It can be found at:

https://tpavlic.github.io/asu-simulating-stochastic-systems/monte_carlo/mc_explorer.html



No comments:

Post a Comment

Popular Posts