Aggregate

STDDEV_POP

Snowflake

Menghitung population standard deviation dari nilai numerik. Menggunakan N sebagai pembagi (bukan N-1 seperti STDDEV_SAMP).

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

STDDEV_POP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik

Contoh Penggunaan

Population Standard Deviation

SQL

1 SELECT
2   STDDEV_POP(score) as population_stddev,
3   STDDEV_SAMP(score) as sample_stddev
4 FROM exam_results
5 WHERE class_id = 'CLASS-A';

Jika CLASS-A adalah seluruh populasi (bukan sample), gunakan STDDEV_POP.

Hasil

POPULATION_STDDEV	SAMPLE_STDDEV
14.89	15.25

Analisis Variasi Harga per Region

SQL

1 SELECT
2   region,
3   ROUND(AVG(price), 2) as avg_price,
4   ROUND(STDDEV_POP(price), 2) as stddev_pop,
5   ROUND(STDDEV_POP(price) / AVG(price) * 100, 2) as cv_percent
6 FROM all_products
7 GROUP BY region;

Menganalisis variasi harga di setiap region menggunakan population stddev.

Hasil

REGION	AVG_PRICE	STDDEV_POP	CV_PERCENT
APAC	150000	45000	30.00
EMEA	180000	36000	20.00
AMER	200000	50000	25.00

Fungsi Terkait

STDDEVSTDDEV_SAMPVARIANCEVAR_POPVAR_SAMPCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCMEDIANMODE

Kembali ke Snowflake Functions

1	SELECT
2	STDDEV_POP(score) as population_stddev,
3	STDDEV_SAMP(score) as sample_stddev
4	FROM exam_results
5	WHERE class_id = 'CLASS-A';

1	SELECT
2	region,
3	ROUND(AVG(price), 2) as avg_price,
4	ROUND(STDDEV_POP(price), 2) as stddev_pop,
5	ROUND(STDDEV_POP(price) / AVG(price) * 100, 2) as cv_percent
6	FROM all_products
7	GROUP BY region;