The DVAR function in Microsoft Excel is a database function, and its purpose is to estimate the variance of a population based on a sample from selected database entries. The formula for the DVAR ...

Originally, Excel was not designed to be a real database. Its early database functions were limited in quantity and in quality. And because every record in an Excel database is visible on the screen ...