| 1 |
<?php |
| 2 |
|
| 3 |
namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Database; |
| 4 |
|
| 5 |
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError; |
| 6 |
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Statistical\Variances; |
| 7 |
|
| 8 |
class DVar extends DatabaseAbstract |
| 9 |
{ |
| 10 |
/** |
| 11 |
* DVAR. |
| 12 |
* |
| 13 |
* Estimates the variance of a population based on a sample by using the numbers in a column |
| 14 |
* of a list or database that match conditions that you specify. |
| 15 |
* |
| 16 |
* Excel Function: |
| 17 |
* DVAR(database,field,criteria) |
| 18 |
* |
| 19 |
* @param mixed[] $database The range of cells that makes up the list or database. |
| 20 |
* A database is a list of related data in which rows of related |
| 21 |
* information are records, and columns of data are fields. The |
| 22 |
* first row of the list contains labels for each column. |
| 23 |
* @param null|array<mixed>|int|string $field Indicates which column is used in the function. Enter the |
| 24 |
* column label enclosed between double quotation marks, such as |
| 25 |
* "Age" or "Yield," or a number (without quotation marks) that |
| 26 |
* represents the position of the column within the list: 1 for |
| 27 |
* the first column, 2 for the second column, and so on. |
| 28 |
* @param mixed[][] $criteria The range of cells that contains the conditions you specify. |
| 29 |
* You can use any range for the criteria argument, as long as it |
| 30 |
* includes at least one column label and at least one cell below |
| 31 |
* the column label in which you specify a condition for the |
| 32 |
* column. |
| 33 |
* |
| 34 |
* @return float|string (string if result is an error) |
| 35 |
*/ |
| 36 |
public static function evaluate(array $database, $field, array $criteria) |
| 37 |
{ |
| 38 |
$field = self::fieldExtract($database, $field); |
| 39 |
if ($field === null) { |
| 40 |
return ExcelError::VALUE(); |
| 41 |
} |
| 42 |
|
| 43 |
return Variances::VAR( |
| 44 |
self::getFilteredColumn($database, $field, $criteria) |
| 45 |
); |
| 46 |
} |
| 47 |
} |
| 48 |
|
