Create a Simulation in Excel and can chose any topic. Few Examples are: Tossing of a Coin, Inventory of a store, Predicting future grade of class based on current performance etc.
Requirements:
1).You must use at least the following Excel functions: Rand, Vlookup, Countif.
2).Set up so runs at least 25 simulations
3).On sheet 1 include a description of what you are trying to simulate.
You will be graded on:
1). Does it work
2). Is it easy to understand (formulation)?
3). Creativity
Categories: