DVARP

Calculates variance based on the entire population of selected database entries,


Deprecated: Optional parameter $pCoordinate declared before required parameter $pValue is implicitly treated as a required parameter in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Worksheet.php on line 1477

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type int in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Warning: Trying to access array offset on value of type float in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DefaultValueBinder.php on line 82

Database

array(7) { [4]=> array(5) { ["A"]=> string(4) "Tree" ["B"]=> string(6) "Height" ["C"]=> string(3) "Age" ["D"]=> string(5) "Yield" ["E"]=> string(6) "Profit" } [5]=> array(5) { ["A"]=> string(5) "Apple" ["B"]=> float(18) ["C"]=> float(20) ["D"]=> float(14) ["E"]=> float(105) } [6]=> array(5) { ["A"]=> string(4) "Pear" ["B"]=> float(12) ["C"]=> float(12) ["D"]=> float(10) ["E"]=> float(96) } [7]=> array(5) { ["A"]=> string(6) "Cherry" ["B"]=> float(13) ["C"]=> float(14) ["D"]=> float(9) ["E"]=> float(105) } [8]=> array(5) { ["A"]=> string(5) "Apple" ["B"]=> float(14) ["C"]=> float(15) ["D"]=> float(10) ["E"]=> float(75) } [9]=> array(5) { ["A"]=> string(4) "Pear" ["B"]=> float(9) ["C"]=> float(8) ["D"]=> float(8) ["E"]=> float(76.7999999999999971578290569595992565155029296875) } [10]=> array(5) { ["A"]=> string(5) "Apple" ["B"]=> float(8) ["C"]=> float(9) ["D"]=> float(6) ["E"]=> float(45) } }

Criteria


Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3370

Warning: Trying to access array offset on value of type null in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation.php on line 3370
array(3) { [1]=> array(1) { ["A"]=> string(4) "Tree" } [2]=> array(1) { ["A"]=> string(6) "=Apple" } [3]=> array(1) { ["A"]=> string(5) "=Pear" } } The variance in the yield of Apple and Pear trees

Deprecated: Optional parameter $trendType declared before required parameter $yValues is implicitly treated as a required parameter in /home/apolo/public_html/sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/trend/trendClass.php on line 81
DVARP() Result is 7.04

Criteria

array(3) { [1]=> array(1) { ["A"]=> string(4) "Tree" } [2]=> array(1) { ["A"]=> string(6) "=Apple" } [3]=> array(1) { ["A"]=> string(5) "=Pear" } } The variance in height of Apple and Pear trees
DVARP() Result is 12.96