404

D7net
:/ var / www / html / rosario / adm / phpoffice / phpspreadsheet / src / PhpSpreadsheet / Calculation /
Filename : Statistical.php
back
<?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
     *
     * @see Statistical\Averages::averageDeviations()
     *      Use the averageDeviations() method in the Statistical\Averages class instead
     *
     * @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
     *
     * @see Statistical\Averages::average()
     *      Use the average() method in the Statistical\Averages class instead
     *
     * @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
     *
     * @see Statistical\Averages::averageA()
     *      Use the averageA() method in the Statistical\Averages class instead
     *
     * @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
     *
     * @see Statistical\Conditional::AVERAGEIF()
     *      Use the AVERAGEIF() method in the Statistical\Conditional class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Beta::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Beta class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Beta::inverse()
     *      Use the inverse() method in the Statistical\Distributions\Beta class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Binomial::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Binomial class instead
     *
     * @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
     *
     * @see Statistical\Distributions\ChiSquared::distributionRightTail()
     *      Use the distributionRightTail() method in the Statistical\Distributions\ChiSquared class instead
     *
     * @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
     *
     * @see Statistical\Distributions\ChiSquared::inverseRightTail()
     *      Use the inverseRightTail() method in the Statistical\Distributions\ChiSquared class instead
     *
     * @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
     *
     * @see Statistical\Confidence::CONFIDENCE()
     *      Use the CONFIDENCE() method in the Statistical\Confidence class instead
     *
     * @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
     *
     * @see Statistical\Trends::CORREL()
     *      Use the CORREL() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Counts::COUNT()
     *      Use the COUNT() method in the Statistical\Counts class instead
     *
     * @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
     *
     * @see Statistical\Counts::COUNTA()
     *      Use the COUNTA() method in the Statistical\Counts class instead
     *
     * @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
     *
     * @see Statistical\Counts::COUNTBLANK()
     *      Use the COUNTBLANK() method in the Statistical\Counts class instead
     *
     * @param mixed ...$args Data values
     *
     * @return int
     */
    public static function COUNTBLANK(...$args)
    {
        return Counts::COUNTBLANK(...$args);
    }

    /**
     * COUNTIF.
     *
     * Counts the number of cells that contain numbers within the list of arguments
     *
     * Excel Function:
     *        COUNTIF(range,condition)
     *
     * @Deprecated 1.17.0
     *
     * @see Statistical\Conditional::COUNTIF()
     *      Use the COUNTIF() method in the Statistical\Conditional class instead
     *
     * @param mixed $range Data values
     * @param string $condition the criteria that defines which cells will be counted
     *
     * @return int
     */
    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
     *
     * @see Statistical\Conditional::COUNTIFS()
     *      Use the COUNTIFS() method in the Statistical\Conditional class instead
     *
     * @param mixed $args Pairs of Ranges and Criteria
     *
     * @return int
     */
    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
     *
     * @see Statistical\Trends::COVAR()
     *      Use the COVAR() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Binomial::inverse()
     *      Use the inverse() method in the Statistical\Distributions\Binomial class instead
     *
     * @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
     *
     * @see Statistical\Deviations::sumSquares()
     *      Use the sumSquares() method in the Statistical\Deviations class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Exponential::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Exponential class instead
     *
     * @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
     *
     * @see Statistical\Distributions\F::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Exponential class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Fisher::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Fisher class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Fisher::inverse()
     *      Use the inverse() method in the Statistical\Distributions\Fisher class instead
     *
     * @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
     *
     * @see Statistical\Trends::FORECAST()
     *      Use the FORECAST() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Gamma::gamma()
     *      Use the gamma() method in the Statistical\Distributions\Gamma class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Gamma::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Gamma class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Gamma::inverse()
     *      Use the inverse() method in the Statistical\Distributions\Gamma class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Gamma::ln()
     *      Use the ln() method in the Statistical\Distributions\Gamma class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StandardNormal::gauss()
     *      Use the gauss() method in the Statistical\Distributions\StandardNormal class instead
     *
     * @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
     *
     * @see Statistical\Averages\Mean::geometric()
     *      Use the geometric() method in the Statistical\Averages\Mean class instead
     *
     * @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
     *
     * @see Statistical\Trends::GROWTH()
     *      Use the GROWTH() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Averages\Mean::harmonic()
     *      Use the harmonic() method in the Statistical\Averages\Mean class instead
     *
     * @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
     *
     * @see Statistical\Distributions\HyperGeometric::distribution()
     *      Use the distribution() method in the Statistical\Distributions\HyperGeometric class instead
     *
     * @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
     *
     * @see Statistical\Trends::INTERCEPT()
     *      Use the INTERCEPT() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Deviations::kurtosis()
     *      Use the kurtosis() method in the Statistical\Deviations class instead
     *
     * @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
     *
     * @see Statistical\Size::large()
     *      Use the large() method in the Statistical\Size class instead
     *
     * @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
     *
     * @see Statistical\Trends::LINEST()
     *      Use the LINEST() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Trends::LOGEST()
     *      Use the LOGEST() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Distributions\LogNormal::inverse()
     *      Use the inverse() method in the Statistical\Distributions\LogNormal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\LogNormal::cumulative()
     *      Use the cumulative() method in the Statistical\Distributions\LogNormal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\LogNormal::distribution()
     *      Use the distribution() method in the Statistical\Distributions\LogNormal class instead
     *
     * @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
     *
     * @param mixed ...$args Data values
     *
     * @return float
     *
     *@see Statistical\Maximum::max()
     *      Use the MAX() method in the Statistical\Maximum class instead
     */
    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
     *
     * @param mixed ...$args Data values
     *
     * @return float
     *
     *@see Statistical\Maximum::maxA()
     *      Use the MAXA() method in the Statistical\Maximum class instead
     */
    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
     *
     * @see Statistical\Conditional::MAXIFS()
     *      Use the MAXIFS() method in the Statistical\Conditional class instead
     *
     * @param mixed $args Data range and criterias
     *
     * @return float
     */
    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
     *
     * @see Statistical\Averages::median()
     *      Use the median() method in the Statistical\Averages class instead
     *
     * @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
     *
     * @param mixed ...$args Data values
     *
     * @return float
     *
     *@see Statistical\Minimum::min()
     *      Use the min() method in the Statistical\Minimum class instead
     */
    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
     *
     * @param mixed ...$args Data values
     *
     * @return float
     *
     *@see Statistical\Minimum::minA()
     *      Use the minA() method in the Statistical\Minimum class instead
     */
    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
     *
     * @see Statistical\Conditional::MINIFS()
     *      Use the MINIFS() method in the Statistical\Conditional class instead
     *
     * @param mixed $args Data range and criterias
     *
     * @return float
     */
    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
     *
     * @see Statistical\Averages::mode()
     *      Use the mode() method in the Statistical\Averages class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Binomial::negative()
     *      Use the negative() method in the Statistical\Distributions\Binomial class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Normal::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Normal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Normal::inverse()
     *      Use the inverse() method in the Statistical\Distributions\Normal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StandardNormal::cumulative()
     *      Use the cumulative() method in the Statistical\Distributions\StandardNormal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StandardNormal::distribution()
     *      Use the distribution() method in the Statistical\Distributions\StandardNormal class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StandardNormal::inverse()
     *      Use the inverse() method in the Statistical\Distributions\StandardNormal class instead
     *
     * @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
     *
     * @see Statistical\Percentiles::PERCENTILE()
     * Use the PERCENTILE() method in the Statistical\Percentiles class instead
     *
     * @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
     *
     * @see Statistical\Percentiles::PERCENTRANK()
     * Use the PERCENTRANK() method in the Statistical\Percentiles class instead
     *
     * @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
     *
     * @see Statistical\Permutations::PERMUT()
     * Use the PERMUT() method in the Statistical\Permutations class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Poisson::distribution()
     * Use the distribution() method in the Statistical\Distributions\Poisson class instead
     *
     * @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
     *
     * @see Statistical\Percentiles::QUARTILE()
     * Use the QUARTILE() method in the Statistical\Percentiles class instead
     *
     * @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
     *
     * @see Statistical\Percentiles::RANK()
     * Use the RANK() method in the Statistical\Percentiles class instead
     *
     * @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
     *
     * @see Statistical\Trends::RSQ()
     *      Use the RSQ() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Deviations::skew()
     *      Use the skew() method in the Statistical\Deviations class instead
     *
     * @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
     *
     * @see Statistical\Trends::SLOPE()
     *      Use the SLOPE() method in the Statistical\Trends class instead
     *
     * @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
     *
     * @see Statistical\Size::small()
     *      Use the small() method in the Statistical\Size class instead
     *
     * @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
     *
     * @see Statistical\Standardize::execute()
     *      Use the execute() method in the Statistical\Standardize class instead
     *
     * @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
     *
     * @see Statistical\StandardDeviations::STDEV()
     *      Use the STDEV() method in the Statistical\StandardDeviations class instead
     *
     * @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
     *
     * @see Statistical\StandardDeviations::STDEVA()
     *      Use the STDEVA() method in the Statistical\StandardDeviations class instead
     *
     * @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
     *
     * @see Statistical\StandardDeviations::STDEVP()
     *      Use the STDEVP() method in the Statistical\StandardDeviations class instead
     *
     * @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
     *
     * @see Statistical\StandardDeviations::STDEVPA()
     *      Use the STDEVPA() method in the Statistical\StandardDeviations class instead
     *
     * @param mixed ...$args Data values
     *
     * @return float|string
     */
    public static function STDEVPA(...$args)
    {
        return StandardDeviations::STDEVPA(...$args);
    }

    /**
     * STEYX.
     *
     * @Deprecated 1.18.0
     *
     * @see Statistical\Trends::STEYX()
     *      Use the STEYX() method in the Statistical\Trends class instead
     *
     * Returns the standard error of the predicted y-value for each x in the regression.
     *
     * @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
     *
     * @see Statistical\Distributions\StudentT::distribution()
     *      Use the distribution() method in the Statistical\Distributions\StudentT class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StudentT::inverse()
     *      Use the inverse() method in the Statistical\Distributions\StudentT class instead
     *
     * @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
     *
     * @see Statistical\Trends::TREND()
     *      Use the TREND() method in the Statistical\Trends class instead
     *
     * @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
     *
     *@see Statistical\Averages\Mean::trim()
     *      Use the trim() method in the Statistical\Averages\Mean class instead
     *
     * @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
     *
     *@see Statistical\Variances::VAR()
     *      Use the VAR() method in the Statistical\Variances class instead
     *
     * @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
     *
     * @see Statistical\Variances::VARA()
     *      Use the VARA() method in the Statistical\Variances class instead
     *
     * @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
     *
     * @see Statistical\Variances::VARP()
     *      Use the VARP() method in the Statistical\Variances class instead
     *
     * @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
     *
     * @see Statistical\Variances::VARPA()
     *      Use the VARPA() method in the Statistical\Variances class instead
     *
     * @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
     *
     * @see Statistical\Distributions\Weibull::distribution()
     *      Use the distribution() method in the Statistical\Distributions\Weibull class instead
     *
     * @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
     *
     * @see Statistical\Distributions\StandardNormal::zTest()
     *      Use the zTest() method in the Statistical\Distributions\StandardNormal class instead
     *
     * @param float $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);
    }
}