{"id":8774,"date":"2021-04-01T15:10:00","date_gmt":"2021-04-01T13:10:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=8774"},"modified":"2026-10-16T15:54:10","modified_gmt":"2026-10-16T13:54:10","slug":"formula-stdev-no-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/stdev-formula-in-google-sheets\/","title":{"rendered":"Como calcular o desvio padr\u00e3o no Google Sheets"},"content":{"rendered":"

[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

Standard deviation is one of the main measures of dispersion in a dataset. It shows the spread of the data by calculating the average distance of values to the dataset\u2019s mean<\/a>, regardless of whether they are above or below it. In other words, a low standard deviation indicates that most of the values are close to the mean or average of the dataset, while a high value indicates that the values are spread out over a wider range. The formula used to calculate it is straightforward, but if you use a spreadsheet program like Microsoft Excel or Google Sheets, there are many built-in functions that will calculate it for you. In Google Sheets, the main one is STDEV<\/a>.<\/p>\n

In this guide, you will learn how to calculate standard deviation and review all the built-in functions available to calculate it for you in Google Sheets. You will learn the differences between the multiple versions of the STDEV function, like STDEVP, STDEVA, STDEVPA, DSTDEV, and DSTDEVP. You have step-by-step instructions on how to use the functions with different types of data and in combination with other functions.<\/p>\n

[\/et_pb_text][et_pb_text module_id=”how-to-find-standard-deviation-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

How to find standard deviation in Google Sheets<\/h2>\n

To calculate the standard deviation of a sample, you can use the STDEV function. Values can be typed or in the form of cell references. The function can be used on single values or arrays. When using single values, there must be a minimum of two. The next section covers its exact syntax.<\/p>\n

1. Add function<\/h3>\n

Type the STDEV function in an empty cell.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/standard-deviation-google-sheets-stdev-function.webp” alt=”Standard deviation in Google Sheets \u2014 STDEV typed in cell C2 next to the Test1 scores, with its syntax hint” title_text=”STDEV typed in cell C2 next to the Test1 scores, with its syntax hint” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

2. Select dataset<\/h3>\n

Type the values in your dataset, separated by commas. Alternatively, select the cells containing the values.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/standard-deviation-google-sheets-select-range.webp” alt=”Standard deviation in Google Sheets \u2014 STDEV with the Test1 score range in column A selected” title_text=”STDEV with the Test1 score range in column A selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

3. Get standard deviation<\/h3>\n

Close the parenthesis and press \u2018Enter\u2019.<\/p>\n

[\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/standard-deviation-google-sheets-sample-result.webp” alt=”Standard deviation in Google Sheets \u2014 sample standard deviation of 18.93 in cell C2″ title_text=”Sample standard deviation of 18.93 in cell C2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”the-standard-deviation-formula-in-google” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n

The standard deviation formula in Google Sheets<\/h2>\n

To calculate the standard deviation of a dataset, you need to sum the square of the differences between each value and the mean, then divide by the size of the dataset (population) or the size of the dataset minus one (sample). Finally, take the square root of the result.<\/p>\n

Population standard deviation formula<\/h3>\n

The formula used to calculate the standard deviation for a population is as follows:<\/p>\n

\n

\u03c3 = \u221a\u03a3( xi<\/sub> – \u03bc)^2\/N<\/p>\n<\/blockquote>\n