Help with Random Sampling and Monte Carlo
I have 100 columns of data with 100 observations in each. The numbers are essentially randomly generated using Rand(). Imagine each column represents historical monthly mutual fund performance data
I calculate the average of each column (to get the monthly average performance of each mutual fund)
I now want to run a Monte Carlo simulation, where I select three averages at random and calculate the average of the three. I want to repeat this experiment 1,000 times.
Obviously the Data Table Function is helpful, when performing the Monte Carlo Simulation.
My problem is that I have used the Sampling Function in the Data Analysis Utility Pack, which doesn't contain a formula. hence, when running the Data Table the derived sample remains static as does the average.
I suppose I could record the function as a Macro, but I would have to repeat this 1,000 X 100 = 100,000 times, which exceeds my limit for patience.
Any suggestions?
|