Google Sheets-Funktion

DVAR

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

Formel mit KI erstellen Dieselbe Funktion in Excel

Diese Funktion funktioniert in Google Sheets genauso wie in Excel — gleiche Syntax und Argumente.

Syntax

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.

Argumente

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

Beispiele

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

Ergebnis: 125.4

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

FAQ

What is the difference between DVAR and DVARP?

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

DVAR

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen

DVAR

Syntax

Argumente

Beispiele

FAQ

Verwandte Funktionen