You are here
26 calls to PHPExcel_Calculation_Functions::NA() in Loft Data Grids 6.2
FunctionsTest::testNA in vendor/FunctionsTest.php PHPExcel_Calculation_Engineering::CONVERTUOM in vendor/Engineering.php * CONVERTUOM
*
* Converts a number from one measurement system to another.
* For example, CONVERT can translate a table of distances in miles to a table of distances
* in kilometers.
*
* Excel Function:
* CONVERT(value,fromUOM,toUOM)
…
PHPExcel_Calculation_Functions::ERROR_TYPE in vendor/Functions.php * ERROR_TYPE
*
*
PHPExcel_Calculation_Functions::IS_NA in vendor/Functions.php * IS_NA
*
*
PHPExcel_Calculation_LookupRef::HLOOKUP in vendor/LookupRef.php HLOOKUP
The HLOOKUP function searches for value in the top-most row of lookup_array and returns the value in the same column based on the index_number.
PHPExcel_Calculation_LookupRef::LOOKUP in vendor/LookupRef.php * LOOKUP
* The LOOKUP function searches for value either from a one-row or one-column range or from an array.
*
PHPExcel_Calculation_LookupRef::MATCH in vendor/LookupRef.php * MATCH
*
* The MATCH function searches for a specified item in a range of cells
*
* Excel Function:
* =MATCH(lookup_value, lookup_array, [match_type])
*
*
PHPExcel_Calculation_LookupRef::VLOOKUP in vendor/LookupRef.php * VLOOKUP
* The VLOOKUP function searches for value in the left-most column of lookup_array and returns the value in the same row based on the index_number.
*
PHPExcel_Calculation_Statistical::BETAINV in vendor/Statistical.php * BETAINV
*
* Returns the inverse of the beta distribution.
*
*
PHPExcel_Calculation_Statistical::CHIINV in vendor/Statistical.php * CHIINV
*
* Returns the one-tailed probability of the chi-squared distribution.
*
*
PHPExcel_Calculation_Statistical::CORREL in vendor/Statistical.php * CORREL
*
* Returns covariance, the average of the products of deviations for each data point pair.
*
*
PHPExcel_Calculation_Statistical::COVAR in vendor/Statistical.php * COVAR
*
* Returns covariance, the average of the products of deviations for each data point pair.
*
*
PHPExcel_Calculation_Statistical::FORECAST in vendor/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::GAMMAINV in vendor/Statistical.php * GAMMAINV
*
* Returns the inverse of the beta distribution.
*
*
PHPExcel_Calculation_Statistical::HARMEAN in vendor/Statistical.php * HARMEAN
*
* Returns the harmonic mean of a data set. The harmonic mean is the reciprocal of the
* arithmetic mean of reciprocals.
*
* Excel Function:
* HARMEAN(value1[,value2[, ...]])
*
* @access public
* @category Statistical…
PHPExcel_Calculation_Statistical::INTERCEPT in vendor/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::LINEST in vendor/Statistical.php * LINEST
*
* Calculates the statistics for a line by using the "least squares" method to calculate a straight line that best fits your data,
* and then returns an array that describes the line.
*
*
PHPExcel_Calculation_Statistical::LOGEST in vendor/Statistical.php * LOGEST
*
* Calculates an exponential curve that best fits the X and Y data series,
* and then returns an array that describes the line.
*
*
PHPExcel_Calculation_Statistical::MODE in vendor/Statistical.php * MODE
*
* Returns the most frequently occurring, or repetitive, value in an array or range of data
*
* Excel Function:
* MODE(value1[,value2[, ...]])
*
* @access public
* @category Statistical Functions
*
PHPExcel_Calculation_Statistical::PERCENTRANK in vendor/Statistical.php * PERCENTRANK
*
* Returns the rank of a value in a data set as a percentage of the data set.
*
*
PHPExcel_Calculation_Statistical::RANK in vendor/Statistical.php * RANK
*
* Returns the rank of a number in a list of numbers.
*
*
PHPExcel_Calculation_Statistical::RSQ in vendor/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::SLOPE in vendor/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::STEYX in vendor/Statistical.php * STEYX
*
* Returns the standard error of the predicted y-value for each x in the regression.
*
*
PHPExcel_Calculation_Statistical::TINV in vendor/Statistical.php * TINV
*
* Returns the one-tailed probability of the chi-squared distribution.
*
*
PHPExcel_Calculation_Statistical::_modeCalc in vendor/Statistical.php
