Standard Deviation

Standard Deviation is a measure of the dispersion of a set of data from its mean. The more spread apart the data is, the higher the deviation.

In finance, standard deviation is applied to the annual rate of return of an investment to measure the investment's volatility (risk).

Syntax:

StandardDeviation
StandardDeviation()
StandardDeviation(“Period”)
StandardDeviation(“OutPutStartCell”, ”Period”)

Inputs:

'Close' column values

Parameters:

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

Examples:

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