Estimates standard deviation based on a sample.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
STDEV(number1, [number2], …)The STDEV function calculates the standard deviation of a dataset, assuming the data represents a sample of the entire population. It measures how widely values are dispersed from the average (mean) value. Note that this function is provided for compatibility with older versions of Excel; for newer versions, STDEV.S is recommended.
=STDEV(10, 12, 23, 23, 16, 23, 21, 16)ผลลัพธ์: 4.898979
Calculates the sample standard deviation for the provided list of numbers.
STDEV calculates standard deviation based on a sample, while STDEVP calculates it based on the entire population.
STDEV.S is the modern, more descriptive replacement for STDEV, providing better clarity in newer versions of Excel.