이 함수는 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.