<?php
namespace PhpOffice\PhpSpreadsheet\Calculation;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Averages;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Conditional;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Confidence;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Counts;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Maximum;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Minimum;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Permutations;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\StandardDeviations;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Trends;
use PhpOffice\PhpSpreadsheet\Calculation\Statistical\Variances;
/**
* @deprecated 1.18.0
*/
class Statistical
{
const LOG_GAMMA_X_MAX_VALUE = 2.55e305;
const EPS = 2.22e-16;
const MAX_VALUE = 1.2e308;
const SQRT2PI = 2.5066282746310005024157652848110452530069867406099;
/**
* 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[, ...]])
*
* @deprecated 1.17.0
* Use the averageDeviations() method in the Statistical\Averages class instead
* @see Statistical\Averages::averageDeviations()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function AVEDEV(...$args)
{
return Averages::averageDeviations(...$args);
}
/**
* AVERAGE.
*
* Returns the average (arithmetic mean) of the arguments
*
* Excel Function:
* AVERAGE(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the average() method in the Statistical\Averages class instead
* @see Statistical\Averages::average()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function AVERAGE(...$args)
{
return Averages::average(...$args);
}
/**
* AVERAGEA.
*
* Returns the average of its arguments, including numbers, text, and logical values
*
* Excel Function:
* AVERAGEA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the averageA() method in the Statistical\Averages class instead
* @see Statistical\Averages::averageA()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function AVERAGEA(...$args)
{
return Averages::averageA(...$args);
}
/**
* AVERAGEIF.
*
* Returns the average value from a range of cells that contain numbers within the list of arguments
*
* Excel Function:
* AVERAGEIF(value1[,value2[, ...]],condition)
*
* @deprecated 1.17.0
* Use the AVERAGEIF() method in the Statistical\Conditional class instead
* @see Statistical\Conditional::AVERAGEIF()
*
* @param mixed $range Data values
* @param string $condition the criteria that defines which cells will be checked
* @param mixed[] $averageRange Data values
*
* @return null|float|string
*/
public static function AVERAGEIF($range, $condition, $averageRange = [])
{
return Conditional::AVERAGEIF($range, $condition, $averageRange);
}
/**
* BETADIST.
*
* Returns the beta distribution.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Beta class instead
* @see Statistical\Distributions\Beta::distribution()
*
* @param float $value Value at which you want to evaluate the distribution
* @param float $alpha Parameter to the distribution
* @param float $beta Parameter to the distribution
* @param mixed $rMin
* @param mixed $rMax
*
* @return array|float|string
*/
public static function BETADIST($value, $alpha, $beta, $rMin = 0, $rMax = 1)
{
return Statistical\Distributions\Beta::distribution($value, $alpha, $beta, $rMin, $rMax);
}
/**
* BETAINV.
*
* Returns the inverse of the Beta distribution.
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\Beta class instead
* @see Statistical\Distributions\Beta::inverse()
*
* @param float $probability Probability at which you want to evaluate the distribution
* @param float $alpha Parameter to the distribution
* @param float $beta Parameter to the distribution
* @param float $rMin Minimum value
* @param float $rMax Maximum value
*
* @return array|float|string
*/
public static function BETAINV($probability, $alpha, $beta, $rMin = 0, $rMax = 1)
{
return Statistical\Distributions\Beta::inverse($probability, $alpha, $beta, $rMin, $rMax);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Binomial class instead
* @see Statistical\Distributions\Binomial::distribution()
*
* @param mixed $value Number of successes in trials
* @param mixed $trials Number of trials
* @param mixed $probability Probability of success on each trial
* @param mixed $cumulative
*
* @return array|float|string
*/
public static function BINOMDIST($value, $trials, $probability, $cumulative)
{
return Statistical\Distributions\Binomial::distribution($value, $trials, $probability, $cumulative);
}
/**
* CHIDIST.
*
* Returns the one-tailed probability of the chi-squared distribution.
*
* @deprecated 1.18.0
* Use the distributionRightTail() method in the Statistical\Distributions\ChiSquared class instead
* @see Statistical\Distributions\ChiSquared::distributionRightTail()
*
* @param float $value Value for the function
* @param float $degrees degrees of freedom
*
* @return array|float|string
*/
public static function CHIDIST($value, $degrees)
{
return Statistical\Distributions\ChiSquared::distributionRightTail($value, $degrees);
}
/**
* CHIINV.
*
* Returns the one-tailed probability of the chi-squared distribution.
*
* @deprecated 1.18.0
* Use the inverseRightTail() method in the Statistical\Distributions\ChiSquared class instead
* @see Statistical\Distributions\ChiSquared::inverseRightTail()
*
* @param float $probability Probability for the function
* @param float $degrees degrees of freedom
*
* @return array|float|string
*/
public static function CHIINV($probability, $degrees)
{
return Statistical\Distributions\ChiSquared::inverseRightTail($probability, $degrees);
}
/**
* CONFIDENCE.
*
* Returns the confidence interval for a population mean
*
* @deprecated 1.18.0
* Use the CONFIDENCE() method in the Statistical\Confidence class instead
* @see Statistical\Confidence::CONFIDENCE()
*
* @param float $alpha
* @param float $stdDev Standard Deviation
* @param float $size
*
* @return array|float|string
*/
public static function CONFIDENCE($alpha, $stdDev, $size)
{
return Confidence::CONFIDENCE($alpha, $stdDev, $size);
}
/**
* CORREL.
*
* Returns covariance, the average of the products of deviations for each data point pair.
*
* @deprecated 1.18.0
* Use the CORREL() method in the Statistical\Trends class instead
* @see Statistical\Trends::CORREL()
*
* @param mixed $yValues array of mixed Data Series Y
* @param null|mixed $xValues array of mixed Data Series X
*
* @return float|string
*/
public static function CORREL($yValues, $xValues = null)
{
return Trends::CORREL($xValues, $yValues);
}
/**
* COUNT.
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* COUNT(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the COUNT() method in the Statistical\Counts class instead
* @see Statistical\Counts::COUNT()
*
* @param mixed ...$args Data values
*
* @return int
*/
public static function COUNT(...$args)
{
return Counts::COUNT(...$args);
}
/**
* COUNTA.
*
* Counts the number of cells that are not empty within the list of arguments
*
* Excel Function:
* COUNTA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the COUNTA() method in the Statistical\Counts class instead
* @see Statistical\Counts::COUNTA()
*
* @param mixed ...$args Data values
*
* @return int
*/
public static function COUNTA(...$args)
{
return Counts::COUNTA(...$args);
}
/**
* COUNTBLANK.
*
* Counts the number of empty cells within the list of arguments
*
* Excel Function:
* COUNTBLANK(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the COUNTBLANK() method in the Statistical\Counts class instead
* @see Statistical\Counts::COUNTBLANK()
*
* @param mixed $range Data values
*
* @return int
*/
public static function COUNTBLANK($range)
{
return Counts::COUNTBLANK($range);
}
/**
* COUNTIF.
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* COUNTIF(range,condition)
*
* @deprecated 1.17.0
* Use the COUNTIF() method in the Statistical\Conditional class instead
* @see Statistical\Conditional::COUNTIF()
*
* @param mixed $range Data values
* @param string $condition the criteria that defines which cells will be counted
*
* @return int|string
*/
public static function COUNTIF($range, $condition)
{
return Conditional::COUNTIF($range, $condition);
}
/**
* COUNTIFS.
*
* Counts the number of cells that contain numbers within the list of arguments
*
* Excel Function:
* COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
*
* @deprecated 1.17.0
* Use the COUNTIFS() method in the Statistical\Conditional class instead
* @see Statistical\Conditional::COUNTIFS()
*
* @param mixed $args Pairs of Ranges and Criteria
*
* @return int|string
*/
public static function COUNTIFS(...$args)
{
return Conditional::COUNTIFS(...$args);
}
/**
* COVAR.
*
* Returns covariance, the average of the products of deviations for each data point pair.
*
* @deprecated 1.18.0
* Use the COVAR() method in the Statistical\Trends class instead
* @see Statistical\Trends::COVAR()
*
* @param mixed $yValues array of mixed Data Series Y
* @param mixed $xValues array of mixed Data Series X
*
* @return float|string
*/
public static function COVAR($yValues, $xValues)
{
return Trends::COVAR($yValues, $xValues);
}
/**
* 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
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\Binomial class instead
* @see Statistical\Distributions\Binomial::inverse()
*
* @param float $trials number of Bernoulli trials
* @param float $probability probability of a success on each trial
* @param float $alpha criterion value
*
* @return array|int|string
*/
public static function CRITBINOM($trials, $probability, $alpha)
{
return Statistical\Distributions\Binomial::inverse($trials, $probability, $alpha);
}
/**
* DEVSQ.
*
* Returns the sum of squares of deviations of data points from their sample mean.
*
* Excel Function:
* DEVSQ(value1[,value2[, ...]])
*
* @deprecated 1.18.0
* Use the sumSquares() method in the Statistical\Deviations class instead
* @see Statistical\Deviations::sumSquares()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function DEVSQ(...$args)
{
return Statistical\Deviations::sumSquares(...$args);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Exponential class instead
* @see Statistical\Distributions\Exponential::distribution()
*
* @param float $value Value of the function
* @param float $lambda The parameter value
* @param bool $cumulative
*
* @return array|float|string
*/
public static function EXPONDIST($value, $lambda, $cumulative)
{
return Statistical\Distributions\Exponential::distribution($value, $lambda, $cumulative);
}
/**
* F.DIST.
*
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\F class instead
* @see Statistical\Distributions\F::distribution()
*
* @param float $value Value of the function
* @param int $u The numerator degrees of freedom
* @param int $v The denominator degrees of freedom
* @param bool $cumulative If cumulative is TRUE, F.DIST returns the cumulative distribution function;
* if FALSE, it returns the probability density function.
*
* @return array|float|string
*/
public static function FDIST2($value, $u, $v, $cumulative)
{
return Statistical\Distributions\F::distribution($value, $u, $v, $cumulative);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Fisher class instead
* @see Statistical\Distributions\Fisher::distribution()
*
* @param float $value
*
* @return array|float|string
*/
public static function FISHER($value)
{
return Statistical\Distributions\Fisher::distribution($value);
}
/**
* FISHERINV.
*
* 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.
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\Fisher class instead
* @see Statistical\Distributions\Fisher::inverse()
*
* @param float $value
*
* @return array|float|string
*/
public static function FISHERINV($value)
{
return Statistical\Distributions\Fisher::inverse($value);
}
/**
* FORECAST.
*
* Calculates, or predicts, a future value by using existing values. The predicted value is a y-value for a given x-value.
*
* @deprecated 1.18.0
* Use the FORECAST() method in the Statistical\Trends class instead
* @see Statistical\Trends::FORECAST()
*
* @param float $xValue Value of X for which we want to find Y
* @param mixed $yValues array of mixed Data Series Y
* @param mixed $xValues of mixed Data Series X
*
* @return array|bool|float|string
*/
public static function FORECAST($xValue, $yValues, $xValues)
{
return Trends::FORECAST($xValue, $yValues, $xValues);
}
/**
* GAMMA.
*
* Returns the gamma function value.
*
* @deprecated 1.18.0
* Use the gamma() method in the Statistical\Distributions\Gamma class instead
* @see Statistical\Distributions\Gamma::gamma()
*
* @param float $value
*
* @return array|float|string The result, or a string containing an error
*/
public static function GAMMAFunction($value)
{
return Statistical\Distributions\Gamma::gamma($value);
}
/**
* GAMMADIST.
*
* Returns the gamma distribution.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Gamma class instead
* @see Statistical\Distributions\Gamma::distribution()
*
* @param float $value Value at which you want to evaluate the distribution
* @param float $a Parameter to the distribution
* @param float $b Parameter to the distribution
* @param bool $cumulative
*
* @return array|float|string
*/
public static function GAMMADIST($value, $a, $b, $cumulative)
{
return Statistical\Distributions\Gamma::distribution($value, $a, $b, $cumulative);
}
/**
* GAMMAINV.
*
* Returns the inverse of the Gamma distribution.
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\Gamma class instead
* @see Statistical\Distributions\Gamma::inverse()
*
* @param float $probability Probability at which you want to evaluate the distribution
* @param float $alpha Parameter to the distribution
* @param float $beta Parameter to the distribution
*
* @return array|float|string
*/
public static function GAMMAINV($probability, $alpha, $beta)
{
return Statistical\Distributions\Gamma::inverse($probability, $alpha, $beta);
}
/**
* GAMMALN.
*
* Returns the natural logarithm of the gamma function.
*
* @deprecated 1.18.0
* Use the ln() method in the Statistical\Distributions\Gamma class instead
* @see Statistical\Distributions\Gamma::ln()
*
* @param float $value
*
* @return array|float|string
*/
public static function GAMMALN($value)
{
return Statistical\Distributions\Gamma::ln($value);
}
/**
* GAUSS.
*
* Calculates the probability that a member of a standard normal population will fall between
* the mean and z standard deviations from the mean.
*
* @deprecated 1.18.0
* Use the gauss() method in the Statistical\Distributions\StandardNormal class instead
* @see Statistical\Distributions\StandardNormal::gauss()
*
* @param float $value
*
* @return array|float|string The result, or a string containing an error
*/
public static function GAUSS($value)
{
return Statistical\Distributions\StandardNormal::gauss($value);
}
/**
* 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[, ...]])
*
* @deprecated 1.18.0
* Use the geometric() method in the Statistical\Averages\Mean class instead
* @see Statistical\Averages\Mean::geometric()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function GEOMEAN(...$args)
{
return Statistical\Averages\Mean::geometric(...$args);
}
/**
* GROWTH.
*
* Returns values along a predicted exponential Trend
*
* @deprecated 1.18.0
* Use the GROWTH() method in the Statistical\Trends class instead
* @see Statistical\Trends::GROWTH()
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
* @param mixed[] $newValues Values of X for which we want to find Y
* @param bool $const a logical value specifying whether to force the intersect to equal 0
*
* @return float[]
*/
public static function GROWTH($yValues, $xValues = [], $newValues = [], $const = true)
{
return Trends::GROWTH($yValues, $xValues, $newValues, $const);
}
/**
* 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[, ...]])
*
* @deprecated 1.18.0
* Use the harmonic() method in the Statistical\Averages\Mean class instead
* @see Statistical\Averages\Mean::harmonic()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function HARMEAN(...$args)
{
return Statistical\Averages\Mean::harmonic(...$args);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\HyperGeometric class instead
* @see Statistical\Distributions\HyperGeometric::distribution()
*
* @param mixed $sampleSuccesses Number of successes in the sample
* @param mixed $sampleNumber Size of the sample
* @param mixed $populationSuccesses Number of successes in the population
* @param mixed $populationNumber Population size
*
* @return array|float|string
*/
public static function HYPGEOMDIST($sampleSuccesses, $sampleNumber, $populationSuccesses, $populationNumber)
{
return Statistical\Distributions\HyperGeometric::distribution(
$sampleSuccesses,
$sampleNumber,
$populationSuccesses,
$populationNumber
);
}
/**
* INTERCEPT.
*
* Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.
*
* @deprecated 1.18.0
* Use the INTERCEPT() method in the Statistical\Trends class instead
* @see Statistical\Trends::INTERCEPT()
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
*
* @return float|string
*/
public static function INTERCEPT($yValues, $xValues)
{
return Trends::INTERCEPT($yValues, $xValues);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the kurtosis() method in the Statistical\Deviations class instead
* @see Statistical\Deviations::kurtosis()
*
* @param array ...$args Data Series
*
* @return float|string
*/
public static function KURT(...$args)
{
return Statistical\Deviations::kurtosis(...$args);
}
/**
* 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)
*
* @deprecated 1.18.0
* Use the large() method in the Statistical\Size class instead
* @see Statistical\Size::large()
*
* @param mixed $args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function LARGE(...$args)
{
return Statistical\Size::large(...$args);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the LINEST() method in the Statistical\Trends class instead
* @see Statistical\Trends::LINEST()
*
* @param mixed[] $yValues Data Series Y
* @param null|mixed[] $xValues Data Series X
* @param bool $const a logical value specifying whether to force the intersect to equal 0
* @param bool $stats a logical value specifying whether to return additional regression statistics
*
* @return array|int|string The result, or a string containing an error
*/
public static function LINEST($yValues, $xValues = null, $const = true, $stats = false)
{
return Trends::LINEST($yValues, $xValues, $const, $stats);
}
/**
* LOGEST.
*
* Calculates an exponential curve that best fits the X and Y data series,
* and then returns an array that describes the line.
*
* @deprecated 1.18.0
* Use the LOGEST() method in the Statistical\Trends class instead
* @see Statistical\Trends::LOGEST()
*
* @param mixed[] $yValues Data Series Y
* @param null|mixed[] $xValues Data Series X
* @param bool $const a logical value specifying whether to force the intersect to equal 0
* @param bool $stats a logical value specifying whether to return additional regression statistics
*
* @return array|int|string The result, or a string containing an error
*/
public static function LOGEST($yValues, $xValues = null, $const = true, $stats = false)
{
return Trends::LOGEST($yValues, $xValues, $const, $stats);
}
/**
* LOGINV.
*
* Returns the inverse of the normal cumulative distribution
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\LogNormal class instead
* @see Statistical\Distributions\LogNormal::inverse()
*
* @param float $probability
* @param float $mean
* @param float $stdDev
*
* @return array|float|string The result, or a string containing an error
*
* @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/
*/
public static function LOGINV($probability, $mean, $stdDev)
{
return Statistical\Distributions\LogNormal::inverse($probability, $mean, $stdDev);
}
/**
* LOGNORMDIST.
*
* Returns the cumulative lognormal distribution of x, where ln(x) is normally distributed
* with parameters mean and standard_dev.
*
* @deprecated 1.18.0
* Use the cumulative() method in the Statistical\Distributions\LogNormal class instead
* @see Statistical\Distributions\LogNormal::cumulative()
*
* @param float $value
* @param float $mean
* @param float $stdDev
*
* @return array|float|string The result, or a string containing an error
*/
public static function LOGNORMDIST($value, $mean, $stdDev)
{
return Statistical\Distributions\LogNormal::cumulative($value, $mean, $stdDev);
}
/**
* LOGNORM.DIST.
*
* Returns the lognormal distribution of x, where ln(x) is normally distributed
* with parameters mean and standard_dev.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\LogNormal class instead
* @see Statistical\Distributions\LogNormal::distribution()
*
* @param float $value
* @param float $mean
* @param float $stdDev
* @param bool $cumulative
*
* @return array|float|string The result, or a string containing an error
*/
public static function LOGNORMDIST2($value, $mean, $stdDev, $cumulative = false)
{
return Statistical\Distributions\LogNormal::distribution($value, $mean, $stdDev, $cumulative);
}
/**
* MAX.
*
* 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[, ...]])
*
* @deprecated 1.17.0
* Use the MAX() method in the Statistical\Maximum class instead
* @see Statistical\Maximum::max()
*
* @param mixed ...$args Data values
*
* @return float
*/
public static function MAX(...$args)
{
return Maximum::max(...$args);
}
/**
* MAXA.
*
* Returns the greatest value in a list of arguments, including numbers, text, and logical values
*
* Excel Function:
* maxA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the MAXA() method in the Statistical\Maximum class instead
* @see Statistical\Maximum::maxA()
*
* @param mixed ...$args Data values
*
* @return float
*/
public static function MAXA(...$args)
{
return Maximum::maxA(...$args);
}
/**
* 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], ...)
*
* @deprecated 1.17.0
* Use the MAXIFS() method in the Statistical\Conditional class instead
* @see Statistical\Conditional::MAXIFS()
*
* @param mixed $args Data range and criterias
*
* @return null|float|string
*/
public static function MAXIFS(...$args)
{
return Conditional::MAXIFS(...$args);
}
/**
* 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[, ...]])
*
* @deprecated 1.18.0
* Use the median() method in the Statistical\Averages class instead
* @see Statistical\Averages::median()
*
* @param mixed ...$args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function MEDIAN(...$args)
{
return Statistical\Averages::median(...$args);
}
/**
* MIN.
*
* 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[, ...]])
*
* @deprecated 1.17.0
* Use the min() method in the Statistical\Minimum class instead
* @see Statistical\Minimum::min()
*
* @param mixed ...$args Data values
*
* @return float
*/
public static function MIN(...$args)
{
return Minimum::min(...$args);
}
/**
* MINA.
*
* Returns the smallest value in a list of arguments, including numbers, text, and logical values
*
* Excel Function:
* MINA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the minA() method in the Statistical\Minimum class instead
* @see Statistical\Minimum::minA()
*
* @param mixed ...$args Data values
*
* @return float
*/
public static function MINA(...$args)
{
return Minimum::minA(...$args);
}
/**
* 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], ...)
*
* @deprecated 1.17.0
* Use the MINIFS() method in the Statistical\Conditional class instead
* @see Statistical\Conditional::MINIFS()
*
* @param mixed $args Data range and criterias
*
* @return null|float|string
*/
public static function MINIFS(...$args)
{
return Conditional::MINIFS(...$args);
}
/**
* MODE.
*
* Returns the most frequently occurring, or repetitive, value in an array or range of data
*
* Excel Function:
* MODE(value1[,value2[, ...]])
*
* @deprecated 1.18.0
* Use the mode() method in the Statistical\Averages class instead
* @see Statistical\Averages::mode()
*
* @param mixed ...$args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function MODE(...$args)
{
return Statistical\Averages::mode(...$args);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the negative() method in the Statistical\Distributions\Binomial class instead
* @see Statistical\Distributions\Binomial::negative()
*
* @param mixed $failures Number of Failures
* @param mixed $successes Threshold number of Successes
* @param mixed $probability Probability of success on each trial
*
* @return array|float|string The result, or a string containing an error
*/
public static function NEGBINOMDIST($failures, $successes, $probability)
{
return Statistical\Distributions\Binomial::negative($failures, $successes, $probability);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Normal class instead
* @see Statistical\Distributions\Normal::distribution()
*
* @param mixed $value
* @param mixed $mean Mean Value
* @param mixed $stdDev Standard Deviation
* @param mixed $cumulative
*
* @return array|float|string The result, or a string containing an error
*/
public static function NORMDIST($value, $mean, $stdDev, $cumulative)
{
return Statistical\Distributions\Normal::distribution($value, $mean, $stdDev, $cumulative);
}
/**
* NORMINV.
*
* Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\Normal class instead
* @see Statistical\Distributions\Normal::inverse()
*
* @param mixed $probability
* @param mixed $mean Mean Value
* @param mixed $stdDev Standard Deviation
*
* @return array|float|string The result, or a string containing an error
*/
public static function NORMINV($probability, $mean, $stdDev)
{
return Statistical\Distributions\Normal::inverse($probability, $mean, $stdDev);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the cumulative() method in the Statistical\Distributions\StandardNormal class instead
* @see Statistical\Distributions\StandardNormal::cumulative()
*
* @param mixed $value
*
* @return array|float|string The result, or a string containing an error
*/
public static function NORMSDIST($value)
{
return Statistical\Distributions\StandardNormal::cumulative($value);
}
/**
* NORM.S.DIST.
*
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\StandardNormal class instead
* @see Statistical\Distributions\StandardNormal::distribution()
*
* @param mixed $value
* @param mixed $cumulative
*
* @return array|float|string The result, or a string containing an error
*/
public static function NORMSDIST2($value, $cumulative)
{
return Statistical\Distributions\StandardNormal::distribution($value, $cumulative);
}
/**
* NORMSINV.
*
* Returns the inverse of the standard normal cumulative distribution
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\StandardNormal class instead
* @see Statistical\Distributions\StandardNormal::inverse()
*
* @param mixed $value
*
* @return array|float|string The result, or a string containing an error
*/
public static function NORMSINV($value)
{
return Statistical\Distributions\StandardNormal::inverse($value);
}
/**
* PERCENTILE.
*
* Returns the nth percentile of values in a range..
*
* Excel Function:
* PERCENTILE(value1[,value2[, ...]],entry)
*
* @deprecated 1.18.0
* Use the PERCENTILE() method in the Statistical\Percentiles class instead
* @see Statistical\Percentiles::PERCENTILE()
*
* @param mixed $args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function PERCENTILE(...$args)
{
return Statistical\Percentiles::PERCENTILE(...$args);
}
/**
* PERCENTRANK.
*
* 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
*
* @deprecated 1.18.0
* Use the PERCENTRANK() method in the Statistical\Percentiles class instead
* @see Statistical\Percentiles::PERCENTRANK()
*
* @param mixed $valueSet An array of, or a reference to, a list of numbers
* @param mixed $value the number whose rank you want to find
* @param mixed $significance the number of significant digits for the returned percentage value
*
* @return float|string (string if result is an error)
*/
public static function PERCENTRANK($valueSet, $value, $significance = 3)
{
return Statistical\Percentiles::PERCENTRANK($valueSet, $value, $significance);
}
/**
* 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.
*
* @deprecated 1.17.0
* Use the PERMUT() method in the Statistical\Permutations class instead
* @see Statistical\Permutations::PERMUT()
*
* @param int $numObjs Number of different objects
* @param int $numInSet Number of objects in each permutation
*
* @return array|float|int|string Number of permutations, or a string containing an error
*/
public static function PERMUT($numObjs, $numInSet)
{
return Permutations::PERMUT($numObjs, $numInSet);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Poisson class instead
* @see Statistical\Distributions\Poisson::distribution()
*
* @param mixed $value
* @param mixed $mean Mean Value
* @param mixed $cumulative
*
* @return array|float|string The result, or a string containing an error
*/
public static function POISSON($value, $mean, $cumulative)
{
return Statistical\Distributions\Poisson::distribution($value, $mean, $cumulative);
}
/**
* QUARTILE.
*
* Returns the quartile of a data set.
*
* Excel Function:
* QUARTILE(value1[,value2[, ...]],entry)
*
* @deprecated 1.18.0
* Use the QUARTILE() method in the Statistical\Percentiles class instead
* @see Statistical\Percentiles::QUARTILE()
*
* @param mixed $args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function QUARTILE(...$args)
{
return Statistical\Percentiles::QUARTILE(...$args);
}
/**
* RANK.
*
* Returns the rank of a number in a list of numbers.
*
* @deprecated 1.18.0
* Use the RANK() method in the Statistical\Percentiles class instead
* @see Statistical\Percentiles::RANK()
*
* @param mixed $value the number whose rank you want to find
* @param mixed $valueSet An array of, or a reference to, a list of numbers
* @param mixed $order Order to sort the values in the value set
*
* @return float|string The result, or a string containing an error
*/
public static function RANK($value, $valueSet, $order = 0)
{
return Statistical\Percentiles::RANK($value, $valueSet, $order);
}
/**
* RSQ.
*
* Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
*
* @deprecated 1.18.0
* Use the RSQ() method in the Statistical\Trends class instead
* @see Statistical\Trends::RSQ()
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
*
* @return float|string The result, or a string containing an error
*/
public static function RSQ($yValues, $xValues)
{
return Trends::RSQ($yValues, $xValues);
}
/**
* 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.
*
* @deprecated 1.18.0
* Use the skew() method in the Statistical\Deviations class instead
* @see Statistical\Deviations::skew()
*
* @param array ...$args Data Series
*
* @return float|string The result, or a string containing an error
*/
public static function SKEW(...$args)
{
return Statistical\Deviations::skew(...$args);
}
/**
* SLOPE.
*
* Returns the slope of the linear regression line through data points in known_y's and known_x's.
*
* @deprecated 1.18.0
* Use the SLOPE() method in the Statistical\Trends class instead
* @see Statistical\Trends::SLOPE()
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
*
* @return float|string The result, or a string containing an error
*/
public static function SLOPE($yValues, $xValues)
{
return Trends::SLOPE($yValues, $xValues);
}
/**
* 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)
*
* @deprecated 1.18.0
* Use the small() method in the Statistical\Size class instead
* @see Statistical\Size::small()
*
* @param mixed $args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function SMALL(...$args)
{
return Statistical\Size::small(...$args);
}
/**
* STANDARDIZE.
*
* Returns a normalized value from a distribution characterized by mean and standard_dev.
*
* @deprecated 1.18.0
* Use the execute() method in the Statistical\Standardize class instead
* @see Statistical\Standardize::execute()
*
* @param float $value Value to normalize
* @param float $mean Mean Value
* @param float $stdDev Standard Deviation
*
* @return array|float|string Standardized value, or a string containing an error
*/
public static function STANDARDIZE($value, $mean, $stdDev)
{
return Statistical\Standardize::execute($value, $mean, $stdDev);
}
/**
* 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[, ...]])
*
* @deprecated 1.17.0
* Use the STDEV() method in the Statistical\StandardDeviations class instead
* @see Statistical\StandardDeviations::STDEV()
*
* @param mixed ...$args Data values
*
* @return float|string The result, or a string containing an error
*/
public static function STDEV(...$args)
{
return StandardDeviations::STDEV(...$args);
}
/**
* STDEVA.
*
* Estimates standard deviation based on a sample, including numbers, text, and logical values
*
* Excel Function:
* STDEVA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the STDEVA() method in the Statistical\StandardDeviations class instead
* @see Statistical\StandardDeviations::STDEVA()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function STDEVA(...$args)
{
return StandardDeviations::STDEVA(...$args);
}
/**
* STDEVP.
*
* Calculates standard deviation based on the entire population
*
* Excel Function:
* STDEVP(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the STDEVP() method in the Statistical\StandardDeviations class instead
* @see Statistical\StandardDeviations::STDEVP()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function STDEVP(...$args)
{
return StandardDeviations::STDEVP(...$args);
}
/**
* STDEVPA.
*
* Calculates standard deviation based on the entire population, including numbers, text, and logical values
*
* Excel Function:
* STDEVPA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the STDEVPA() method in the Statistical\StandardDeviations class instead
* @see Statistical\StandardDeviations::STDEVPA()
*
* @param mixed ...$args Data values
*
* @return float|string
*/
public static function STDEVPA(...$args)
{
return StandardDeviations::STDEVPA(...$args);
}
/**
* STEYX.
*
* @deprecated 1.18.0
* Use the STEYX() method in the Statistical\Trends class instead
* @see Statistical\Trends::STEYX()
*
* Returns the standard error of the predicted y-value for each x in the regression.
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
*
* @return float|string
*/
public static function STEYX($yValues, $xValues)
{
return Trends::STEYX($yValues, $xValues);
}
/**
* TDIST.
*
* Returns the probability of Student's T distribution.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\StudentT class instead
* @see Statistical\Distributions\StudentT::distribution()
*
* @param float $value Value for the function
* @param float $degrees degrees of freedom
* @param float $tails number of tails (1 or 2)
*
* @return array|float|string The result, or a string containing an error
*/
public static function TDIST($value, $degrees, $tails)
{
return Statistical\Distributions\StudentT::distribution($value, $degrees, $tails);
}
/**
* TINV.
*
* Returns the one-tailed probability of the Student-T distribution.
*
* @deprecated 1.18.0
* Use the inverse() method in the Statistical\Distributions\StudentT class instead
* @see Statistical\Distributions\StudentT::inverse()
*
* @param float $probability Probability for the function
* @param float $degrees degrees of freedom
*
* @return array|float|string The result, or a string containing an error
*/
public static function TINV($probability, $degrees)
{
return Statistical\Distributions\StudentT::inverse($probability, $degrees);
}
/**
* TREND.
*
* Returns values along a linear Trend
*
* @deprecated 1.18.0
* Use the TREND() method in the Statistical\Trends class instead
* @see Statistical\Trends::TREND()
*
* @param mixed[] $yValues Data Series Y
* @param mixed[] $xValues Data Series X
* @param mixed[] $newValues Values of X for which we want to find Y
* @param bool $const a logical value specifying whether to force the intersect to equal 0
*
* @return float[]
*/
public static function TREND($yValues, $xValues = [], $newValues = [], $const = true)
{
return Trends::TREND($yValues, $xValues, $newValues, $const);
}
/**
* 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)
*
* @deprecated 1.18.0
* Use the trim() method in the Statistical\Averages\Mean class instead
* @see Statistical\Averages\Mean::trim()
*
* @param mixed $args Data values
*
* @return float|string
*/
public static function TRIMMEAN(...$args)
{
return Statistical\Averages\Mean::trim(...$args);
}
/**
* VARFunc.
*
* Estimates variance based on a sample.
*
* Excel Function:
* VAR(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the VAR() method in the Statistical\Variances class instead
* @see Statistical\Variances::VAR()
*
* @param mixed ...$args Data values
*
* @return float|string (string if result is an error)
*/
public static function VARFunc(...$args)
{
return Variances::VAR(...$args);
}
/**
* VARA.
*
* Estimates variance based on a sample, including numbers, text, and logical values
*
* Excel Function:
* VARA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the VARA() method in the Statistical\Variances class instead
* @see Statistical\Variances::VARA()
*
* @param mixed ...$args Data values
*
* @return float|string (string if result is an error)
*/
public static function VARA(...$args)
{
return Variances::VARA(...$args);
}
/**
* VARP.
*
* Calculates variance based on the entire population
*
* Excel Function:
* VARP(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the VARP() method in the Statistical\Variances class instead
* @see Statistical\Variances::VARP()
*
* @param mixed ...$args Data values
*
* @return float|string (string if result is an error)
*/
public static function VARP(...$args)
{
return Variances::VARP(...$args);
}
/**
* VARPA.
*
* Calculates variance based on the entire population, including numbers, text, and logical values
*
* Excel Function:
* VARPA(value1[,value2[, ...]])
*
* @deprecated 1.17.0
* Use the VARPA() method in the Statistical\Variances class instead
* @see Statistical\Variances::VARPA()
*
* @param mixed ...$args Data values
*
* @return float|string (string if result is an error)
*/
public static function VARPA(...$args)
{
return Variances::VARPA(...$args);
}
/**
* WEIBULL.
*
* Returns the Weibull distribution. Use this distribution in reliability
* analysis, such as calculating a device's mean time to failure.
*
* @deprecated 1.18.0
* Use the distribution() method in the Statistical\Distributions\Weibull class instead
* @see Statistical\Distributions\Weibull::distribution()
*
* @param float $value
* @param float $alpha Alpha Parameter
* @param float $beta Beta Parameter
* @param bool $cumulative
*
* @return array|float|string (string if result is an error)
*/
public static function WEIBULL($value, $alpha, $beta, $cumulative)
{
return Statistical\Distributions\Weibull::distribution($value, $alpha, $beta, $cumulative);
}
/**
* ZTEST.
*
* 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.
*
* @deprecated 1.18.0
* Use the zTest() method in the Statistical\Distributions\StandardNormal class instead
* @see Statistical\Distributions\StandardNormal::zTest()
*
* @param mixed $dataSet
* @param float $m0 Alpha Parameter
* @param float $sigma Beta Parameter
*
* @return array|float|string (string if result is an error)
*/
public static function ZTEST($dataSet, $m0, $sigma = null)
{
return Statistical\Distributions\StandardNormal::zTest($dataSet, $m0, $sigma);
}
}
We’d love to hear from you! Whether you have questions, feedback, or need support, our team is here to help. Reach out to us via email, phone, or visit our office. We’re committed to providing you with exceptional service and ensuring your experience with NFC Pay is seamless and satisfying. Let’s connect!
Our Location
20-22 Wenlock Road, England, N1 7GU
Call us on: +03601 885399
Our office hours Monday–Friday, 9am - 9pm
Email us directly
support@example.com
In the digital age, privacy concerns have become increasingly paramount, prompting the European Union to enact the General Data Protection Regulation (GDPR) in 2018. Among its many provisions, GDPR sets strict guidelines for the collection and processing of personal data, including the use of cookies on websites. Privacy Policy
