What is Standard Deviation
October 28th, 2013
TagsFinancial ModelingFinancial Modeling in Excelstandard deviationstatisticstipswhat is standard deviation
Case to Consider
If you invest in XYZ shares (assume that we are listed) you can generate an average year on year return of 25%. If I see any other stock, I would not be able to generate more than 20%. Would you invest in XYZ stocks?
If it had been the good old pre quantitative heavy investing days, I know you would have gladly invested in XYZ. But now the life is not that easy, Managers understand Risk. They dont like to invest in shares that go up and down everybody wants a stable life!
Average return (or for that matter any average), never tells you the full story. It gives you the central value of data, but does not tell you about the spread. It says that you can generate 25% return, but does not tell you that the return can be -10% to 60%, so that the average would be 25% (But you might have to exit at -10%).
So we need to measure spread (which is akin to risk!)
Measuring Spread (Risk) using Range
I love asking this question in all the workshops that I take!
If I were to ask you the simplest measure of spread, what would pop in your mind? Nay don't tell me that standard deviation or variance (95% of the times I get this as the answer)!
I would say that the simplest measure is Range [Min, Max]. It gives me a fair idea of spread.
But it again gives me only half of the story. The Minimum and Maximum might be skewed. It would be the same for data sets that are uniform, but have an extreme min and max and same for skewed data around min and max.
Excel gives simple functions to calculate Range. Min and Max.
Measuring Spread Using Standard Deviation
Just like Range gave us the simple measure of spread by telling us the Min and Max values of data, we have another measure called standard deviation (or an equivalent measure called variance) to measure spread. Standard Deviation essentially
*Measures the spread (Differences of individual data points) from the mean
*Squares the differences (So that positives and negatives all become positive)
*Takes the average of these squared differences
Excel makes your life easier. Just use the function, StdevP or VarP and show it the data. It does all the number crunching on its own!
Use StdevP for Measuring Standard Deviation
Use VarP for Measuring Variance
Reasons why Standard Deviation is very Popular
Standard deviation has its own advantages over any other measure of spread.
*It measures the deviation from the mean, which is a very important statistic (Shows the central tendency)
*It squares and makes the negative numbers Positive
*The square of small numbers is smaller (Contraction effect) and large numbers larger (Expanding effect). So it makes you ignore small deviations and see the larger one clearly!
*The square is a nice function!
Standard Deviation and Finance
Perhaps standard deviation is the most important concepts as far as finance is concerned. Finance and banking is all about measuring and managing risk and standard deviation measures risk (Volatility). Standard deviation is used by all portfolio managers to measure and track risk. One of the most important ratios in portfolio management, Sharpe Ratio (for which William Sharpe got a Nobel Prize) uses Standard Deviation to measure risk adjusted return (and hence provides incentives to portfolio managers to generate return by taking minimum risk).
The most important certifications in finance CFA and FRM also put a lot of stress on measuring and managing risk. There are scores of questions based on the concept of measuring standard deviation and related metrics.
Have you encountered any such problems? If yes, why don't you share it with us?
Templates to download
I have created a template for you, where the subheadings are given and you have to link the model to get the cash numbers! You can download the same from here. You can go through the case and fill in the yellow boxes. I also recommend that you try to create this structure on your own (so that you get a hang of what information is to be recorded).
Also you can download this filled template and check if the information you recorded matches mine or not!
If you use Excel to find standard deviation, it not only provides you with StdevP() function, but also with a plethora of other functions like: Stdev(), StdevA(), etc. You should try and understand these functions as well. In one of the next tutorials, we will delve deeper into these functions.
For any queries regarding the concepts or modeling in Excel, feel free to put your comments in the blog or write an email to firstname.lastname@example.org
The article is written by EduPristine (www.edupristine.com). There will be a step by step analysis and construction of a financial model to come to a conclusion on the investment decision.
About the Author
Anil Bains has developed end-to-end financial models for Real Estate, FMCG, Power, Roads and Telecom Sector and released them as Open Source. He has extensive experience in the financial services, analytics and training domain. Apart from making Financial Modeling simple and accessible for the masses, Anil loves playing volleyball and has a mean spike.
FREE 10 days
- about edupristine
- about pristine
- Business Analytics
- career guidance
- Career in Finance
- CFA Concept Checkers
- CFA exam prep
- CFA exam updates
- CFA high scoring tips
- CFA level 1 and 2
- CFA practice test
- Chartered Financial Analyst (CFA)
- classes updates
- current affairs learning
- Detailed CFA blogs
- Diagnose FRM
- edupristine new updates
- exam tips
- Excel FRM
- Fin mod templates
- Financial Modeling
- Financial modeling concept checkers
- Financial Modeling Templates
- Financial Risk Manager (FRM)
- Free Quizzes
- FRM concept checkers
- FRM exam analysis
- FRM exam prep
- FRM exam updates
- FRM expert interviews
- FRM Interviews
- FRM Questions and Answers
- GARP and FRM news
- General updates
- job openings
- job profiles
- jobs in finance
- Learning systems updates
- News and Discussion
- open source financial models
- other courses
- other job openings
- pristine new updates
- Professional Risk Manager (PRM)
- Project Management
- Questions of the day
- Tips and Material
- Value at Risk (VAR)
- webinar blogs
- webinar updates
- webinar updates