Database/DVarP.php

PhpSpreadsheet · src/PhpSpreadsheet/Calculation/Database/DVarP.php · php · MIT
database

Computes population variance from a database column that meets criteria.

// Source: https://github.com/PHPOffice/PhpSpreadsheet | License: MIT | Copyright 2019-2026 PhpSpreadsheet Authors
// Provided via justclaw.it.com; keep this notice with the code.
<?php

namespace PhpOffice\PhpSpreadsheet\Calculation\Database;

use PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Variances;

class DVarP extends DatabaseAbstract
{
    /**
     * DVARP.
     *
     * Calculates the variance of a population based on the entire population by using the numbers
     * in a column of a list or database that match conditions that you specify.
     *
     * Excel Function:
     *        DVARP(database,field,criteria)
     *
     * @param mixed[] $database The range of cells that makes up the list or database.
     *  

... (truncated -- full source via MCP)

See the full source, get the GitHub permalink, and search for more like it.

Get a free API key