Aggregate

VAR_POP

Snowflake

Menghitung population variance dari nilai numerik. Menggunakan N sebagai pembagi untuk menghitung varians populasi lengkap.

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

VAR_POP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik yang akan dihitung variansnya

Contoh Penggunaan

Population Variance

SQL

1 SELECT
2   VAR_POP(temperature) as population_variance,
3   VAR_SAMP(temperature) as sample_variance
4 FROM weather_readings
5 WHERE station_id = 'ST001';

Menghitung variance populasi untuk semua reading dari satu station.

Hasil

POPULATION_VARIANCE	SAMPLE_VARIANCE
25.50	26.00

Variance per Grup

SQL

1 SELECT
2   product_line,
3   COUNT(*) as count,
4   ROUND(VAR_POP(unit_cost), 2) as cost_variance
5 FROM manufacturing_data
6 GROUP BY product_line
7 ORDER BY cost_variance DESC;

Menganalisis variasi biaya produksi per product line.

Hasil

PRODUCT_LINE	COUNT	COST_VARIANCE
Premium	500	125.50
Standard	1200	45.25
Budget	800	15.00

Fungsi Terkait

STDDEVSTDDEV_POPSTDDEV_SAMPVARIANCEVAR_SAMPCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCMEDIANMODE

Kembali ke Snowflake Functions

1	SELECT
2	VAR_POP(temperature) as population_variance,
3	VAR_SAMP(temperature) as sample_variance
4	FROM weather_readings
5	WHERE station_id = 'ST001';

1	SELECT
2	product_line,
3	COUNT(*) as count,
4	ROUND(VAR_POP(unit_cost), 2) as cost_variance
5	FROM manufacturing_data
6	GROUP BY product_line
7	ORDER BY cost_variance DESC;