Aggregate

STDDEV

DuckDB

Menghitung standar deviasi sampel dari nilai numerik. Mengukur seberapa tersebar data dari rata-ratanya.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

STDDEV(expression) | STDDEV_SAMP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik

Contoh Penggunaan

Standar Deviasi Harga

SQL

1 SELECT
2   AVG(price) as avg_price,
3   STDDEV(price) as price_stddev
4 FROM products;

Menghitung variabilitas harga produk.

Hasil

avg_price	price_stddev
500000	250000

Variabilitas per Kategori

SQL

1 SELECT
2   category,
3   AVG(price) as avg_price,
4   STDDEV(price) as price_stddev,
5   STDDEV(price) / AVG(price) * 100 as cv_percent
6 FROM products
7 GROUP BY category;

Menghitung coefficient of variation (CV) untuk membandingkan variabilitas antar kategori.

Hasil

category	avg_price	price_stddev	cv_percent
Electronics	2000000	1500000	75.0
Clothing	300000	150000	50.0

Fungsi Terkait

VARIANCEMEDIANMODE

Kembali ke DuckDB Functions

1	SELECT
2	AVG(price) as avg_price,
3	STDDEV(price) as price_stddev
4	FROM products;

1	SELECT
2	category,
3	AVG(price) as avg_price,
4	STDDEV(price) as price_stddev,
5	STDDEV(price) / AVG(price) * 100 as cv_percent
6	FROM products
7	GROUP BY category;