Sample Standard Deviation Formula

Formula to Calculate Sample Standard Deviation

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 and it 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 in excelSquare Root In ExcelThe Square Root function is an arithmetic function built into Excel that is used to determine the square root of a given number. To use this function, type the term =SQRT and hit the tab key, which will bring up the SQRT function. Moreover, this function accepts a single argument.read more of the result.

Mathematically, it is represented as,

σ = √ ∑in (xi – X)2 / (n-1)
Sample-Standard-Deviation-Formula

You are free to use this image on your website, templates etc, Please provide us with an attribution linkHow to Provide Attribution?Article Link to be Hyperlinked
For eg:
Source: Sample Standard Deviation Formula (wallstreetmojo.com)

where

  • xi = ith random variable
  • X = Mean of the sample
  • n = number of variables in the sample

Calculation of Sample Standard Deviation (Step by Step)

Lets start.

  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 xi.

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

  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.


    Sample Standard deviation formula2

  4. Next, compute the difference between each variable of the sample and the sample mean, i.e., xi – x.

  5. Next, calculate the square of all the deviations, i.e. (xi – x)2.

  6. Next, add all the of the squared deviations, i.e. ∑ (xi – x)2.

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

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


    Sample Standard deviation formula

Examples

You can download this Sample Standard Deviation Formula Excel Template here – Sample Standard Deviation Formula Excel Template

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 the calculation of sample standard deviation.

 example1

Sample Mean

Calculation of Sample mean

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

 example1.1jpg

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)}
 example1.2jpg

Deviation will be –

Sample Standard deviation formula example1.3jpg
  • ơ = 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
Sample Standard deviation formula example2

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 Standard deviation formula example2.1

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)}
 example2.2jpg

Deviation will be –

Sample Standard deviation formula example2.3jpg
  • ơ = 4.78

You can refer to the given excel sheet above to understand the detailed 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 a downloadable excel template. You can learn more about excel modeling from the following articles –

Reader Interactions

Leave a Reply

Your email address will not be published. Required fields are marked *