Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4D v19
VAR.P
|
VAR.P ( value {, value2 , ... , valueN} ) | ||||||||
Parameter | Typ | Beschreibung | ||||||
value | Zahl, Array |
![]() |
Values to get the variance | |||||
The VAR.P function returns the variance based on the entire population, which uses numeric values.
In value, pass the values to evaluate. Each argument can be a number, or an array of numbers (a single array (cell range) or multiple arrays (cell ranges)).
Note: This function assumes that its arguments are the entire population. If your data represents only a sample of the population, then compute the variance using the VAR.S function.
VAR.P(B3,C4,B2,D10,E5) VAR.P(A1:A9)
VAR.P(98,85,76,87,92,89,90) //39.265306122449
Produkt: 4D
Thema: Formeln in 4D View Pro
4D View Pro Handbuch ( 4D v19)