The xllmonte add-in library

## MONTE.STDEV function |

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

Description

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.

Syntax

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.