Funzione di Google Sheets

DVAR

Estimates the variance of a population based on a sample from entries in a database that match specified conditions.

Genera una formula con l'IA La stessa funzione in Excel

Questa funzione funziona in Google Sheets esattamente come in Excel — stessa sintassi e stessi argomenti.

Sintassi

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.

Argomenti

databaseobbligatorioThe range of cells that makes up the list or database.
fieldobbligatorioThe column used in the function, indicated by a label or index number.
criteriaobbligatorioThe range of cells that contains the conditions you specify.

Esempi

=DVAR(A1:C10, "Profit", E1:E2)

Risultato: 125.4

Calculates the sample variance of the 'Profit' column for rows matching the criteria in E1:E2.

Domande frequenti

What is the difference between DVAR and DVARP?

DVAR calculates variance based on a sample, while DVARP calculates variance based on the entire population.

Funzioni correlate

DSUM DAVERAGE