Semi-Variance and Semi-Deviation – Excel template

Ned Krastev
Ned Krastev

The semi-variance is the average of the squared deviations of values that are less than the mean.

Semi-variance is useful when studying events that lie below the mean.

Some other related topics you might be interested to explore are Variance and Standard Deviation.

This is an open-access Excel template in XLSX format that will be useful for anyone who wants to work as a Statistician, Data Analyst, Data Scientist, or Asset Manager.

You can now download the Excel template for free.

Semi-Variance and Semi-Deviation are among the topics included in the Quantitative Methods module of the CFA Level 1 Curriculum.