LOG_GAMMA_X_MAX_VALUE
LOG_GAMMA_X_MAX_VALUE = 2.55E+305
AVERAGEIF(mixed $aArgs, string $condition, array<mixed,mixed> $averageArgs = array()) : float|string
AVERAGEIF.
Returns the average value from a range of cells that contain numbers within the list of arguments
Excel Function: AVERAGEIF(value1[,value2[, ...]],condition)
mixed | $aArgs | Data values |
string | $condition | the criteria that defines which cells will be checked |
array<mixed,mixed> | $averageArgs | Data values |
BETADIST(float $value, float $alpha, float $beta, mixed $rMin, mixed $rMax = 1) : float|string
BETADIST.
Returns the beta distribution.
float | $value | Value at which you want to evaluate the distribution |
float | $alpha | Parameter to the distribution |
float | $beta | Parameter to the distribution |
mixed | $rMin | |
mixed | $rMax |
BETAINV(float $probability, float $alpha, float $beta, float $rMin, float $rMax = 1) : float|string
BETAINV.
Returns the inverse of the beta distribution.
float | $probability | Probability at which you want to evaluate the distribution |
float | $alpha | Parameter to the distribution |
float | $beta | Parameter to the distribution |
float | $rMin | Minimum value |
float | $rMax | Maximum value |
BINOMDIST(float $value, float $trials, float $probability, boolean $cumulative) : float|string
BINOMDIST.
Returns the individual term binomial distribution probability. Use BINOMDIST in problems with a fixed number of tests or trials, when the outcomes of any trial are only success or failure, when trials are independent, and when the probability of success is constant throughout the experiment. For example, BINOMDIST can calculate the probability that two of the next three babies born are male.
float | $value | Number of successes in trials |
float | $trials | Number of trials |
float | $probability | Probability of success on each trial |
boolean | $cumulative |
COUNTIF(mixed $aArgs, string $condition) : integer
COUNTIF.
Counts the number of cells that contain numbers within the list of arguments
Excel Function: COUNTIF(value1[,value2[, ...]],condition)
mixed | $aArgs | Data values |
string | $condition | the criteria that defines which cells will be counted |
CRITBINOM(float $trials, float $probability, float $alpha) : integer|string
CRITBINOM.
Returns the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value
See https://support.microsoft.com/en-us/help/828117/ for details of the algorithm used
float | $trials | number of Bernoulli trials |
float | $probability | probability of a success on each trial |
float | $alpha | criterion value |
EXPONDIST(float $value, float $lambda, boolean $cumulative) : float|string
EXPONDIST.
Returns the exponential distribution. Use EXPONDIST to model the time between events, such as how long an automated bank teller takes to deliver cash. For example, you can use EXPONDIST to determine the probability that the process takes at most 1 minute.
float | $value | Value of the function |
float | $lambda | The parameter value |
boolean | $cumulative |
FISHER(float $value) : float|string
FISHER.
Returns the Fisher transformation at x. This transformation produces a function that is normally distributed rather than skewed. Use this function to perform hypothesis testing on the correlation coefficient.
float | $value |
FORECAST(float $xValue, mixed $yValues, mixed $xValues) : boolean|float|string
FORECAST.
Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value.
float | $xValue | Value of X for which we want to find Y |
mixed | $yValues | array of mixed Data Series Y |
mixed | $xValues | of mixed Data Series X |
GAMMADIST(float $value, float $a, float $b, boolean $cumulative) : float|string
GAMMADIST.
Returns the gamma distribution.
float | $value | Value at which you want to evaluate the distribution |
float | $a | Parameter to the distribution |
float | $b | Parameter to the distribution |
boolean | $cumulative |
GAMMAINV(float $probability, float $alpha, float $beta) : float|string
GAMMAINV.
Returns the inverse of the beta distribution.
float | $probability | Probability at which you want to evaluate the distribution |
float | $alpha | Parameter to the distribution |
float | $beta | Parameter to the distribution |
GEOMEAN(mixed ...$args) : float|string
GEOMEAN.
Returns the geometric mean of an array or range of positive data. For example, you can use GEOMEAN to calculate average growth rate given compound interest with variable rates.
Excel Function: GEOMEAN(value1[,value2[, ...]])
mixed | $args variadic | Data values |
GROWTH(array<mixed,mixed> $yValues, array<mixed,mixed> $xValues = array(), array<mixed,mixed> $newValues = array(), boolean $const = true) : array
GROWTH.
Returns values along a predicted exponential Trend
array<mixed,mixed> | $yValues | Data Series Y |
array<mixed,mixed> | $xValues | Data Series X |
array<mixed,mixed> | $newValues | Values of X for which we want to find Y |
boolean | $const | a logical value specifying whether to force the intersect to equal 0 |
of float
HYPGEOMDIST(float $sampleSuccesses, float $sampleNumber, float $populationSuccesses, float $populationNumber) : float|string
HYPGEOMDIST.
Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size.
float | $sampleSuccesses | Number of successes in the sample |
float | $sampleNumber | Size of the sample |
float | $populationSuccesses | Number of successes in the population |
float | $populationNumber | Population size |
INTERCEPT(array<mixed,mixed> $yValues, array<mixed,mixed> $xValues) : float|string
INTERCEPT.
Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.
array<mixed,mixed> | $yValues | Data Series Y |
array<mixed,mixed> | $xValues | Data Series X |
KURT(array ...$args) : float|string
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 kurtosis indicates a relatively flat distribution.
array | $args variadic | Data Series |
LARGE(mixed $args) : float|string
LARGE.
Returns the nth largest value in a data set. You can use this function to select a value based on its relative standing.
Excel Function: LARGE(value1[,value2[, ...]],entry)
mixed | $args | Data values |
The result, or a string containing an error
LINEST(array<mixed,mixed> $yValues, null|array<mixed,mixed> $xValues = null, boolean $const = true, boolean $stats = false) : array|integer|string
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.
array<mixed,mixed> | $yValues | Data Series Y |
null|array<mixed,mixed> | $xValues | Data Series X |
boolean | $const | a logical value specifying whether to force the intersect to equal 0 |
boolean | $stats | a logical value specifying whether to return additional regression statistics |
The result, or a string containing an error
LOGEST(array<mixed,mixed> $yValues, null|array<mixed,mixed> $xValues = null, boolean $const = true, boolean $stats = false) : array|integer|string
LOGEST.
Calculates an exponential curve that best fits the X and Y data series, and then returns an array that describes the line.
array<mixed,mixed> | $yValues | Data Series Y |
null|array<mixed,mixed> | $xValues | Data Series X |
boolean | $const | a logical value specifying whether to force the intersect to equal 0 |
boolean | $stats | a logical value specifying whether to return additional regression statistics |
The result, or a string containing an error
LOGNORMDIST(float $value, float $mean, float $stdDev) : float|string
LOGNORMDIST.
Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.
float | $value | |
float | $mean | |
float | $stdDev |
The result, or a string containing an error
MAXIFS(mixed $args) : float
MAXIFS.
Counts the maximum value within a range of cells that contain numbers within the list of arguments
Excel Function: MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
mixed | $args | Data range and criterias |
MEDIAN(mixed ...$args) : float|string
MEDIAN.
Returns the median of the given numbers. The median is the number in the middle of a set of numbers.
Excel Function: MEDIAN(value1[,value2[, ...]])
mixed | $args variadic | Data values |
The result, or a string containing an error
MINIFS(mixed $args) : float
MINIFS.
Returns the minimum value within a range of cells that contain numbers within the list of arguments
Excel Function: MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
mixed | $args | Data range and criterias |
NEGBINOMDIST(float $failures, float $successes, float $probability) : float|string
NEGBINOMDIST.
Returns the negative binomial distribution. NEGBINOMDIST returns the probability that there will be number_f failures before the number_s-th success, when the constant probability of a success is probability_s. This function is similar to the binomial distribution, except that the number of successes is fixed, and the number of trials is variable. Like the binomial, trials are assumed to be independent.
float | $failures | Number of Failures |
float | $successes | Threshold number of Successes |
float | $probability | Probability of success on each trial |
The result, or a string containing an error
NORMDIST(float $value, float $mean, float $stdDev, boolean $cumulative) : float|string
NORMDIST.
Returns the normal distribution for the specified mean and standard deviation. This function has a very wide range of applications in statistics, including hypothesis testing.
float | $value | |
float | $mean | Mean Value |
float | $stdDev | Standard Deviation |
boolean | $cumulative |
The result, or a string containing an error
NORMINV(float $probability, float $mean, float $stdDev) : float|string
NORMINV.
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
float | $probability | |
float | $mean | Mean Value |
float | $stdDev | Standard Deviation |
The result, or a string containing an error
NORMSDIST(float $value) : float|string
NORMSDIST.
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
float | $value |
The result, or a string containing an error
PERCENTRANK(array<mixed,float> $valueSet, integer $value, integer $significance = 3) : float
PERCENTRANK.
Returns the rank of a value in a data set as a percentage of the data set.
array<mixed,float> | $valueSet | An array of, or a reference to, a list of numbers |
integer | $value | the number whose rank you want to find |
integer | $significance | the number of significant digits for the returned percentage value |
PERMUT(integer $numObjs, integer $numInSet) : integer|string
PERMUT.
Returns the number of permutations for a given number of objects that can be selected from number objects. A permutation is any set or subset of objects or events where internal order is significant. Permutations are different from combinations, for which the internal order is not significant. Use this function for lottery-style probability calculations.
integer | $numObjs | Number of different objects |
integer | $numInSet | Number of objects in each permutation |
Number of permutations, or a string containing an error
POISSON(float $value, float $mean, boolean $cumulative) : float|string
POISSON.
Returns the Poisson distribution. A common application of the Poisson distribution is predicting the number of events over a specific time, such as the number of cars arriving at a toll plaza in 1 minute.
float | $value | |
float | $mean | Mean Value |
boolean | $cumulative |
The result, or a string containing an error
RANK(integer $value, array<mixed,float> $valueSet, integer $order) : float|string
RANK.
Returns the rank of a number in a list of numbers.
integer | $value | the number whose rank you want to find |
array<mixed,float> | $valueSet | An array of, or a reference to, a list of numbers |
integer | $order | Order to sort the values in the value set |
The result, or a string containing an error
RSQ(array<mixed,mixed> $yValues, array<mixed,mixed> $xValues) : float|string
RSQ.
Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
array<mixed,mixed> | $yValues | Data Series Y |
array<mixed,mixed> | $xValues | Data Series X |
The result, or a string containing an error
SKEW(array ...$args) : float|string
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. Negative skewness indicates a distribution with an asymmetric tail extending toward more negative values.
array | $args variadic | Data Series |
The result, or a string containing an error
SLOPE(array<mixed,mixed> $yValues, array<mixed,mixed> $xValues) : float|string
SLOPE.
Returns the slope of the linear regression line through data points in known_y's and known_x's.
array<mixed,mixed> | $yValues | Data Series Y |
array<mixed,mixed> | $xValues | Data Series X |
The result, or a string containing an error
SMALL(mixed $args) : float|string
SMALL.
Returns the nth smallest value in a data set. You can use this function to select a value based on its relative standing.
Excel Function: SMALL(value1[,value2[, ...]],entry)
mixed | $args | Data values |
The result, or a string containing an error
STANDARDIZE(float $value, float $mean, float $stdDev) : float|string
STANDARDIZE.
Returns a normalized value from a distribution characterized by mean and standard_dev.
float | $value | Value to normalize |
float | $mean | Mean Value |
float | $stdDev | Standard Deviation |
Standardized value, or a string containing an error
STDEV(mixed ...$args) : float|string
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[, ...]])
mixed | $args variadic | Data values |
The result, or a string containing an error
TDIST(float $value, float $degrees, float $tails) : float|string
TDIST.
Returns the probability of Student's T distribution.
float | $value | Value for the function |
float | $degrees | degrees of freedom |
float | $tails | number of tails (1 or 2) |
The result, or a string containing an error
TREND(array<mixed,mixed> $yValues, array<mixed,mixed> $xValues = array(), array<mixed,mixed> $newValues = array(), boolean $const = true) : array
TREND.
Returns values along a linear Trend
array<mixed,mixed> | $yValues | Data Series Y |
array<mixed,mixed> | $xValues | Data Series X |
array<mixed,mixed> | $newValues | Values of X for which we want to find Y |
boolean | $const | a logical value specifying whether to force the intersect to equal 0 |
of float
TRIMMEAN(mixed $args) : float|string
TRIMMEAN.
Returns the mean of the interior of a data set. TRIMMEAN calculates the mean taken by excluding a percentage of data points from the top and bottom tails of a data set.
Excel Function: TRIMEAN(value1[,value2[, ...]], $discard)
mixed | $args | Data values |
WEIBULL(float $value, float $alpha, float $beta, boolean $cumulative) : float
WEIBULL.
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.
float | $value | |
float | $alpha | Alpha Parameter |
float | $beta | Beta Parameter |
boolean | $cumulative |
ZTEST(float $dataSet, float $m0, float $sigma = null) : float|string
ZTEST.
Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.
float | $dataSet | |
float | $m0 | Alpha Parameter |
float | $sigma | Beta Parameter |
testAcceptedBoolean(mixed $arg, mixed $k) : integer|mixed
MS Excel does not count Booleans if passed as cell values, but they are counted if passed as literals.
OpenOffice Calc always counts Booleans. Gnumeric never counts Booleans.
mixed | $arg | |
mixed | $k |