Aggregate

STDDEV_POP

BigQuery

Calculates the population standard deviation of numeric values. Uses the N divisor formula (not N-1), suitable when the data represents an entire population.

Tipe hasil: FLOAT64Diperbarui: 13 Jun 2026

Syntax

SQL

STDDEV_POP(expression)

Parameter

expressionnumericwajib

A numeric column or expression for which to calculate the population standard deviation

Contoh Penggunaan

Population vs Sample Standard Deviation

SQL

1 SELECT
2   STDDEV_POP(score) as population_stddev,
3   STDDEV_SAMP(score) as sample_stddev,
4   STDDEV(score) as stddev_alias
5 FROM `project.dataset.exam_scores`;

Compares population and sample standard deviation.

Hasil

population_stddev	sample_stddev	stddev_alias
12.5	12.8	12.8

STDDEV_POP for All Employee Data

SQL

1 SELECT
2   department,
3   AVG(salary) as avg_salary,
4   STDDEV_POP(salary) as salary_stddev_pop
5 FROM `project.dataset.all_employees`
6 GROUP BY department
7 ORDER BY salary_stddev_pop DESC;

Population standard deviation of salary by department (all employees).

Hasil

department	avg_salary	salary_stddev_pop
Engineering	18000000	5200000
Sales	12000000	4500000
Operations	9500000	1800000

Sensor Reading Variability

SQL

1 SELECT
2   sensor_id,
3   AVG(reading) as avg_reading,
4   STDDEV_POP(reading) as reading_variability,
5   MIN(reading) as min_reading,
6   MAX(reading) as max_reading
7 FROM `project.dataset.sensor_data`
8 WHERE DATE(timestamp) = CURRENT_DATE()
9 GROUP BY sensor_id
10 ORDER BY reading_variability DESC
11 LIMIT 10;

Analyzes sensor reading variability using complete data.

Hasil

sensor_id	avg_reading	reading_variability	min_reading	max_reading
S001	25.5	3.2	18.0	32.0
S002	22.1	1.8	19.5	26.0

Pertanyaan Umum tentang STDDEV_POP

Apa itu fungsi STDDEV_POP di BigQuery?

Calculates the population standard deviation of numeric values. Uses the N divisor formula (not N-1), suitable when the data represents an entire population. Di BigQuery, fungsi STDDEV_POP termasuk dalam kelompok fungsi yang sering digunakan untuk mengolah dan menganalisis data secara efisien.

Bagaimana cara menggunakan STDDEV_POP di BigQuery?

Gunakan sintaks berikut: STDDEV_POP(expression). Pastikan argumen yang dimasukkan sudah sesuai dengan tipe data yang diharapkan.

Apa nilai yang dikembalikan oleh fungsi STDDEV_POP?

Fungsi STDDEV_POP mengembalikan nilai bertipe FLOAT64. Pastikan tipe data hasil sudah sesuai dengan kebutuhan query atau formula kamu. Jika input mengandung nilai NULL, perilaku fungsi dapat berbeda — selalu periksa dokumentasi untuk memastikan hasilnya sesuai ekspektasi.

Apa saja parameter fungsi STDDEV_POP?

Fungsi ini memiliki 1 parameter wajib. Parameter yang digunakan: expression (numeric, wajib): A numeric column or expression for which to calculate the population standard deviation.

Fungsi Terkait

STDDEVSTDDEV_SAMPVARIANCEVAR_POPVAR_SAMPCORRCOVAR_POPCOVAR_SAMPPERCENTILE_CONTPERCENTILE_DISC

Ngulik Langsung

Sudah paham STDDEV_POP? Latih langsung di browser

Latihan interaktif, langsung di browser.

Latihan Langsung →

Kembali ke BigQuery Functions

1	SELECT
2	STDDEV_POP(score) as population_stddev,
3	STDDEV_SAMP(score) as sample_stddev,
4	STDDEV(score) as stddev_alias
5	FROM `project.dataset.exam_scores`;

1	SELECT
2	department,
3	AVG(salary) as avg_salary,
4	STDDEV_POP(salary) as salary_stddev_pop
5	FROM `project.dataset.all_employees`
6	GROUP BY department
7	ORDER BY salary_stddev_pop DESC;

1	SELECT
2	sensor_id,
3	AVG(reading) as avg_reading,
4	STDDEV_POP(reading) as reading_variability,
5	MIN(reading) as min_reading,
6	MAX(reading) as max_reading
7	FROM `project.dataset.sensor_data`
8	WHERE DATE(timestamp) = CURRENT_DATE()
9	GROUP BY sensor_id
10	ORDER BY reading_variability DESC
11	LIMIT 10;