You are here

29 calls to PHPExcel_Calculation_Functions::DIV0() in Loft Data Grids 7.2

FunctionsTest::testDIV0 in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FunctionsTest.php
PHPExcel_Calculation_Financial::DOLLARDE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DOLLARDE * * Converts a dollar price expressed as an integer part and a fraction * part into a dollar price expressed as a decimal number. * Fractional dollar numbers are sometimes used for security prices. * * Excel Function: …
PHPExcel_Calculation_Financial::DOLLARFR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Financial.php
* DOLLARFR * * Converts a dollar price expressed as a decimal number into a dollar price * expressed as a fraction. * Fractional dollar numbers are sometimes used for security prices. * * Excel Function: …
PHPExcel_Calculation_MathTrig::ATAN2 in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* ATAN2 * * This function calculates the arc tangent of the two variables x and y. It is similar to * calculating the arc tangent of y ÷ x, except that the signs of both arguments are used * to determine the quadrant of the result. * The…
PHPExcel_Calculation_MathTrig::FLOOR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* FLOOR * * Rounds number down, toward zero, to the nearest multiple of significance. * * Excel Function: * FLOOR(number[,significance]) * * @access public * @category Mathematical and Trigonometric Functions *
PHPExcel_Calculation_MathTrig::MOD in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* MOD * *
PHPExcel_Calculation_MathTrig::POWER in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/MathTrig.php
* POWER * * Computes x raised to the power y. * *
PHPExcel_Calculation_Statistical::AVEDEV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* AVEDEV * * Returns the average of the absolute deviations of data points from their mean. * AVEDEV is a measure of the variability in a data set. * * Excel Function: * AVEDEV(value1[,value2[, ...]]) * * @access public * @category…
PHPExcel_Calculation_Statistical::AVERAGE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* AVERAGE * * Returns the average (arithmetic mean) of the arguments * * Excel Function: * AVERAGE(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::AVERAGEA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* AVERAGEA * * Returns the average of its arguments, including numbers, text, and logical values * * Excel Function: * AVERAGEA(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::AVERAGEIF in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* AVERAGEIF * * Returns the average value from a range of cells that contain numbers within the list of arguments * * Excel Function: * AVERAGEIF(value1[,value2[, ...]],condition) * * @access public * @category Mathematical and…
PHPExcel_Calculation_Statistical::CORREL in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* CORREL * * Returns covariance, the average of the products of deviations for each data point pair. * *
PHPExcel_Calculation_Statistical::COVAR in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* COVAR * * Returns covariance, the average of the products of deviations for each data point pair. * *
PHPExcel_Calculation_Statistical::DEVSQ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* DEVSQ * * Returns the sum of squares of deviations of data points from their sample mean. * * Excel Function: * DEVSQ(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::FORECAST in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* FORECAST * * Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value. * *
PHPExcel_Calculation_Statistical::INTERCEPT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* INTERCEPT * * Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values. * *
PHPExcel_Calculation_Statistical::KURT in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* KURT * * Returns the kurtosis of a data set. Kurtosis characterizes the relative peakedness * or flatness of a distribution compared with the normal distribution. Positive * kurtosis indicates a relatively peaked distribution. Negative…
PHPExcel_Calculation_Statistical::RSQ in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* RSQ * * Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's. * *
PHPExcel_Calculation_Statistical::SKEW in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* SKEW * * Returns the skewness of a distribution. Skewness characterizes the degree of asymmetry * of a distribution around its mean. Positive skewness indicates a distribution with an * asymmetric tail extending toward more positive values.…
PHPExcel_Calculation_Statistical::SLOPE in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* SLOPE * * Returns the slope of the linear regression line through data points in known_y's and known_x's. * *
PHPExcel_Calculation_Statistical::STDEV in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STDEV * * Estimates standard deviation based on a sample. The standard deviation is a measure of how * widely values are dispersed from the average value (the mean). * * Excel Function: * STDEV(value1[,value2[, ...]]) * *…
PHPExcel_Calculation_Statistical::STDEVA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STDEVA * * Estimates standard deviation based on a sample, including numbers, text, and logical values * * Excel Function: * STDEVA(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::STDEVP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STDEVP * * Calculates standard deviation based on the entire population * * Excel Function: * STDEVP(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::STDEVPA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STDEVPA * * Calculates standard deviation based on the entire population, including numbers, text, and logical values * * Excel Function: * STDEVPA(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::STEYX in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* STEYX * * Returns the standard error of the predicted y-value for each x in the regression. * *
PHPExcel_Calculation_Statistical::VARA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* VARA * * Estimates variance based on a sample, including numbers, text, and logical values * * Excel Function: * VARA(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::VARFunc in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* VARFunc * * Estimates variance based on a sample. * * Excel Function: * VAR(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::VARP in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* VARP * * Calculates variance based on the entire population * * Excel Function: * VARP(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *
PHPExcel_Calculation_Statistical::VARPA in vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/Statistical.php
* VARPA * * Calculates variance based on the entire population, including numbers, text, and logical values * * Excel Function: * VARPA(value1[,value2[, ...]]) * * @access public * @category Statistical Functions *