#1
|
|||
|
|||
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? |
Tags |
monte carlo, sampling |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Random with Kurtosis | ramesh31 | Excel | 0 | 02-18-2016 03:45 AM |
Random Name Generator | knp11 | Word | 1 | 01-18-2015 11:41 AM |
Moving averages of data points with a changing sampling interval | jrosen | Excel | 3 | 10-23-2014 06:26 AM |
Random indentation | Galahad | Word | 1 | 09-25-2013 11:05 AM |
random pop up wont go away | 464646 | OneNote | 0 | 05-01-2012 04:34 AM |