Click or drag to resize

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.