---
schema_version: "1"
id: ee62aa627eae8125483068ecb14eb2048c9d4f6add3e363d00556acaafebcf12
title: stddevp()
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/analytics/bi_dev_guide_saql/guides/concept/bi-saql-fn-agg-stdevp.md
canonical_url: https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-stdevp.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: f413d080bb8bd2a5e5fd1a9ac7c8965b8ca018d3b7769730c4363ab7f417dfee
products:
  - Analytics SAQL Developer Guide
  - analytics
---

# stddevp()

Returns the population standard deviation of the values in a field. Accepts measure fields as input but not expressions.

## Example - Calculate the Population Standard Deviation of Amount

Use `stddevp()` to calculate the population standard deviation of the amount of each opportunity. Group by product family to see which type of product has the greatest variability in deal size.

```nolang
q = load "DTC_Opportunity_SAMPLE";
q = group q by 'Product_Family';
q = foreach q generate 'Product_Family' as 'Product_Family', stddevp('Amount') as 'stddevp_Amount';
```

**See Also**

- [stddev()](https://developer.salesforce.com/docs/analytics/bi-dev-guide-saql/guide/bi-saql-fn-agg-stdev.md)