Question: 5. Use excel to replicate a simple random walk. Do this as follows: Draw a uniform random variable from (0,1). Check if the random variable

5. Use excel to replicate a simple random walk. Do this as follows: Draw a uniform random variable from (0,1). Check if the random variable is 0.5 then, Ri-R-11. Starting with Ro 0, plot the random walk for up to i 100; 1,000 and 10, 000 steps. Ri is the winning bet on the outcome of the random variable. Please read rand() function in excel 5. Use excel to replicate a simple random walk. Do this as follows: Draw a uniform random variable from (0,1). Check if the random variable is 0.5 then, Ri-R-11. Starting with Ro 0, plot the random walk for up to i 100; 1,000 and 10, 000 steps. Ri is the winning bet on the outcome of the random variable. Please read rand() function in excel
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
