ProductSolutionsTemplatesResources

STDEV.P

See STDEVP

Video field
Statistical

In Google Sheets, the STDEVP function is used to calculate the standard deviation of a population based on a sample of numeric values.

It considers the entire population when calculating the standard deviation.

The syntax for the STDEVP function is as follows:

STDEVP(value1, [value2, …])

value1: The first numeric value or range of values in the population.

value2: (Optional) Additional numeric values or ranges of values in the population.

You can provide multiple values or ranges as arguments to the STDEVP function. It will calculate the standard deviation for the entire population based on the given values.

Here's an example to illustrate the usage of the STDEVP function:

=STDEVP(A1:A10)

In this example, the STDEVP function calculates the standard deviation for the values in cells A1 to A10, considering the entire population.

Note that if you want to calculate the standard deviation for a sample of the population, you can use the STDEV function instead.

The STDEVP function assumes you have the complete population, while the STDEV function assumes you have a sample and adjusts the calculation accordingly.

Visit Official Docs

Want even more from Google Sheets?


With Softr, you can turn your spreadsheets into powerful web apps.You can give advanced roles and permissions to each user, build advanced logic and automation flows, customize the design to your needs, and much more.


Softr also offers a growing library of templates for internal tools, client portals, community hubs, and more. The templates come with a Google Sheet or an Airtable base that you can use to store and manage your data easily.


Try Softr now and build your custom web apps in 10 minutes – no code required!