Aggregate

VAR_SAMP

MySQL

Menghitung varians sampel dari nilai-nilai numerik. Menggunakan pembagi N-1 (koreksi Bessel) untuk estimasi yang tidak bias.

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

VAR_SAMP(expr)

exprnumericwajib

Ekspresi numerik untuk menghitung varians sampel

SQL

1 SELECT VAR_SAMP(test_score) AS score_variance
2 FROM sample_students;

Menghitung varians dari sampel nilai siswa.

Hasil

score_variance: 349.69

SQL

1 SELECT question_id,
2        VAR_SAMP(rating) AS rating_variance
3 FROM survey_responses
4 GROUP BY question_id;

Mengukur variasi jawaban survey per pertanyaan.

Hasil

Q1: 1.44, Q2: 0.64, Q3: 2.25

SQL

1 SELECT 
2   AVG(value) AS mean,
3   VAR_SAMP(value) AS variance,
4   VAR_SAMP(value) / COUNT(*) AS variance_of_mean
5 FROM experiment_data;

Menghitung komponen untuk interval kepercayaan.

Hasil

mean: 45.2, variance: 100, variance_of_mean: 4.41

VAR_SAMP

Snowflake

VAR_SAMP

BigQuery

1	SELECT VAR_SAMP(test_score) AS score_variance
2	FROM sample_students;

1	SELECT question_id,
2	VAR_SAMP(rating) AS rating_variance
3	FROM survey_responses
4	GROUP BY question_id;

1	SELECT
2	AVG(value) AS mean,
3	VAR_SAMP(value) AS variance,
4	VAR_SAMP(value) / COUNT(*) AS variance_of_mean
5	FROM experiment_data;