---
schema_version: "1"
id: e1b2538a59c68b3d129255441e9b360a8e51f7c9f46439f84b1d3f4f9e2caca1
title: COVAR_POP
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/aggregate-func/covar-pop.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/covar-pop.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: a98dcec5a71ef1359b9ed8c091def611c507993c830610aaf10a67eea3cb57ff
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# `COVAR_POP`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Computes the population covariance between two sets of values.

## Syntax

```sql
covar_pop(<Y>, <X>)
```

## Arguments

### Required

- `<Y>`: A `double precision` expression.
- `<X>`: A `double precision` expression.

## Returns

Returns a `double precision` value representing the population covariance. Returns NULL if the computation is meaningless.

## Considerations

- Returns NULL if there are no rows where both X and Y are non-null.
- Population covariance uses N in the denominator.
- Use `COVAR_SAMP` for sample covariance (uses N-1 in the denominator).

## Examples

### Calculate Population Covariance

Find the population covariance between two variables.

```sql
SELECT covar_pop(height, weight) AS covariance
FROM measurements;
```

### Covariance by Group

Calculate covariance for each group.

```sql
SELECT region, covar_pop(sales, temperature) AS sales_temp_cov
FROM regional_data
GROUP BY region;
```

## Related Documentation

- [COVAR_SAMP](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/covar-samp.md)
- [CORR](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/corr.md)
- [Aggregate Functions](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/aggregate.md)