Variance

The variance is a measure of how spread out a distribution is. It is computed as the average squared deviation of each number from its mean.

Syntax:

Variance
Variance()
Variance(“Period”)
Variance(“OutPutStartCell”, ”Period”)

Inputs:

'Close' column values

Parameters:

• Period (default=14)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

Variance
Variance()
Variance(“14”)
Variance(14)
Variance(10)
Variance(“G2”, ”14”)
Variance(“G2”, 14)
Variance(G2, ”14”)
Variance(G2, 14)