Standard Deviation Formula in Google Sheets: A Practical Guide

Understanding standard deviation in Google Sheets

Standard deviation is a measure of how spread out numbers are in a dataset. In Google Sheets, you typically decide whether your data represents a sample or the entire population and then choose the corresponding function. According to How To Sheets, knowing the difference helps you avoid under- or over-estimating variability when you generalize results to a larger group. The most common starting point is to use the two core functions: STDEV.S for a sample and STDEV.P for a population. These functions compute the square root of the average of squared deviations from the mean, yielding a single number that summarizes dispersion. In practice, you’ll often apply these to columns of data with a single formula and then drag to fill down if needed. The general approach remains the same regardless of your data size.

This computes the sample standard deviation for values in A2 through A100. If your data represents the entire population, switch to the population variant.