How to calculate the standard deviation & mean of data in Google Sheets

When there is a set of numerical values in a sheet, it is often important to find the mean of such values. While it is easy to find the mean, it is again important to find the standard deviation of the set of values in the sheet. Standard deviation aka. SD is the measurement of how close or spread out the individual values are, from the mean. 

Finding the standard deviation is important in statistical calculations, and often in various day-to-day activities in different sectors. If you use Google Sheets to organize your data, you should know how to find the standard deviation of a set of values in Google Sheets, and today I will discuss that along with how to calculate the mean value on How2shout.

So, without any further delay, let’s get started with how to find the standard deviation of a set of numbers in Google Sheets.

Calculating the standard deviation

While you can first find the mean, subtract the mean from the individual values, find the square of results, sum them, and divide the result again by one less than the number of values, to find the standard deviation, this can easily turn out extremely complex, if there are hundreds of values.

While you can use nested formulas, that is also complex, to say the least, the best you can do is, use the formula that is already present in Google Sheets and get the job done right away.

Say, for example, you have the set of values in column B, the values are in cells in the range B2 to B10, and you want the SD or standard deviation in B11, the formula in B11 will go as follows.

=STDEV(B2:B10)

So, that’s how easy it is to find the standard deviation of a set of values in Google Sheets. 

Calculating the mean value

Just like it is often important to find the Standard deviation or SD, you can also find the mean of the same set of values using the MEDIAN function.

The syntax is simple, and it goes as follows.

=MEDIAN(B2:B10)

This will help you find the mean of the same set of values.

So, that’s how to find the Standard deviation and the mean of a set of values in Google Sheets. Do you have any questions? Feel free to comment on the same below.

Other Articles:

• How to format Google Sheets cells to use the Rupee (₹) symbol
• How to create a sortable table in Google Sheets to organize data
• Copy the formatting in Google Sheets app, like the Paint format tool
• Make a funnel chart in Google Sheets without any third-party extension