•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Monte Carlo simulation of a sample size that used Monte Carlo
Our take
Hello everyone,
I'm looking to create 1,000 simulations using Monte Carlo methods for a sample size of 200 KPIs. While I can easily generate sample populations of varying sizes, I’m facing challenges with calculating the average, minimum, and maximum of a sub-population across a set number of recursions. I believe there might be a straightforward approach to achieve this without resorting to complicated coding or calculations that would slow down Excel. Any insights or advice would be greatly appreciated!
Thank you,
Mike
Hi All,
I need to create 1000 simulations of a Sample Size of 200 KPIs
I'm using Montecarlo / norm.inv and rand to get my sample population and I can get 200 or 200,000 no problem
But trying to create the 2nd part where it will calculate the average and min and max of a sub-population a set number of recursions is causing me challenges
I feel like there should be an easy way to do this without needing to code or having some super burdensome calculations that crush the excel
Any Advice?
Mike
[link] [comments]
Read on the original site
Open the publisher's page for the full experience