View Single Post
 
Old 08-09-2016, 09:17 AM
ulrik_walther@msn.com ulrik_walther@msn.com is offline Mac OS X Office v. X
Novice
 
Join Date: Aug 2016
Posts: 1
ulrik_walther@msn.com is on a distinguished road
Default 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?
Reply With Quote