MONTE.STDEV function

This article describes the formula syntax of the MONTE.STDEV function.


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


MONTE.STDEV(cell, _reset)

cell is a reference to a cell whos mean and stdev is to be computed.
_reset is an optional boolean to reset the calculation.

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. If the output range has three cells then the third cell is used to store the count. This is required if the mean and standard deviation are _reset during a simulation.