How do you  run a simple simulation in excel?
 Open a new Excel spreadsheet. Enter a heading at the top of a column, if desired. Under “Tools” click on “Data Analysis.”. Find “Random Number Generation,” and double-click on it or highlight it and click OK. 