Documentation

Statistical

Tags
deprecated
1.18.0

Table of Contents

EPS  = 2.22E-16
LOG_GAMMA_X_MAX_VALUE  = 2.55E+305
MAX_VALUE  = 1.2E+308
SQRT2PI  = 2.5066282746310007
AVEDEV()  : float|string
AVEDEV.
AVERAGE()  : float|string
AVERAGE.
AVERAGEA()  : float|string
AVERAGEA.
AVERAGEIF()  : null|float|string
AVERAGEIF.
BETADIST()  : array<string|int, mixed>|float|string
BETADIST.
BETAINV()  : array<string|int, mixed>|float|string
BETAINV.
BINOMDIST()  : array<string|int, mixed>|float|string
BINOMDIST.
CHIDIST()  : array<string|int, mixed>|float|string
CHIDIST.
CHIINV()  : array<string|int, mixed>|float|string
CHIINV.
CONFIDENCE()  : array<string|int, mixed>|float|string
CONFIDENCE.
CORREL()  : float|string
CORREL.
COUNT()  : int
COUNT.
COUNTA()  : int
COUNTA.
COUNTBLANK()  : int
COUNTBLANK.
COUNTIF()  : int
COUNTIF.
COUNTIFS()  : int
COUNTIFS.
COVAR()  : float|string
COVAR.
CRITBINOM()  : array<string|int, mixed>|int|string
CRITBINOM.
DEVSQ()  : float|string
DEVSQ.
EXPONDIST()  : array<string|int, mixed>|float|string
EXPONDIST.
FDIST2()  : array<string|int, mixed>|float|string
F.DIST.
FISHER()  : array<string|int, mixed>|float|string
FISHER.
FISHERINV()  : array<string|int, mixed>|float|string
FISHERINV.
FORECAST()  : array<string|int, mixed>|bool|float|string
FORECAST.
GAMMADIST()  : array<string|int, mixed>|float|string
GAMMADIST.
GAMMAFunction()  : array<string|int, mixed>|float|string
GAMMA.
GAMMAINV()  : array<string|int, mixed>|float|string
GAMMAINV.
GAMMALN()  : array<string|int, mixed>|float|string
GAMMALN.
GAUSS()  : array<string|int, mixed>|float|string
GAUSS.
GEOMEAN()  : float|string
GEOMEAN.
GROWTH()  : array<string|int, float>
GROWTH.
HARMEAN()  : float|string
HARMEAN.
HYPGEOMDIST()  : array<string|int, mixed>|float|string
HYPGEOMDIST.
INTERCEPT()  : float|string
INTERCEPT.
KURT()  : float|string
KURT.
LARGE()  : float|string
LARGE.
LINEST()  : array<string|int, mixed>|int|string
LINEST.
LOGEST()  : array<string|int, mixed>|int|string
LOGEST.
LOGINV()  : array<string|int, mixed>|float|string
LOGINV.
LOGNORMDIST()  : array<string|int, mixed>|float|string
LOGNORMDIST.
LOGNORMDIST2()  : array<string|int, mixed>|float|string
LOGNORM.DIST.
MAX()  : float
MAX.
MAXA()  : float
MAXA.
MAXIFS()  : float
MAXIFS.
MEDIAN()  : float|string
MEDIAN.
MIN()  : float
MIN.
MINA()  : float
MINA.
MINIFS()  : float
MINIFS.
MODE()  : float|string
MODE.
NEGBINOMDIST()  : array<string|int, mixed>|float|string
NEGBINOMDIST.
NORMDIST()  : array<string|int, mixed>|float|string
NORMDIST.
NORMINV()  : array<string|int, mixed>|float|string
NORMINV.
NORMSDIST()  : array<string|int, mixed>|float|string
NORMSDIST.
NORMSDIST2()  : array<string|int, mixed>|float|string
NORM.S.DIST.
NORMSINV()  : array<string|int, mixed>|float|string
NORMSINV.
PERCENTILE()  : float|string
PERCENTILE.
PERCENTRANK()  : float|string
PERCENTRANK.
PERMUT()  : array<string|int, mixed>|float|int|string
PERMUT.
POISSON()  : array<string|int, mixed>|float|string
POISSON.
QUARTILE()  : float|string
QUARTILE.
RANK()  : float|string
RANK.
RSQ()  : float|string
RSQ.
SKEW()  : float|string
SKEW.
SLOPE()  : float|string
SLOPE.
SMALL()  : float|string
SMALL.
STANDARDIZE()  : array<string|int, mixed>|float|string
STANDARDIZE.
STDEV()  : float|string
STDEV.
STDEVA()  : float|string
STDEVA.
STDEVP()  : float|string
STDEVP.
STDEVPA()  : float|string
STDEVPA.
STEYX()  : float|string
STEYX.
TDIST()  : array<string|int, mixed>|float|string
TDIST.
TINV()  : array<string|int, mixed>|float|string
TINV.
TREND()  : array<string|int, float>
TREND.
TRIMMEAN()  : float|string
TRIMMEAN.
VARA()  : float|string
VARA.
VARFunc()  : float|string
VARFunc.
VARP()  : float|string
VARP.
VARPA()  : float|string
VARPA.
WEIBULL()  : array<string|int, mixed>|float|string
WEIBULL.
ZTEST()  : array<string|int, mixed>|float|string
ZTEST.

