Aggregate

VARIANCE

DuckDB

Menghitung varians sampel dari nilai numerik. Varians adalah kuadrat dari standar deviasi.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

VARIANCE(expression) | VAR_SAMP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik

Contoh Penggunaan

Varians Nilai Ujian

SQL

1 SELECT
2   subject,
3   AVG(score) as avg_score,
4   VARIANCE(score) as score_variance,
5   STDDEV(score) as score_stddev
6 FROM exam_results
7 GROUP BY subject;

Menganalisis penyebaran nilai ujian per mata pelajaran.

Hasil

subject	avg_score	score_variance	score_stddev
Math	75	225	15
Science	80	100	10

Perbandingan Varians

SQL

1 SELECT
2   VARIANCE(salary) as salary_variance,
3   VAR_POP(salary) as salary_var_pop
4 FROM employees;

Membandingkan sample variance dan population variance.

Fungsi Terkait

STDDEVMEDIANMODE

Kembali ke DuckDB Functions

1	SELECT
2	subject,
3	AVG(score) as avg_score,
4	VARIANCE(score) as score_variance,
5	STDDEV(score) as score_stddev
6	FROM exam_results
7	GROUP BY subject;

1	SELECT
2	VARIANCE(salary) as salary_variance,
3	VAR_POP(salary) as salary_var_pop
4	FROM employees;