Estimates the variance of a population based on a sample from entries in a database that match specified conditions.
이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
DVAR(database, field, criteria)The DVAR function evaluates a list or database using a sample of the population. It filters data based on criteria you define and calculates the variance of the numbers in the specified field.
=DVAR(A1:C10, "Profit", E1:E2)결과: 125.4
Calculates the sample variance of the 'Profit' column for rows matching the criteria in E1:E2.
DVAR calculates variance based on a sample, while DVARP calculates variance based on the entire population.