Constants

LOG_GAMMA_X_MAX_VALUE

public mixed LOG_GAMMA_X_MAX_VALUE = 2.55E+305

Methods

AVEDEV()

AVEDEV.

public static AVEDEV(mixed ...$args) : float|string

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[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Averages::averageDeviations()

Use the averageDeviations() method in the Statistical\Averages class instead

Return values
float|string

AVERAGE()

AVERAGE.

public static AVERAGE(mixed ...$args) : float|string

Returns the average (arithmetic mean) of the arguments

Excel Function: AVERAGE(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Averages::average()

Use the average() method in the Statistical\Averages class instead

Return values
float|string

AVERAGEA()

AVERAGEA.

public static AVERAGEA(mixed ...$args) : float|string

Returns the average of its arguments, including numbers, text, and logical values

Excel Function: AVERAGEA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Averages::averageA()

Use the averageA() method in the Statistical\Averages class instead

Return values
float|string

AVERAGEIF()

AVERAGEIF.

public static AVERAGEIF(mixed $range, string $condition[, array<string|int, mixed> $averageRange = [] ]) : null|float|string

Returns the average value from a range of cells that contain numbers within the list of arguments

Excel Function: AVERAGEIF(value1[,value2[, ...]],condition)

Parameters
$range : mixed

Data values

$condition : string

the criteria that defines which cells will be checked

$averageRange : array<string|int, mixed> = []

Data values

Tags
Deprecated

1.17.0

see
Conditional::AVERAGEIF()

Use the AVERAGEIF() method in the Statistical\Conditional class instead

Return values
null|float|string

BETADIST()

BETADIST.

public static BETADIST(float $value, float $alpha, float $beta, mixed $rMin[, mixed $rMax = 1 ]) : array<string|int, mixed>|float|string

Returns the beta distribution.

Parameters
$value : float

Value at which you want to evaluate the distribution

$alpha : float

Parameter to the distribution

$beta : float

Parameter to the distribution

$rMin : mixed
$rMax : mixed = 1
Tags
Deprecated

1.18.0

see
Beta::distribution()

Use the distribution() method in the Statistical\Distributions\Beta class instead

Return values
array<string|int, mixed>|float|string

BETAINV()

BETAINV.

public static BETAINV(float $probability, float $alpha, float $beta, float $rMin[, float $rMax = 1 ]) : array<string|int, mixed>|float|string

Returns the inverse of the Beta distribution.

Parameters
$probability : float

Probability at which you want to evaluate the distribution

$alpha : float

Parameter to the distribution

$beta : float

Parameter to the distribution

$rMin : float

Minimum value

$rMax : float = 1

Maximum value

Tags
Deprecated

1.18.0

see
Beta::inverse()

Use the inverse() method in the Statistical\Distributions\Beta class instead

Return values
array<string|int, mixed>|float|string

BINOMDIST()

BINOMDIST.

public static BINOMDIST(mixed $value, mixed $trials, mixed $probability, mixed $cumulative) : array<string|int, mixed>|float|string

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.

Parameters
$value : mixed

Number of successes in trials

$trials : mixed

Number of trials

$probability : mixed

Probability of success on each trial

$cumulative : mixed
Tags
Deprecated

1.18.0

see
Binomial::distribution()

Use the distribution() method in the Statistical\Distributions\Binomial class instead

Return values
array<string|int, mixed>|float|string

CHIDIST()

CHIDIST.

public static CHIDIST(float $value, float $degrees) : array<string|int, mixed>|float|string

Returns the one-tailed probability of the chi-squared distribution.

Parameters
$value : float

Value for the function

$degrees : float

degrees of freedom

Tags
Deprecated

1.18.0

see
ChiSquared::distributionRightTail()

Use the distributionRightTail() method in the Statistical\Distributions\ChiSquared class instead

Return values
array<string|int, mixed>|float|string

CHIINV()

CHIINV.

public static CHIINV(float $probability, float $degrees) : array<string|int, mixed>|float|string

Returns the one-tailed probability of the chi-squared distribution.

Parameters
$probability : float

Probability for the function

$degrees : float

degrees of freedom

Tags
Deprecated

1.18.0

see
ChiSquared::inverseRightTail()

Use the inverseRightTail() method in the Statistical\Distributions\ChiSquared class instead

Return values
array<string|int, mixed>|float|string

CONFIDENCE()

CONFIDENCE.

public static CONFIDENCE(float $alpha, float $stdDev, float $size) : array<string|int, mixed>|float|string

Returns the confidence interval for a population mean

Parameters
$alpha : float
$stdDev : float

Standard Deviation

$size : float
Tags
Deprecated

1.18.0

see
Confidence::CONFIDENCE()

Use the CONFIDENCE() method in the Statistical\Confidence class instead

Return values
array<string|int, mixed>|float|string

CORREL()

CORREL.

public static CORREL(mixed $yValues[, null|mixed $xValues = null ]) : float|string

Returns covariance, the average of the products of deviations for each data point pair.

Parameters
$yValues : mixed

array of mixed Data Series Y

$xValues : null|mixed = null

array of mixed Data Series X

Tags
Deprecated

1.18.0

see
Trends::CORREL()

Use the CORREL() method in the Statistical\Trends class instead

Return values
float|string

COUNT()

COUNT.

public static COUNT(mixed ...$args) : int

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNT(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Counts::COUNT()

Use the COUNT() method in the Statistical\Counts class instead

Return values
int

COUNTA()

COUNTA.

public static COUNTA(mixed ...$args) : int

Counts the number of cells that are not empty within the list of arguments

Excel Function: COUNTA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Counts::COUNTA()

Use the COUNTA() method in the Statistical\Counts class instead

Return values
int

COUNTBLANK()

COUNTBLANK.

public static COUNTBLANK(mixed ...$args) : int

Counts the number of empty cells within the list of arguments

Excel Function: COUNTBLANK(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Counts::COUNTBLANK()

Use the COUNTBLANK() method in the Statistical\Counts class instead

Return values
int

COUNTIF()

COUNTIF.

public static COUNTIF(mixed $range, string $condition) : int

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIF(range,condition)

Parameters
$range : mixed

Data values

$condition : string

the criteria that defines which cells will be counted

Tags
Deprecated

1.17.0

see
Conditional::COUNTIF()

Use the COUNTIF() method in the Statistical\Conditional class instead

Return values
int

COUNTIFS()

COUNTIFS.

public static COUNTIFS(mixed ...$args) : int

Counts the number of cells that contain numbers within the list of arguments

Excel Function: COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)

Parameters
$args : mixed

Pairs of Ranges and Criteria

Tags
Deprecated

1.17.0

see
Conditional::COUNTIFS()

Use the COUNTIFS() method in the Statistical\Conditional class instead

Return values
int

COVAR()

COVAR.

public static COVAR(mixed $yValues, mixed $xValues) : float|string

Returns covariance, the average of the products of deviations for each data point pair.

Parameters
$yValues : mixed

array of mixed Data Series Y

$xValues : mixed

array of mixed Data Series X

Tags
Deprecated

1.18.0

see
Trends::COVAR()

Use the COVAR() method in the Statistical\Trends class instead

Return values
float|string

CRITBINOM()

CRITBINOM.

public static CRITBINOM(float $trials, float $probability, float $alpha) : array<string|int, mixed>|int|string

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

Parameters
$trials : float

number of Bernoulli trials

$probability : float

probability of a success on each trial

$alpha : float

criterion value

Tags
Deprecated

1.18.0

see
Binomial::inverse()

Use the inverse() method in the Statistical\Distributions\Binomial class instead

Return values
array<string|int, mixed>|int|string

DEVSQ()

DEVSQ.

public static DEVSQ(mixed ...$args) : float|string

Returns the sum of squares of deviations of data points from their sample mean.

Excel Function: DEVSQ(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Deviations::sumSquares()

Use the sumSquares() method in the Statistical\Deviations class instead

Return values
float|string

EXPONDIST()

EXPONDIST.

public static EXPONDIST(float $value, float $lambda, bool $cumulative) : array<string|int, mixed>|float|string

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.

Parameters
$value : float

Value of the function

$lambda : float

The parameter value

$cumulative : bool
Tags
Deprecated

1.18.0

see
Exponential::distribution()

Use the distribution() method in the Statistical\Distributions\Exponential class instead

Return values
array<string|int, mixed>|float|string

FDIST2()

F.DIST.

public static FDIST2(float $value, int $u, int $v, bool $cumulative) : array<string|int, mixed>|float|string

Returns the F probability distribution. You can use this function to determine whether two data sets have different degrees of diversity. For example, you can examine the test scores of men and women entering high school, and determine if the variability in the females is different from that found in the males.

Parameters
$value : float

Value of the function

$u : int

The numerator degrees of freedom

$v : int

The denominator degrees of freedom

$cumulative : bool

If cumulative is TRUE, F.DIST returns the cumulative distribution function; if FALSE, it returns the probability density function.

Tags
Deprecated

1.18.0

see
F::distribution()

Use the distribution() method in the Statistical\Distributions\Exponential class instead

Return values
array<string|int, mixed>|float|string

FISHER()

FISHER.

public static FISHER(float $value) : array<string|int, mixed>|float|string

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.

Parameters
$value : float
Tags
Deprecated

1.18.0

see
Fisher::distribution()

Use the distribution() method in the Statistical\Distributions\Fisher class instead

Return values
array<string|int, mixed>|float|string

FISHERINV()

FISHERINV.

public static FISHERINV(float $value) : array<string|int, mixed>|float|string

Returns the inverse of the Fisher transformation. Use this transformation when analyzing correlations between ranges or arrays of data. If y = FISHER(x), then FISHERINV(y) = x.

Parameters
$value : float
Tags
Deprecated

1.18.0

see
Fisher::inverse()

Use the inverse() method in the Statistical\Distributions\Fisher class instead

Return values
array<string|int, mixed>|float|string

FORECAST()

FORECAST.

public static FORECAST(float $xValue, mixed $yValues, mixed $xValues) : array<string|int, mixed>|bool|float|string

Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value.

Parameters
$xValue : float

Value of X for which we want to find Y

$yValues : mixed

array of mixed Data Series Y

$xValues : mixed

of mixed Data Series X

Tags
Deprecated

1.18.0

see
Trends::FORECAST()

Use the FORECAST() method in the Statistical\Trends class instead

Return values
array<string|int, mixed>|bool|float|string

GAMMADIST()

GAMMADIST.

public static GAMMADIST(float $value, float $a, float $b, bool $cumulative) : array<string|int, mixed>|float|string

Returns the gamma distribution.

Parameters
$value : float

Value at which you want to evaluate the distribution

$a : float

Parameter to the distribution

$b : float

Parameter to the distribution

$cumulative : bool
Tags
Deprecated

1.18.0

see
Gamma::distribution()

Use the distribution() method in the Statistical\Distributions\Gamma class instead

Return values
array<string|int, mixed>|float|string

GAMMAFunction()

GAMMA.

public static GAMMAFunction(float $value) : array<string|int, mixed>|float|string

Returns the gamma function value.

Parameters
$value : float
Tags
Deprecated

1.18.0

see
Gamma::gamma()

Use the gamma() method in the Statistical\Distributions\Gamma class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

GAMMAINV()

GAMMAINV.

public static GAMMAINV(float $probability, float $alpha, float $beta) : array<string|int, mixed>|float|string

Returns the inverse of the Gamma distribution.

Parameters
$probability : float

Probability at which you want to evaluate the distribution

$alpha : float

Parameter to the distribution

$beta : float

Parameter to the distribution

Tags
Deprecated

1.18.0

see
Gamma::inverse()

Use the inverse() method in the Statistical\Distributions\Gamma class instead

Return values
array<string|int, mixed>|float|string

GAMMALN()

GAMMALN.

public static GAMMALN(float $value) : array<string|int, mixed>|float|string

Returns the natural logarithm of the gamma function.

Parameters
$value : float
Tags
Deprecated

1.18.0

see
Gamma::ln()

Use the ln() method in the Statistical\Distributions\Gamma class instead

Return values
array<string|int, mixed>|float|string

GAUSS()

GAUSS.

public static GAUSS(float $value) : array<string|int, mixed>|float|string

Calculates the probability that a member of a standard normal population will fall between the mean and z standard deviations from the mean.

Parameters
$value : float
Tags
Deprecated

1.18.0

see
StandardNormal::gauss()

Use the gauss() method in the Statistical\Distributions\StandardNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

GEOMEAN()

GEOMEAN.

public static GEOMEAN(mixed ...$args) : float|string

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[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Mean::geometric()

Use the geometric() method in the Statistical\Averages\Mean class instead

Return values
float|string

GROWTH()

GROWTH.

public static GROWTH(array<string|int, mixed> $yValues[, array<string|int, mixed> $xValues = [] ][, array<string|int, mixed> $newValues = [] ][, bool $const = true ]) : array<string|int, float>

Returns values along a predicted exponential Trend

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed> = []

Data Series X

$newValues : array<string|int, mixed> = []

Values of X for which we want to find Y

$const : bool = true

a logical value specifying whether to force the intersect to equal 0

Tags
Deprecated

1.18.0

see
Trends::GROWTH()

Use the GROWTH() method in the Statistical\Trends class instead

Return values
array<string|int, float>

HARMEAN()

HARMEAN.

public static HARMEAN(mixed ...$args) : float|string

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[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Mean::harmonic()

Use the harmonic() method in the Statistical\Averages\Mean class instead

Return values
float|string

HYPGEOMDIST()

HYPGEOMDIST.

public static HYPGEOMDIST(mixed $sampleSuccesses, mixed $sampleNumber, mixed $populationSuccesses, mixed $populationNumber) : array<string|int, mixed>|float|string

Returns the hypergeometric distribution. HYPGEOMDIST returns the probability of a given number of sample successes, given the sample size, population successes, and population size.

Parameters
$sampleSuccesses : mixed

Number of successes in the sample

$sampleNumber : mixed

Size of the sample

$populationSuccesses : mixed

Number of successes in the population

$populationNumber : mixed

Population size

Tags
Deprecated

1.18.0

see
HyperGeometric::distribution()

Use the distribution() method in the Statistical\Distributions\HyperGeometric class instead

Return values
array<string|int, mixed>|float|string

INTERCEPT()

INTERCEPT.

public static INTERCEPT(array<string|int, mixed> $yValues, array<string|int, mixed> $xValues) : float|string

Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed>

Data Series X

Tags
Deprecated

1.18.0

see
Trends::INTERCEPT()

Use the INTERCEPT() method in the Statistical\Trends class instead

Return values
float|string

KURT()

KURT.

public static KURT(array<string|int, mixed> ...$args) : float|string

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.

Parameters
$args : array<string|int, mixed>

Data Series

Tags
Deprecated

1.18.0

see
Deviations::kurtosis()

Use the kurtosis() method in the Statistical\Deviations class instead

Return values
float|string

LARGE()

LARGE.

public static LARGE(mixed ...$args) : float|string

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)

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Size::large()

Use the large() method in the Statistical\Size class instead

Return values
float|string

The result, or a string containing an error

LINEST()

LINEST.

public static LINEST(array<string|int, mixed> $yValues[, null|array<string|int, mixed> $xValues = null ][, bool $const = true ][, bool $stats = false ]) : array<string|int, mixed>|int|string

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.

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : null|array<string|int, mixed> = null

Data Series X

$const : bool = true

a logical value specifying whether to force the intersect to equal 0

$stats : bool = false

a logical value specifying whether to return additional regression statistics

Tags
Deprecated

1.18.0

see
Trends::LINEST()

Use the LINEST() method in the Statistical\Trends class instead

Return values
array<string|int, mixed>|int|string

The result, or a string containing an error

LOGEST()

LOGEST.

public static LOGEST(array<string|int, mixed> $yValues[, null|array<string|int, mixed> $xValues = null ][, bool $const = true ][, bool $stats = false ]) : array<string|int, mixed>|int|string

Calculates an exponential curve that best fits the X and Y data series, and then returns an array that describes the line.

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : null|array<string|int, mixed> = null

Data Series X

$const : bool = true

a logical value specifying whether to force the intersect to equal 0

$stats : bool = false

a logical value specifying whether to return additional regression statistics

Tags
Deprecated

1.18.0

see
Trends::LOGEST()

Use the LOGEST() method in the Statistical\Trends class instead

Return values
array<string|int, mixed>|int|string

The result, or a string containing an error

LOGINV()

LOGINV.

public static LOGINV(float $probability, float $mean, float $stdDev) : array<string|int, mixed>|float|string

Returns the inverse of the normal cumulative distribution

Parameters
$probability : float
$mean : float
$stdDev : float
Tags
Deprecated

1.18.0

see
LogNormal::inverse()

Use the inverse() method in the Statistical\Distributions\LogNormal class instead

TODO

Try implementing P J Acklam's refinement algorithm for greater accuracy if I can get my head round the mathematics (as described at) http://home.online.no/~pjacklam/notes/invnorm/

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

LOGNORMDIST()

LOGNORMDIST.

public static LOGNORMDIST(float $value, float $mean, float $stdDev) : array<string|int, mixed>|float|string

Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.

Parameters
$value : float
$mean : float
$stdDev : float
Tags
Deprecated

1.18.0

see
LogNormal::cumulative()

Use the cumulative() method in the Statistical\Distributions\LogNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

LOGNORMDIST2()

LOGNORM.DIST.

public static LOGNORMDIST2(float $value, float $mean, float $stdDev[, bool $cumulative = false ]) : array<string|int, mixed>|float|string

Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev.

Parameters
$value : float
$mean : float
$stdDev : float
$cumulative : bool = false
Tags
Deprecated

1.18.0

see
LogNormal::distribution()

Use the distribution() method in the Statistical\Distributions\LogNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

MAX()

MAX.

public static MAX(mixed ...$args) : float

MAX returns the value of the element of the values passed that has the highest value, with negative numbers considered smaller than positive numbers.

Excel Function: max(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Maximum::max()

Use the MAX() method in the Statistical\Maximum class instead

Return values
float

MAXA()

MAXA.

public static MAXA(mixed ...$args) : float

Returns the greatest value in a list of arguments, including numbers, text, and logical values

Excel Function: maxA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Maximum::maxA()

Use the MAXA() method in the Statistical\Maximum class instead

Return values
float

MAXIFS()

MAXIFS.

public static MAXIFS(mixed ...$args) : float

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], ...)

Parameters
$args : mixed

Data range and criterias

Tags
Deprecated

1.17.0

see
Conditional::MAXIFS()

Use the MAXIFS() method in the Statistical\Conditional class instead

Return values
float

MEDIAN()

MEDIAN.

public static MEDIAN(mixed ...$args) : float|string

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[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Averages::median()

Use the median() method in the Statistical\Averages class instead

Return values
float|string

The result, or a string containing an error

MIN()

MIN.

public static MIN(mixed ...$args) : float

MIN returns the value of the element of the values passed that has the smallest value, with negative numbers considered smaller than positive numbers.

Excel Function: MIN(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Minimum::min()

Use the min() method in the Statistical\Minimum class instead

Return values
float

MINA()

MINA.

public static MINA(mixed ...$args) : float

Returns the smallest value in a list of arguments, including numbers, text, and logical values

Excel Function: MINA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Minimum::minA()

Use the minA() method in the Statistical\Minimum class instead

Return values
float

MINIFS()

MINIFS.

public static MINIFS(mixed ...$args) : float

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], ...)

Parameters
$args : mixed

Data range and criterias

Tags
Deprecated

1.17.0

see
Conditional::MINIFS()

Use the MINIFS() method in the Statistical\Conditional class instead

Return values
float

MODE()

MODE.

public static MODE(mixed ...$args) : float|string

Returns the most frequently occurring, or repetitive, value in an array or range of data

Excel Function: MODE(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Averages::mode()

Use the mode() method in the Statistical\Averages class instead

Return values
float|string

The result, or a string containing an error

NEGBINOMDIST()

NEGBINOMDIST.

public static NEGBINOMDIST(mixed $failures, mixed $successes, mixed $probability) : array<string|int, mixed>|float|string

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.

Parameters
$failures : mixed

Number of Failures

$successes : mixed

Threshold number of Successes

$probability : mixed

Probability of success on each trial

Tags
Deprecated

1.18.0

see
Binomial::negative()

Use the negative() method in the Statistical\Distributions\Binomial class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

NORMDIST()

NORMDIST.

public static NORMDIST(mixed $value, mixed $mean, mixed $stdDev, mixed $cumulative) : array<string|int, mixed>|float|string

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.

Parameters
$value : mixed
$mean : mixed

Mean Value

$stdDev : mixed

Standard Deviation

$cumulative : mixed
Tags
Deprecated

1.18.0

see
Normal::distribution()

Use the distribution() method in the Statistical\Distributions\Normal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

NORMINV()

NORMINV.

public static NORMINV(mixed $probability, mixed $mean, mixed $stdDev) : array<string|int, mixed>|float|string

Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.

Parameters
$probability : mixed
$mean : mixed

Mean Value

$stdDev : mixed

Standard Deviation

Tags
Deprecated

1.18.0

see
Normal::inverse()

Use the inverse() method in the Statistical\Distributions\Normal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

NORMSDIST()

NORMSDIST.

public static NORMSDIST(mixed $value) : array<string|int, mixed>|float|string

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.

Parameters
$value : mixed
Tags
Deprecated

1.18.0

see
StandardNormal::cumulative()

Use the cumulative() method in the Statistical\Distributions\StandardNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

NORMSDIST2()

NORM.S.DIST.

public static NORMSDIST2(mixed $value, mixed $cumulative) : array<string|int, mixed>|float|string

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.

Parameters
$value : mixed
$cumulative : mixed
Tags
Deprecated

1.18.0

see
StandardNormal::distribution()

Use the distribution() method in the Statistical\Distributions\StandardNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

NORMSINV()

NORMSINV.

public static NORMSINV(mixed $value) : array<string|int, mixed>|float|string

Returns the inverse of the standard normal cumulative distribution

Parameters
$value : mixed
Tags
Deprecated

1.18.0

see
StandardNormal::inverse()

Use the inverse() method in the Statistical\Distributions\StandardNormal class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

PERCENTILE()

PERCENTILE.

public static PERCENTILE(mixed ...$args) : float|string

Returns the nth percentile of values in a range..

Excel Function: PERCENTILE(value1[,value2[, ...]],entry)

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Percentiles::PERCENTILE()

Use the PERCENTILE() method in the Statistical\Percentiles class instead

Return values
float|string

The result, or a string containing an error

PERCENTRANK()

PERCENTRANK.

public static PERCENTRANK(mixed $valueSet, mixed $value[, mixed $significance = 3 ]) : float|string

Returns the rank of a value in a data set as a percentage of the data set. Note that the returned rank is simply rounded to the appropriate significant digits, rather than floored (as MS Excel), so value 3 for a value set of 1, 2, 3, 4 will return 0.667 rather than 0.666

Parameters
$valueSet : mixed

An array of, or a reference to, a list of numbers

$value : mixed

the number whose rank you want to find

$significance : mixed = 3

the number of significant digits for the returned percentage value

Tags
Deprecated

1.18.0

see
Percentiles::PERCENTRANK()

Use the PERCENTRANK() method in the Statistical\Percentiles class instead

Return values
float|string

(string if result is an error)

PERMUT()

PERMUT.

public static PERMUT(int $numObjs, int $numInSet) : array<string|int, mixed>|float|int|string

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.

Parameters
$numObjs : int

Number of different objects

$numInSet : int

Number of objects in each permutation

Tags
Deprecated

1.17.0

see
Permutations::PERMUT()

Use the PERMUT() method in the Statistical\Permutations class instead

Return values
array<string|int, mixed>|float|int|string

Number of permutations, or a string containing an error

POISSON()

POISSON.

public static POISSON(mixed $value, mixed $mean, mixed $cumulative) : array<string|int, mixed>|float|string

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.

Parameters
$value : mixed
$mean : mixed

Mean Value

$cumulative : mixed
Tags
Deprecated

1.18.0

see
Poisson::distribution()

Use the distribution() method in the Statistical\Distributions\Poisson class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

QUARTILE()

QUARTILE.

public static QUARTILE(mixed ...$args) : float|string

Returns the quartile of a data set.

Excel Function: QUARTILE(value1[,value2[, ...]],entry)

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Percentiles::QUARTILE()

Use the QUARTILE() method in the Statistical\Percentiles class instead

Return values
float|string

The result, or a string containing an error

RANK()

RANK.

public static RANK(mixed $value, mixed $valueSet, mixed $order) : float|string

Returns the rank of a number in a list of numbers.

Parameters
$value : mixed

the number whose rank you want to find

$valueSet : mixed

An array of, or a reference to, a list of numbers

$order : mixed

Order to sort the values in the value set

Tags
Deprecated

1.18.0

see
Percentiles::RANK()

Use the RANK() method in the Statistical\Percentiles class instead

Return values
float|string

The result, or a string containing an error

RSQ()

RSQ.

public static RSQ(array<string|int, mixed> $yValues, array<string|int, mixed> $xValues) : float|string

Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed>

Data Series X

Tags
Deprecated

1.18.0

see
Trends::RSQ()

Use the RSQ() method in the Statistical\Trends class instead

Return values
float|string

The result, or a string containing an error

SKEW()

SKEW.

public static SKEW(array<string|int, mixed> ...$args) : float|string

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.

Parameters
$args : array<string|int, mixed>

Data Series

Tags
Deprecated

1.18.0

see
Deviations::skew()

Use the skew() method in the Statistical\Deviations class instead

Return values
float|string

The result, or a string containing an error

SLOPE()

SLOPE.

public static SLOPE(array<string|int, mixed> $yValues, array<string|int, mixed> $xValues) : float|string

Returns the slope of the linear regression line through data points in known_y's and known_x's.

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed>

Data Series X

Tags
Deprecated

1.18.0

see
Trends::SLOPE()

Use the SLOPE() method in the Statistical\Trends class instead

Return values
float|string

The result, or a string containing an error

SMALL()

SMALL.

public static SMALL(mixed ...$args) : float|string

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)

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Size::small()

Use the small() method in the Statistical\Size class instead

Return values
float|string

The result, or a string containing an error

STANDARDIZE()

STANDARDIZE.

public static STANDARDIZE(float $value, float $mean, float $stdDev) : array<string|int, mixed>|float|string

Returns a normalized value from a distribution characterized by mean and standard_dev.

Parameters
$value : float

Value to normalize

$mean : float

Mean Value

$stdDev : float

Standard Deviation

Tags
Deprecated

1.18.0

see
Standardize::execute()

Use the execute() method in the Statistical\Standardize class instead

Return values
array<string|int, mixed>|float|string

Standardized value, or a string containing an error

STDEV()

STDEV.

public static STDEV(mixed ...$args) : float|string

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[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
StandardDeviations::STDEV()

Use the STDEV() method in the Statistical\StandardDeviations class instead

Return values
float|string

The result, or a string containing an error

STDEVA()

STDEVA.

public static STDEVA(mixed ...$args) : float|string

Estimates standard deviation based on a sample, including numbers, text, and logical values

Excel Function: STDEVA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
StandardDeviations::STDEVA()

Use the STDEVA() method in the Statistical\StandardDeviations class instead

Return values
float|string

STDEVP()

STDEVP.

public static STDEVP(mixed ...$args) : float|string

Calculates standard deviation based on the entire population

Excel Function: STDEVP(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
StandardDeviations::STDEVP()

Use the STDEVP() method in the Statistical\StandardDeviations class instead

Return values
float|string

STDEVPA()

STDEVPA.

public static STDEVPA(mixed ...$args) : float|string

Calculates standard deviation based on the entire population, including numbers, text, and logical values

Excel Function: STDEVPA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
StandardDeviations::STDEVPA()

Use the STDEVPA() method in the Statistical\StandardDeviations class instead

Return values
float|string

STEYX()

STEYX.

public static STEYX(array<string|int, mixed> $yValues, array<string|int, mixed> $xValues) : float|string
Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed>

Data Series X

Tags
Deprecated

1.18.0

see
Trends::STEYX()

Use the STEYX() method in the Statistical\Trends class instead

Returns the standard error of the predicted y-value for each x in the regression.

Return values
float|string

TDIST()

TDIST.

public static TDIST(float $value, float $degrees, float $tails) : array<string|int, mixed>|float|string

Returns the probability of Student's T distribution.

Parameters
$value : float

Value for the function

$degrees : float

degrees of freedom

$tails : float

number of tails (1 or 2)

Tags
Deprecated

1.18.0

see
StudentT::distribution()

Use the distribution() method in the Statistical\Distributions\StudentT class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

TINV()

TINV.

public static TINV(float $probability, float $degrees) : array<string|int, mixed>|float|string

Returns the one-tailed probability of the Student-T distribution.

Parameters
$probability : float

Probability for the function

$degrees : float

degrees of freedom

Tags
Deprecated

1.18.0

see
StudentT::inverse()

Use the inverse() method in the Statistical\Distributions\StudentT class instead

Return values
array<string|int, mixed>|float|string

The result, or a string containing an error

TREND()

TREND.

public static TREND(array<string|int, mixed> $yValues[, array<string|int, mixed> $xValues = [] ][, array<string|int, mixed> $newValues = [] ][, bool $const = true ]) : array<string|int, float>

Returns values along a linear Trend

Parameters
$yValues : array<string|int, mixed>

Data Series Y

$xValues : array<string|int, mixed> = []

Data Series X

$newValues : array<string|int, mixed> = []

Values of X for which we want to find Y

$const : bool = true

a logical value specifying whether to force the intersect to equal 0

Tags
Deprecated

1.18.0

see
Trends::TREND()

Use the TREND() method in the Statistical\Trends class instead

Return values
array<string|int, float>

TRIMMEAN()

TRIMMEAN.

public static TRIMMEAN(mixed ...$args) : float|string

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)

Parameters
$args : mixed

Data values

Tags
Deprecated

1.18.0

see
Mean::trim()

Use the trim() method in the Statistical\Averages\Mean class instead

Return values
float|string

VARA()

VARA.

public static VARA(mixed ...$args) : float|string

Estimates variance based on a sample, including numbers, text, and logical values

Excel Function: VARA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Variances::VARA()

Use the VARA() method in the Statistical\Variances class instead

Return values
float|string

(string if result is an error)

VARFunc()

VARFunc.

public static VARFunc(mixed ...$args) : float|string

Estimates variance based on a sample.

Excel Function: VAR(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Variances::VAR()

Use the VAR() method in the Statistical\Variances class instead

Return values
float|string

(string if result is an error)

VARP()

VARP.

public static VARP(mixed ...$args) : float|string

Calculates variance based on the entire population

Excel Function: VARP(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Variances::VARP()

Use the VARP() method in the Statistical\Variances class instead

Return values
float|string

(string if result is an error)

VARPA()

VARPA.

public static VARPA(mixed ...$args) : float|string

Calculates variance based on the entire population, including numbers, text, and logical values

Excel Function: VARPA(value1[,value2[, ...]])

Parameters
$args : mixed

Data values

Tags
Deprecated

1.17.0

see
Variances::VARPA()

Use the VARPA() method in the Statistical\Variances class instead

Return values
float|string

(string if result is an error)

WEIBULL()

WEIBULL.

public static WEIBULL(float $value, float $alpha, float $beta, bool $cumulative) : array<string|int, mixed>|float|string

Returns the Weibull distribution. Use this distribution in reliability analysis, such as calculating a device's mean time to failure.

Parameters
$value : float
$alpha : float

Alpha Parameter

$beta : float

Beta Parameter

$cumulative : bool
Tags
Deprecated

1.18.0

see
Weibull::distribution()

Use the distribution() method in the Statistical\Distributions\Weibull class instead

Return values
array<string|int, mixed>|float|string

(string if result is an error)

ZTEST()

ZTEST.

public static ZTEST(float $dataSet, float $m0[, float $sigma = null ]) : array<string|int, mixed>|float|string

Returns the one-tailed P-value of a z-test.

For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.

Parameters
$dataSet : float
$m0 : float

Alpha Parameter

$sigma : float = null

Beta Parameter

Tags
Deprecated

1.18.0

see
StandardNormal::zTest()

Use the zTest() method in the Statistical\Distributions\StandardNormal class instead

Return values
array<string|int, mixed>|float|string

(string if result is an error)

Search results