Financial Modeling Tutorials

- Financial Modeling Basics
- Excel Modeling
- Financial Functions in Excel
- Sensitivity Analysis in Excel
- Sensitivity Analysis
- Capital Budgeting Techniques
- Time Value of Money
- Future Value Formula
- Present Value Factor
- Perpetuity Formula
- Present Value vs Future Value
- Annuity vs Pension
- Present Value of an Annuity
- Doubling Time Formula
- Annuity Formula
- Annuity vs Perpetuity
- Annuity vs Lump Sum
- Deferred Annuity Formula
- Internal Rate of Return (IRR)
- IRR Examples (Internal Rate of Return)
- NPV vs XNPV
- NPV vs IRR
- NPV Formula
- NPV Profile
- NPV Examples
- PV vs NPV
- IRR vs ROI
- Break Even Point
- Payback Period & Discounted Payback Period
- Payback period Formula
- Discounted Payback Period Formula
- Profitability Index
- Cash Burn Rate
- Simple Interest
- Simple Interest vs Compound Interest
- Simple Interest Formula
- CAGR Formula (Compounded Annual Growth Rate)
- Effective Interest Rate
- Loan Amortization Schedule
- Mortgage Formula
- Loan Principal Amount
- Interest Rate Formula
- Rate of Return Formula
- Effective Annual Rate
- Effective Annual Rate Formula (EAR)
- Daily Compound Interest
- Monthly Compound Interest Formula
- Discount Rate vs Interest Rate
- Rule of 72
- Geometric Mean Return
- Real Rate of Return Formula
- Continuous compounding Formula
- Weighted average Formula
- Average Formula
- Average Rate of Return Formula
- Mean Formula
- Mean Examples
- Population Mean Formula
- Weighted Mean Formula
- Harmonic Mean Formula
- Median Formula in Statistics
- Range Formula
- Outlier Formula
- Decile Formula
- Midrange Formula
- Quartile Deviation
- Expected Value Formula
- Exponential Growth Formula
- Margin of Error Formula
- Decrease Percentage Formula
- Percent Error Formula
- Holding Period Return Formula
- Cost Benefit Analysis
- Cost Benefit Analysis Examples
- Cost Volume Profit Analysis
- Opportunity Cost Formula
- Opportunity Cost Examples
- Mortgage APR vs Interest Rate
- Normal Distribution Formula
- Standard Normal Distribution Formula
- Normalization Formula
- Bell Curve
- T Distribution Formula
- Regression Formula
- Regression Analysis Formula
- Multiple Regression Formula
- Correlation Coefficient Formula
- Correlation Formula
- Population Variance Formula
- Covariance Formula
- Coefficient of Variation Formula
- Sample Standard Deviation Formula
- Relative Standard Deviation Formula
- Standard Deviation Formula
- Volatility Formula
- Binomial Distribution Formula
- Quartile Formula
- P Value Formula
- Skewness Formula
- R Squared Formula
- Adjusted R Squared
- Regression vs ANOVA
- Z Test Formula
- F-Test Formula
- Quantitative Research

Related Courses

**Formula of Standard Deviation (Table of Contents)**

## What is Standard Deviation Formula?

Standard deviation tells us how off are the numbers from the mean or the average. Standard deviation formula tells us the variance of returns of a portfolio or the case how far is the variance of the data set is from the mean.

- Standard deviation is most widely used and practiced in portfolio management services and fund managers often use this basic method to calculate and justify their variance of returns in a particular portfolio.
- A high standard deviation of a portfolio signifies the there is a large variance in a given number of stocks in a particular portfolio whereas, on the other hand, a low standard deviation signifies a less variance of stock among themselves.
- A risk-averse investor will only be willing to take any additional risk if he or she is compensated by an equal or a larger amount of return in order to take that particular risk.
- A more risk-averse investor may not be comfortable with his standard deviation and would want to add in safer investment such government bonds or large-cap stocks in its portfolio or mutual funds for that matter in order to diversify the risk of the portfolio and its standard deviation and variance.
- The variance and the closely-related standard deviation are measures of how spread out a distribution is. In other words, they are measures of variability.

### Explanation of Standard Deviation Formula

The formula for Standard Deviation is

Where:

- xi = Value of each data point
- x̄ = Mean
- N = Number of data points

### Steps to calculate Standard Deviation

**Step 1:**First, the mean of the observations is calculated just like the average adding all the data points available in a data set and dividing it by the number of observations.**Step 2:**Then the variance from each data point is measured with the mean it can come as a positive or negative number then the value is squared and the result is subtracted by one.**Step 3:**The square of the variance which is calculated from step 2 is then taken to calculate the standard deviation.

### Examples of Standard Deviation Formula (with Excel Template)

Let’s take an example to understand the calculation of the standard deviation equation in a better manner.

#### Example 1

**The data points are given 1,2 and 3. What is the standard deviation of the given data set?**

4.9 (927 ratings)

**Solution:**

Use the following data for the calculation of the standard deviation

So, the calculation of variance will be –

**Variance = 0.67**

The calculation of standard deviation will be –

**Standard Deviation = 0.33**

#### Example #2

**Find the standard deviation of 4,9,11,12,17,5,8,12,14.**

**Solution:**

Use the following data for the calculation of the standard deviation

The calculation of mean will be –

First, find the mean of the data point 4+9+11+12+17+5+8+12+14/9

**Mean = 10.22**

So, the calculation of variance will be –

The variance will be –

**Variance = 15.51**

The calculation of standard deviation will be –

**Standard Deviation = 3.94**

Variance = Square root of standard deviation

#### Example #3

Use the following data for the calculation of the standard deviation

So, the calculation of variance will be –

**Variance = 132.20**

The calculation of standard deviation will be –

** Standard Deviation = 11.50**

This type of calculation is frequently being used by portfolio managers to calculate the risk and return of the portfolio.

### Relevance and Uses

- Standard deviation is helpful is analyzing the overall risk and return a matrix of the portfolio and being historically helpful it is widely used and practiced in the industry the standard deviation of the portfolio can be impacted by the correlation and the weights of the stocks of the portfolio.
- As the correlation of the two asset classes in a portfolio reduces the risk of the portfolio, in general, reduces it is however not necessary all the time that equally weighted portfolio provide the least risk among the universe.
- A high Standard Deviation may be a measure of volatility, but it does not necessarily mean that such a fund is worse than one with a low Standard Deviation. If the first fund is a much higher performer than the second one, the deviation will not matter much.
- Standard deviation is also used in statistics and is widely taught by professors among various top universities in the world however the formula for standard deviation is changed when it is used to calculate the deviation of the sample.
- The formula for SD in Sample = just the denominator is reduced by 1

### Recommended Articles

This has been a guide to Standard Deviation Formula. Here we learn how to calculate standard deviation using its formula along with practical examples and downloadable excel template. You can learn more about financial modeling from the following articles –

- Examples of the Correlation in Statistics
- Standard Deviation Excel Formula
- Formula of Sample Standard Deviation
- Formula of Relative Standard Deviation
- Standard Deviation Excel Graph

- 35+ Courses
- 120+ Hours of Videos
- Full Lifetime Access
- Certificate of Completion

- Basic Microsoft Excel Training
- MS Excel 2010 Training Course: Advanced
- Microsoft Excel Basic Training
- Microsoft Excel 2013 – Advanced
- Microsoft Excel 2016 – Beginners
- Microsoft Excel 2016 – Advanced

## Leave a Reply