Viewing file:  Statistical.php (55.11 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?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);
}
}
|