Simulation via spreadsheet assignment
Do the following within a Spreadsheet, and then with your DESS:
- Use the data collected (time since last arrival, service time)
from "Sheet1" of the spreadsheet found at the
link on the course web page.
Fill in the cells with appropriate functions so that your spreadsheet generates the numbers shown on "Sheet2".
- Next, calculate the cumulative distribution function for each of the data
collected (time since last arrival, service time). Use these functions
to generate values (as in "Sheet3"). Use the random number function in
your spreadsheet. Each time you "reload" the page, a new set of values
should be displayed.