Aggregate

STDDEV_SAMP

MySQL

Menghitung standar deviasi sampel dari nilai-nilai numerik. Menggunakan pembagi N-1 (koreksi Bessel).

Tipe hasil: DOUBLEDiperbarui: 7 Jan 2026

Syntax

SQL

STDDEV_SAMP(expr)

exprnumericwajib

Ekspresi numerik untuk menghitung standar deviasi sampel

SQL

1 SELECT STDDEV_SAMP(test_score) AS score_stddev
2 FROM sample_students;

Menghitung standar deviasi dari sampel nilai siswa.

Hasil

score_stddev: 18.7

SQL

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

Mengukur variasi jawaban survey per pertanyaan.

Hasil

Q1: 1.2, Q2: 0.8, Q3: 1.5

SQL

1 SELECT 
2   AVG(value) AS mean,
3   STDDEV_SAMP(value) / SQRT(COUNT(*)) AS std_error
4 FROM experiment_data;

Menghitung standard error untuk interval kepercayaan.

Hasil

mean: 45.2, std_error: 2.1

STDDEV_SAMP

Snowflake

STDDEV_SAMP

BigQuery

1	SELECT STDDEV_SAMP(test_score) AS score_stddev
2	FROM sample_students;

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

1	SELECT
2	AVG(value) AS mean,
3	STDDEV_SAMP(value) / SQRT(COUNT(*)) AS std_error
4	FROM experiment_data;