Aggregate

STDDEV_POP

MySQL

Menghitung standar deviasi populasi dari nilai-nilai numerik. Menggunakan pembagi N (jumlah total observasi).

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

STDDEV_POP(expr)

exprnumericwajib

Ekspresi numerik untuk menghitung standar deviasi populasi

SQL

1 SELECT STDDEV_POP(height) AS height_stddev_pop
2 FROM all_students;

Menghitung standar deviasi tinggi semua siswa (populasi penuh).

Hasil

height_stddev_pop: 12.5

SQL

1 SELECT 
2   STDDEV_POP(value) AS pop_std,
3   STDDEV_SAMP(value) AS samp_std
4 FROM measurements;

Membandingkan standar deviasi populasi dan sampel.

Hasil

pop_std: 10.2, samp_std: 10.5

SQL

1 SELECT region,
2        STDDEV_POP(income) AS income_variation
3 FROM census_data
4 GROUP BY region;

Mengukur variasi pendapatan per wilayah.

Hasil

Jakarta: 5000000, Surabaya: 3500000

STDDEV_POP

Snowflake

STDDEV_POP

BigQuery

1	SELECT STDDEV_POP(height) AS height_stddev_pop
2	FROM all_students;

1	SELECT region,
2	STDDEV_POP(income) AS income_variation
3	FROM census_data
4	GROUP BY region;