Aggregate

COVAR_POP

Snowflake

Menghitung population covariance antara dua variabel numerik. Mengukur bagaimana dua variabel berubah bersama-sama.

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

COVAR_POP(y, x)

ynumericwajib

Variabel dependent (Y)

xnumericwajib

Variabel independent (X)

SQL

1 SELECT
2   ROUND(COVAR_POP(weight_kg, height_cm), 2) as height_weight_cov
3 FROM athletes;

Mengukur covariance antara tinggi dan berat badan atlet.

Hasil

125.50

SQL

1 SELECT
2   COVAR_POP(sales, advertising) as pop_covariance,
3   COVAR_SAMP(sales, advertising) as sample_covariance
4 FROM marketing_data;

COVAR_SAMP sedikit lebih besar karena menggunakan N-1 sebagai pembagi.

Hasil

POP_COVARIANCE	SAMPLE_COVARIANCE
15000.00	15150.15

1	SELECT
2	ROUND(COVAR_POP(weight_kg, height_cm), 2) as height_weight_cov
3	FROM athletes;

1	SELECT
2	COVAR_POP(sales, advertising) as pop_covariance,
3	COVAR_SAMP(sales, advertising) as sample_covariance
4	FROM marketing_data;