zacek, regarding the VAR function, OOo and LibreOffice both return 5 in order to keep compatibility with Excel, and matches the definition of a population sample variance from Wikipedia via OOo documentation:
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_VAR_function
Feel free to report any future bugs you may find.
zacek, regarding the VAR function, OOo and LibreOffice both return 5 in order to keep compatibility with Excel, and matches the definition of a population sample variance from Wikipedia via OOo documentation:
http:// wiki.services. openoffice. org/wiki/ Documentation/ How_Tos/ Calc:_VAR_ function
Feel free to report any future bugs you may find.