Random Walk
Simulating Random Walk in Excel
Garg University
Step 1: Make a random, fractional value:
delta_1 = 1-2*rand()
delta_2 = 1-2*rand()
....
delta_n = 1-2*rand()
Step 2: Make one or more vectors of random values, depending on how many parameters you are varrying.
Step 3: Determine your initial values for the simulation.
condition_1_i = condition_1_(i-1) + delta_1_i
condition_2_i = condition_2_(i-1) + delta_2_i
...
condition_1_n = condition_n_(i-1) + delta_n_i
Python Ideas
I think that I could do this in Python by itself, or also in Excel Wings.
It would be fun to start off with the Hyperbolic Model.
http://www.fekete.com/SAN/WebHelp/FeketeHarmony/Harmony_WebHelp/Content/HTML_Files/Reference_Material/Analysis_Method_Theory/Traditional_Decline_Theory.htm
I will (1) start with fake data, then (2) fit to it, and then (3) test my script out on real data.
If it works, then I will compile the script and set it up as a stand alone equation.
