How to Calculate
Standard Deviation in
Google Sheets
Open Google Sheets and enter the dataset for which you want to calculate the standard deviation.
Click on an empty cell where you want the standard deviation result to appear.
Type the formula
=STDEV(range)
, replacingrange
with the actual cell range containing your data (e.g.,=STDEV(A2:A10)
).Press Enter, and Google Sheets will calculate the standard deviation for the selected data range.
If you need a sample standard deviation, use
STDEV.S()
, and for a population standard deviation, useSTDEV.P()
.Double-check the result by ensuring that the data range is correctly selected and there are no errors in the dataset.