Aggregate

VARIANCE

Snowflake

Menghitung variance (varians) sample dari nilai numerik. Variance adalah kuadrat dari standard deviation.

Tipe hasil: FLOATDiperbarui: 6 Jan 2026

Syntax

SQL

VARIANCE(expression) | VAR_SAMP(expression)

Parameter

expressionnumericwajib

Kolom atau ekspresi numerik

Contoh Penggunaan

Variance dan Standard Deviation

SQL

1 SELECT
2   VARIANCE(price) as variance_price,
3   STDDEV(price) as stddev_price,
4   SQRT(VARIANCE(price)) as stddev_from_variance
5 FROM products;

Menunjukkan hubungan antara variance dan standard deviation (STDDEV = SQRT(VARIANCE)).

Hasil

VARIANCE_PRICE	STDDEV_PRICE	STDDEV_FROM_VARIANCE
7225000000.00	85000.00	85000.00

Variance per Grup

SQL

1 SELECT
2   department,
3   COUNT(*) as employee_count,
4   ROUND(VARIANCE(salary), 2) as salary_variance
5 FROM employees
6 GROUP BY department
7 ORDER BY salary_variance DESC;

Menganalisis variasi gaji antar department.

Hasil

DEPARTMENT	EMPLOYEE_COUNT	SALARY_VARIANCE
Engineering	25	450000000.00
Sales	30	180000000.00
Marketing	20	120000000.00

VAR_SAMP vs VAR_POP

SQL

1 SELECT
2   VAR_SAMP(revenue) as sample_variance,
3   VAR_POP(revenue) as population_variance
4 FROM monthly_sales;

VAR_SAMP menggunakan (n-1) sebagai pembagi, VAR_POP menggunakan n. Untuk sample data, gunakan VAR_SAMP.

Hasil

SAMPLE_VARIANCE	POPULATION_VARIANCE
2500000000.00	2380000000.00

Fungsi Terkait

STDDEVCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISCSTDDEV_POPSTDDEV_SAMPVAR_POPVAR_SAMPMEDIANMODE

Kembali ke Snowflake Functions

1	SELECT
2	VARIANCE(price) as variance_price,
3	STDDEV(price) as stddev_price,
4	SQRT(VARIANCE(price)) as stddev_from_variance
5	FROM products;

1	SELECT
2	department,
3	COUNT(*) as employee_count,
4	ROUND(VARIANCE(salary), 2) as salary_variance
5	FROM employees
6	GROUP BY department
7	ORDER BY salary_variance DESC;

1	SELECT
2	VAR_SAMP(revenue) as sample_variance,
3	VAR_POP(revenue) as population_variance
4	FROM monthly_sales;