Standard Deviation
Standard Deviation is a statistical measure of volatility. Standard Deviation is typically used as a component of other indicators, rather than as a stand-alone indicator. For example, Bollinger Bands are calculated by adding a security's Standard Deviation to a moving average.
High Standard Deviation values occur when the data item being analyzed (e.g., prices or an indicator) is changing dramatically. Similarly, low Standard Deviation values occur when prices are stable.
Many analysts feel that major tops are accompanied with high volatility as investors struggle with both euphoria and fear. Major bottoms are expected to be calmer as investors have few expectations of profits.
Standard Deviation(Parameters)
- Range. Any range of data, e.g. array of Close, Low prices, Volume, etc.
- Output range. The cell reference for the range of output data.
Standard Deviation(Syntax)
StdDev(RANGE;PERIOD;DIRECTION)
Example
=StdDev(A1:A10;10;0)
|
