이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
VAR(number1, [number2], …)The VAR function estimates variance based on a sample of a population. It ignores logical values and text contained in references, focusing only on numeric data points.
=VAR(10, 12, 23, 23, 16, 23, 21, 16)결과: 28.57143
Calculates the sample variance of the provided set of numbers.
VAR calculates variance based on a sample, while VARP calculates variance based on the entire population.