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

**Table of Contents**

## What is the Sample Standard Deviation Formula?

The term “sample standard deviation” refers to the statistical metric that is used to measure the extent by which a random variable diverges from the mean of the sample. The formula for sample standard deviation is calculated by adding the squares of the deviation of each variable from the mean, then divide the result by a number of variables minus and then computing the square root of the result.

Mathematically, it is represented as,

where

- x
_{i}= i^{th}random variable - X = Mean of the sample
- n = Number of variables in the sample

### Explanation

The equation can be derived by using the following steps:

**Step 1:** Firstly, gather random variables from a population of a large number of variables. These variables will form a sample. The variables are denoted by x_{i}.

**Step 2:** Next, determine the number of variables in the sample and it is denoted by n.

**Step 3:** Next, determine the mean of the sample by adding all the random variables and dividing the result by the number of variables in the sample. The sample mean is denoted by x.

**Step 4:** Next, compute the difference between each variable of the sample and the sample mean i.e. x_{i} – x.

**Step 5: **Next, calculate the square of all the deviations i.e. (x_{i} – x)^{2}.

**Step 6:** Next, add all the of the squared deviations i.e. ∑ (x_{i} – x)^{2}.

4.9 (927 ratings)

**Step 7:** Next, divide the summation of all the squared deviations by the number of variables in the sample minus one i.e. (n – 1).

**Step 8:** Finally, the equation for sample standard deviation is calculated by computing the square root of the above-mentioned result as shown below.

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

Let’s see some simple to advanced examples of a Sample Standard Deviation Formula to understand it better.

#### Example #1

**Let us take the example of a sample of 5 students who were surveyed to see how many pencils they were using every week. Calculate the sample standard deviation of based on their given responses: 3, 2, 5, 6, 4**

Given,

- Sample size (n) = 5

Below is given data for calculation of sample standard deviation.

**Sample Mean**

Calculation of Sample mean

Sample mean = (3 + 2 + 5 + 6 + 4) / 5

**Sample Mean = 4**

The squares of the deviations of each variable can be calculated as below,

- (3 – 4)
^{2}= 1 - (2 – 4)
^{2}= 4 - (5 – 4)
^{2}= 1 - (6 – 4)
^{2}= 4 - (4 – 4)
^{2}= 0

Now, the sample standard deviation can be calculated by using the above formula as,

- ơ = √ {(1 + 4 + 1 + 4 + 0) / (5 – 1)}

**Deviation will be –**

**ơ = 1.58**

Therefore, the sample standard deviation is 1.58.

#### Example #2

**Let us take the example of an office in New York where around 5,000 people work and a survey has been carried out on a sample of 10 people to determine the average age of the working population. Determine the sample standard deviation based on the ages of the 10 people given: 23, 27, 33, 28, 21, 24, 36, 32, 29, 25**

Given,

- Sample size(n) = 10

By using the above data we will first calculate the sample mean

**Sample Mean**

Calculation of Sample Mean

= (23 + 27 + 33 + 28 + 21 + 24 + 36 + 32 + 29 + 25) / 10

**Sample Mean = 27.8**

The squares of the deviations of each variable can be calculated as below,

- (23 – 27.8)
^{2}= 23.04 - (27 – 27.8)
^{2}= 0.64 - (33 – 27.8)
^{2}= 27.04 - (28 – 27.8)
^{2}= 0.04 - (21 – 27.8)
^{2}= 46.24 - (24 – 27.8)
^{2}= 14.44 - (36 – 27.8)
^{2}= 67.24 - (32 – 27.8)
^{2}= 17.64 - (29 – 27.8)
^{2}= 1.44 - (25 – 27.8)
^{2}= 7.84

**Deviation**

Now, the deviation can be calculated by using the above formula as,

- ơ = √ {(23.04 + 0.64 + 27.04 + 0.04 + 46.24 +14.44 +67.24 + 17.64 + 1.44 + 7.84) / (10 – 1)}

**Deviation will be –**

**ơ = 4.78**

You can refer the given excel sheet below to understand the detail calculation.

### Relevance and Uses

The concept of sample standard deviation is very important from the perspective of a statistician because usually a sample of data is taken from a pool of large variables (population) from which the statistician is expected to estimate or generalize the results for the entire population. The measure of standard deviation is no exception to this and hence, the statistician has to make an assessment of the population standard deviation on the basis of the sample drawn, and that is where such deviation comes into play.

### Recommended Articles

This has been a guide to Sample Standard Deviation Formula. Here we discuss the calculation of sample standard deviation along with examples and downloadable excel template. You can learn more about excel modeling from the following articles –

- Adjusted R Squared | Examples
- Excel R Squared Formula
- ROUND Formula in Excel
- Standard Deviation Formula in Excel
- Relative Standard Deviation Formula
- How to Calculate Portfolio Standard Deviation?
- Standard Deviation Excel Graph
- Compare Variance vs Standard Deviation
- Variance Analysis Calculation Formula

- 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