Aggregate

VARIANCE

MySQL

Menghitung varians populasi dari nilai-nilai numerik. Varians mengukur seberapa jauh data tersebar dari nilai rata-rata.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

VARIANCE(expr)

exprnumericwajib

Ekspresi numerik untuk menghitung varians

SQL

1 SELECT VARIANCE(price) AS price_variance FROM products;

Menghitung varians harga semua produk.

Hasil

price_variance: 15750.25

SQL

1 SELECT category, VARIANCE(rating) AS rating_var
2 FROM products
3 GROUP BY category;

Mengukur variasi rating per kategori.

Hasil

Electronics: 0.64, Clothing: 1.44

SQL

1 SELECT 
2   VARIANCE(salary) AS var_salary,
3   STD(salary) AS std_salary,
4   SQRT(VARIANCE(salary)) AS calculated_std
5 FROM employees;

Membuktikan bahwa VARIANCE = STD^2.

Hasil

var_salary: 64000000, std_salary: 8000

1	SELECT category, VARIANCE(rating) AS rating_var
2	FROM products
3	GROUP BY category;

1	SELECT
2	VARIANCE(salary) AS var_salary,
3	STD(salary) AS std_salary,
4	SQRT(VARIANCE(salary)) AS calculated_std
5	FROM employees;