Aggregate

STDDEV

Snowflake

Menghitung standard deviation (simpangan baku) sample dari nilai numerik. Mengukur seberapa tersebar data dari nilai rata-ratanya.

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

STDDEV(expression) | STDDEV_SAMP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik

Contoh Penggunaan

Standard Deviation Harga

SQL

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

Menghitung rata-rata dan standard deviation harga produk.

Hasil

AVG_PRICE	STDDEV_PRICE
125000.00	85000.50

Analisis Variabilitas per Kategori

SQL

1 SELECT
2   category,
3   COUNT(*) as count,
4   ROUND(AVG(price), 2) as avg_price,
5   ROUND(STDDEV(price), 2) as stddev_price,
6   ROUND(STDDEV(price) / AVG(price) * 100, 2) as cv_percent
7 FROM products
8 GROUP BY category
9 ORDER BY cv_percent DESC;

Menghitung Coefficient of Variation (CV) untuk melihat kategori mana yang paling bervariasi harganya.

Hasil

CATEGORY	COUNT	AVG_PRICE	STDDEV_PRICE	CV_PERCENT
Electronics	50	500000	350000	70.00
Clothing	100	150000	75000	50.00

STDDEV_SAMP vs STDDEV_POP

SQL

1 SELECT
2   STDDEV_SAMP(score) as sample_stddev,
3   STDDEV_POP(score) as population_stddev
4 FROM test_scores;

STDDEV_SAMP untuk sample (n-1), STDDEV_POP untuk populasi (n). Gunakan SAMP jika data adalah sample.

Hasil

SAMPLE_STDDEV	POPULATION_STDDEV
15.25	14.89

Fungsi Terkait

VARIANCECORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCSTDDEV_POPSTDDEV_SAMPVAR_POPVAR_SAMPMEDIANMODE

Kembali ke Snowflake Functions

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

1	SELECT
2	category,
3	COUNT(*) as count,
4	ROUND(AVG(price), 2) as avg_price,
5	ROUND(STDDEV(price), 2) as stddev_price,
6	ROUND(STDDEV(price) / AVG(price) * 100, 2) as cv_percent
7	FROM products
8	GROUP BY category
9	ORDER BY cv_percent DESC;

1	SELECT
2	STDDEV_SAMP(score) as sample_stddev,
3	STDDEV_POP(score) as population_stddev
4	FROM test_scores;