I am trying to build a simple Monte Carlo Simulation that will simulate employee behavior for say 100 employees (really the number is much larger precluding putting each employee in their own column). I would then like to run say 500 scenarios. What I would like to do is simulate the behavior for each of the 100 employees and then sum the results. This would be the result for scenario 1. Then repeat 500 times. Is there any easy way to do this within one cell for each scenario? I am not looking to do something like Scenario = 100 * NORMINV(Rand(), ...). Instead I really want to do NORMINV(Rand(), ...) + NORMINV(Rand(), ...) +..... Unless I am missing something obvious, I suspect I will need to do it in VBA. But wanted to post here first.
Hope that makes sense.
Thanks in advance!
Bookmarks