---
title: "How to Calculate Standard Deviation in Google Sheets"
h1: "How to Calculate Standard Deviation in Google Sheets"
description: "Learn how to effectively calculate standard deviation in Google Sheets using built-in functions. This guide will help you analyze data variability with ease."
route: "/learn/how-to-calculate-standard-deviation-in-google-sheets"
canonical: "https://www.layerpath.com/learn/how-to-calculate-standard-deviation-in-google-sheets"
---

# How to Calculate Standard Deviation in Google Sheets

Learn how to effectively calculate standard deviation in Google Sheets using built-in functions. This guide will help you analyze data variability with ease.

### Interactive Layerpath tour

Canonical tour: https://share.layerpath.com/e/cm6gq8mq6000dl70cc2stqlec/tour

Tour id: cm6gq8mq6000dl70cc2stqlec

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