# Help in generating brownian motion in excel

• May 2nd 2010, 10:06 AM
Redeemer_Pie
Help in generating brownian motion in excel
Hello all,

Can some tell me how to generate a brownian motion in Excel?

I have to generate the values of the brownian motion at points $t_i = \frac{i}{100}$ i = 0,...,100 and plot them.

Assume there are independent and normally distributed so that:

$B(t_{i+1}) - B(t_i) = Z_i\sqrt{t_{i+1} - t_i}$ where:

$Z_i$ is a sequence of standard normal variables.

Hope you can clear this up. Im not much of a tech nerd! Thanks! :)