Click or drag to resize


Calculate the mean and standard deviation of x over a simulation.


Calculate the running mean and standard deviation over the course of a simulation. This is an array formula that requires at least two output cells to hold the mean and standard deviation.


MONTE.STDEV(x, reset?)

  • x is the number whos mean and stdev is to be computed.

  • reset? is an optional boolean to reset the calculation.