DVAR
Estimates variance based on a sample from selected database entries.
Deprecated: Optional parameter $pCoordinate declared before required parameter $pValue is implicitly treated as a required parameter in /home/apolo/public_html/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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/qua_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 estimated 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/qua_sgdpr/vendor/phpoffice/phpexcel/Classes/PHPExcel/Shared/trend/trendClass.php on line 81
DVAR() Result is 8.8
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 estimated variance in height of Apple and Pear trees
DVAR() Result is 16.2