There is a built-in formula for calculating standard deviation of a dataset in Google sheets. The formula to achieve this goal is given below.

** =STDEV(value1, [value2, …])**

In this formula, select the first value and select the value for which you wish to calculate standard deviation. You can select a data range also. Steps are given below to calculate the standard deviation.

Google sheet is a powerful tool for data calculation and data manipulations. Google sheets are enriched with a lot of functions and tools to conduct mathematical and statistical calculations.

### Step 1 – Select the cell and apply formula

Above is an animation as an example.

– Select any cell and which you like to calculate standard deviation.

– Type the formula.

– Select the first cell and drag it to the last cell of your data range.

– Or simply type the first cell number followed by the colon(:) and last cell number of data range.

– Close the bracket.

– As soon as you press the enter key it will calculate standard deviation.