class Statistical (View source)

Constants

LOG_GAMMA_X_MAX_VALUE

XMININ

EPS

MAX_VALUE

MAX_ITERATIONS

SQRT2PI

Methods

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

AVEDEV.

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

AVERAGE.

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

AVERAGEA.

static float|string
AVERAGEIF(mixed $aArgs, string $condition, mixed[] $averageArgs = [])

AVERAGEIF.

static float|string
BETADIST(float $value, float $alpha, float $beta, mixed $rMin = 0, mixed $rMax = 1)

BETADIST.

static float|string
BETAINV(float $probability, float $alpha, float $beta, float $rMin = 0, float $rMax = 1)

BETAINV.

static float|string
BINOMDIST(float $value, float $trials, float $probability, bool $cumulative)

BINOMDIST.

static float|string
CHIDIST(float $value, float $degrees)

CHIDIST.

static float|string
CHIINV(float $probability, float $degrees)

CHIINV.

static float|string
CONFIDENCE(float $alpha, float $stdDev, float $size)

CONFIDENCE.

static float|string
CORREL(mixed $yValues, null|mixed $xValues = null)

CORREL.

static int
COUNT(mixed ...$args)

COUNT.

static int
COUNTA(mixed ...$args)

COUNTA.

static int
COUNTBLANK(mixed ...$args)

COUNTBLANK.

static int
COUNTIF(mixed $aArgs, string $condition)

COUNTIF.

static int
COUNTIFS(mixed ...$args)

COUNTIFS.

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

COVAR.

static int|string
CRITBINOM(float $trials, float $probability, float $alpha)

CRITBINOM.

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

DEVSQ.

static float|string
EXPONDIST(float $value, float $lambda, bool $cumulative)

EXPONDIST.

static float|string
FISHER(float $value)

FISHER.

static float|string
FISHERINV(float $value)

FISHERINV.

static bool|float|string
FORECAST(float $xValue, mixed $yValues, mixed $xValues)

FORECAST.

static float|string
GAMMADIST(float $value, float $a, float $b, bool $cumulative)

GAMMADIST.

static float|string
GAMMAINV(float $probability, float $alpha, float $beta)

GAMMAINV.

static float|string
GAMMALN(float $value)

GAMMALN.

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

GEOMEAN.

static array
GROWTH(mixed[] $yValues, mixed[] $xValues = [], mixed[] $newValues = [], bool $const = true)

GROWTH.

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

HARMEAN.

static float|string
HYPGEOMDIST(float $sampleSuccesses, float $sampleNumber, float $populationSuccesses, float $populationNumber)

HYPGEOMDIST.

static float|string
INTERCEPT(mixed[] $yValues, mixed[] $xValues)

INTERCEPT.

static float|string
KURT(array ...$args)

KURT.

static float
LARGE(...$args)

LARGE.

static array
LINEST(mixed[] $yValues, null|mixed[] $xValues = null, bool $const = true, bool $stats = false)

LINEST.

static array
LOGEST(mixed[] $yValues, null|mixed[] $xValues = null, bool $const = true, bool $stats = false)

LOGEST.

static float
LOGINV(float $probability, float $mean, float $stdDev)

LOGINV.

static float
LOGNORMDIST(float $value, float $mean, float $stdDev)

LOGNORMDIST.

static float
MAX(mixed ...$args)

MAX.

static float
MAXA(mixed ...$args)

MAXA.

static float
MAXIFS(mixed ...$args)

MAXIFS.

static float
MEDIAN(mixed ...$args)

MEDIAN.

static float
MIN(mixed ...$args)

MIN.

static float
MINA(mixed ...$args)

MINA.

static float
MINIFS(mixed ...$args)

MINIFS.

static float
MODE(mixed ...$args)

MODE.

static float
NEGBINOMDIST(float $failures, float $successes, float $probability)

NEGBINOMDIST.

static float
NORMDIST(float $value, float $mean, float $stdDev, bool $cumulative)

NORMDIST.

static float
NORMINV(float $probability, float $mean, float $stdDev)

NORMINV.

static float
NORMSDIST(float $value)

NORMSDIST.

static float
NORMSINV(float $value)

NORMSINV.

static float
PERCENTILE(...$args)

PERCENTILE.

static float
PERCENTRANK(float[] $valueSet, int $value, int $significance = 3)

PERCENTRANK.

static int|string
PERMUT(int $numObjs, int $numInSet)

PERMUT.

static float
POISSON(float $value, float $mean, bool $cumulative)

POISSON.

static float
QUARTILE(...$args)

QUARTILE.

static float
RANK(int $value, float[] $valueSet, int $order = 0)

RANK.

static float|string
RSQ(mixed[] $yValues, mixed[] $xValues)

RSQ.

static float|string
SKEW(array ...$args)

SKEW.

static float|string
SLOPE(mixed[] $yValues, mixed[] $xValues)

SLOPE.

static float
SMALL(...$args)

SMALL.

static float
STANDARDIZE(float $value, float $mean, float $stdDev)

STANDARDIZE.

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

STDEV.

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

STDEVA.

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

STDEVP.

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

STDEVPA.

static float|string
STEYX(mixed[] $yValues, mixed[] $xValues)

STEYX.

static float
TDIST(float $value, float $degrees, float $tails)

TDIST.

static float
TINV(float $probability, float $degrees)

TINV.

static array
TREND(mixed[] $yValues, mixed[] $xValues = [], mixed[] $newValues = [], bool $const = true)

TREND.

static float|string
TRIMMEAN(...$args)

TRIMMEAN.

static float
VARFunc(mixed ...$args)

VARFunc.

static float
VARA(mixed ...$args)

VARA.

static float
VARP(mixed ...$args)

VARP.

static float
VARPA(mixed ...$args)

VARPA.

static float
WEIBULL(float $value, float $alpha, float $beta, bool $cumulative)

WEIBULL.

static float|string
ZTEST(float $dataSet, float $m0, float $sigma = null)

ZTEST.

Details

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

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

AVERAGE.

Returns the average (arithmetic mean) of the arguments

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

Parameters

mixed ...$args Data values

Return Value

float|string

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

AVERAGEA.

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

static float|string AVERAGEIF(mixed $aArgs, string $condition, mixed[] $averageArgs = [])

AVERAGEIF.

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

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

Parameters

mixed $aArgs Data values
string $condition the criteria that defines which cells will be checked
mixed[] $averageArgs Data values

Return Value

float|string

static float|string BETADIST(float $value, float $alpha, float $beta, mixed $rMin = 0, mixed $rMax = 1)

BETADIST.

Returns the beta distribution.

Parameters

float $value Value at which you want to evaluate the distribution
float $alpha Parameter to the distribution
float $beta Parameter to the distribution
mixed $rMin
mixed $rMax

Return Value

float|string

static float|string BETAINV(float $probability, float $alpha, float $beta, float $rMin = 0, float $rMax = 1)

BETAINV.

Returns the inverse of the beta distribution.

Parameters

float $probability Probability at which you want to evaluate the distribution
float $alpha Parameter to the distribution
float $beta Parameter to the distribution
float $rMin Minimum value
float $rMax Maximum value

Return Value

float|string

static float|string BINOMDIST(float $value, float $trials, float $probability, bool $cumulative)

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.

Parameters

float $value Number of successes in trials
float $trials Number of trials
float $probability Probability of success on each trial
bool $cumulative

Return Value

float|string

static float|string CHIDIST(float $value, float $degrees)

CHIDIST.

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

Parameters

float $value Value for the function
float $degrees degrees of freedom

Return Value

float|string

static float|string CHIINV(float $probability, float $degrees)

CHIINV.

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

Parameters

float $probability Probability for the function
float $degrees degrees of freedom

Return Value

float|string

static float|string CONFIDENCE(float $alpha, float $stdDev, float $size)

CONFIDENCE.

Returns the confidence interval for a population mean

Parameters

float $alpha
float $stdDev Standard Deviation
float $size

Return Value

float|string

static float|string CORREL(mixed $yValues, null|mixed $xValues = null)

CORREL.

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

Parameters

mixed $yValues array of mixed Data Series Y
null|mixed $xValues array of mixed Data Series X

Return Value

float|string

static int COUNT(mixed ...$args)

COUNT.

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

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

Parameters

mixed ...$args Data values

Return Value

int

static int COUNTA(mixed ...$args)

COUNTA.

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

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

Parameters

mixed ...$args Data values

Return Value

int

static int COUNTBLANK(mixed ...$args)

COUNTBLANK.

Counts the number of empty cells within the list of arguments

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

Parameters

mixed ...$args Data values

Return Value

int

static int COUNTIF(mixed $aArgs, string $condition)

COUNTIF.

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

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

Parameters

mixed $aArgs Data values
string $condition the criteria that defines which cells will be counted

Return Value

int

static int COUNTIFS(mixed ...$args)

COUNTIFS.

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

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

Parameters

mixed ...$args Criterias

Return Value

int

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

COVAR.

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

Parameters

mixed $yValues array of mixed Data Series Y
mixed $xValues array of mixed Data Series X

Return Value

float|string

static int|string CRITBINOM(float $trials, float $probability, float $alpha)

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

Parameters

float $trials number of Bernoulli trials
float $probability probability of a success on each trial
float $alpha criterion value

Return Value

int|string

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

DEVSQ.

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

static float|string EXPONDIST(float $value, float $lambda, bool $cumulative)

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.

Parameters

float $value Value of the function
float $lambda The parameter value
bool $cumulative

Return Value

float|string

static float|string FISHER(float $value)

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.

Parameters

float $value

Return Value

float|string

static float|string FISHERINV(float $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.

Parameters

float $value

Return Value

float|string

static bool|float|string FORECAST(float $xValue, mixed $yValues, mixed $xValues)

FORECAST.

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

Parameters

float $xValue Value of X for which we want to find Y
mixed $yValues array of mixed Data Series Y
mixed $xValues of mixed Data Series X

Return Value

bool|float|string

static float|string GAMMADIST(float $value, float $a, float $b, bool $cumulative)

GAMMADIST.

Returns the gamma distribution.

Parameters

float $value Value at which you want to evaluate the distribution
float $a Parameter to the distribution
float $b Parameter to the distribution
bool $cumulative

Return Value

float|string

static float|string GAMMAINV(float $probability, float $alpha, float $beta)

GAMMAINV.

Returns the inverse of the beta distribution.

Parameters

float $probability Probability at which you want to evaluate the distribution
float $alpha Parameter to the distribution
float $beta Parameter to the distribution

Return Value

float|string

static float|string GAMMALN(float $value)

GAMMALN.

Returns the natural logarithm of the gamma function.

Parameters

float $value

Return Value

float|string

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

static array GROWTH(mixed[] $yValues, mixed[] $xValues = [], mixed[] $newValues = [], bool $const = true)

GROWTH.

Returns values along a predicted exponential Trend

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X
mixed[] $newValues Values of X for which we want to find Y
bool $const a logical value specifying whether to force the intersect to equal 0

Return Value

array of float

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

static float|string HYPGEOMDIST(float $sampleSuccesses, float $sampleNumber, float $populationSuccesses, float $populationNumber)

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.

Parameters

float $sampleSuccesses Number of successes in the sample
float $sampleNumber Size of the sample
float $populationSuccesses Number of successes in the population
float $populationNumber Population size

Return Value

float|string

static float|string INTERCEPT(mixed[] $yValues, mixed[] $xValues)

INTERCEPT.

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

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X

Return Value

float|string

static float|string KURT(array ...$args)

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.

Parameters

array ...$args Data Series

Return Value

float|string

static float LARGE(...$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)

Parameters

...$args

Return Value

float

static array LINEST(mixed[] $yValues, null|mixed[] $xValues = null, bool $const = true, bool $stats = false)

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.

Parameters

mixed[] $yValues Data Series Y
null|mixed[] $xValues Data Series X
bool $const a logical value specifying whether to force the intersect to equal 0
bool $stats a logical value specifying whether to return additional regression statistics

Return Value

array

static array LOGEST(mixed[] $yValues, null|mixed[] $xValues = null, bool $const = true, bool $stats = false)

LOGEST.

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

Parameters

mixed[] $yValues Data Series Y
null|mixed[] $xValues Data Series X
bool $const a logical value specifying whether to force the intersect to equal 0
bool $stats a logical value specifying whether to return additional regression statistics

Return Value

array

static float LOGINV(float $probability, float $mean, float $stdDev)

LOGINV.

Returns the inverse of the normal cumulative distribution

Parameters

float $probability
float $mean
float $stdDev

Return Value

float

static float LOGNORMDIST(float $value, float $mean, float $stdDev)

LOGNORMDIST.

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

Parameters

float $value
float $mean
float $stdDev

Return Value

float

static float MAX(mixed ...$args)

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

Parameters

mixed ...$args Data values

Return Value

float

static float MAXA(mixed ...$args)

MAXA.

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

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

Parameters

mixed ...$args Data values

Return Value

float

static float MAXIFS(mixed ...$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], ...)

Parameters

mixed ...$args Data range and criterias

Return Value

float

static float MEDIAN(mixed ...$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[, ...]])

Parameters

mixed ...$args Data values

Return Value

float

static float MIN(mixed ...$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[, ...]])

Parameters

mixed ...$args Data values

Return Value

float

static float MINA(mixed ...$args)

MINA.

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

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

Parameters

mixed ...$args Data values

Return Value

float

static float MINIFS(mixed ...$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], ...)

Parameters

mixed ...$args Data range and criterias

Return Value

float

static float MODE(mixed ...$args)

MODE.

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

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

Parameters

mixed ...$args Data values

Return Value

float

static float NEGBINOMDIST(float $failures, float $successes, float $probability)

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.

Parameters

float $failures Number of Failures
float $successes Threshold number of Successes
float $probability Probability of success on each trial

Return Value

float

static float NORMDIST(float $value, float $mean, float $stdDev, bool $cumulative)

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.

Parameters

float $value
float $mean Mean Value
float $stdDev Standard Deviation
bool $cumulative

Return Value

float

static float NORMINV(float $probability, float $mean, float $stdDev)

NORMINV.

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

Parameters

float $probability
float $mean Mean Value
float $stdDev Standard Deviation

Return Value

float

static float NORMSDIST(float $value)

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.

Parameters

float $value

Return Value

float

static float NORMSINV(float $value)

NORMSINV.

Returns the inverse of the standard normal cumulative distribution

Parameters

float $value

Return Value

float

static float PERCENTILE(...$args)

PERCENTILE.

Returns the nth percentile of values in a range..

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

Parameters

...$args

Return Value

float

static float PERCENTRANK(float[] $valueSet, int $value, int $significance = 3)

PERCENTRANK.

Returns the rank of a value in a data set as a percentage of the data set.

Parameters

float[] $valueSet An array of, or a reference to, a list of numbers
int $value the number whose rank you want to find
int $significance the number of significant digits for the returned percentage value

Return Value

float

static int|string PERMUT(int $numObjs, int $numInSet)

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.

Parameters

int $numObjs Number of different objects
int $numInSet Number of objects in each permutation

Return Value

int|string Number of permutations

static float POISSON(float $value, float $mean, bool $cumulative)

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.

Parameters

float $value
float $mean Mean Value
bool $cumulative

Return Value

float

static float QUARTILE(...$args)

QUARTILE.

Returns the quartile of a data set.

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

Parameters

...$args

Return Value

float

static float RANK(int $value, float[] $valueSet, int $order = 0)

RANK.

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

Parameters

int $value the number whose rank you want to find
float[] $valueSet An array of, or a reference to, a list of numbers
int $order Order to sort the values in the value set

Return Value

float

static float|string RSQ(mixed[] $yValues, mixed[] $xValues)

RSQ.

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

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X

Return Value

float|string

static float|string SKEW(array ...$args)

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.

Parameters

array ...$args Data Series

Return Value

float|string

static float|string SLOPE(mixed[] $yValues, mixed[] $xValues)

SLOPE.

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

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X

Return Value

float|string

static float SMALL(...$args)

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)

Parameters

...$args

Return Value

float

static float STANDARDIZE(float $value, float $mean, float $stdDev)

STANDARDIZE.

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

Parameters

float $value Value to normalize
float $mean Mean Value
float $stdDev Standard Deviation

Return Value

float Standardized value

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

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

STDEVA.

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

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

STDEVP.

Calculates standard deviation based on the entire population

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

Parameters

mixed ...$args Data values

Return Value

float|string

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

STDEVPA.

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

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

Parameters

mixed ...$args Data values

Return Value

float|string

static float|string STEYX(mixed[] $yValues, mixed[] $xValues)

STEYX.

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

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X

Return Value

float|string

static float TDIST(float $value, float $degrees, float $tails)

TDIST.

Returns the probability of Student's T distribution.

Parameters

float $value Value for the function
float $degrees degrees of freedom
float $tails number of tails (1 or 2)

Return Value

float

static float TINV(float $probability, float $degrees)

TINV.

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

Parameters

float $probability Probability for the function
float $degrees degrees of freedom

Return Value

float

static array TREND(mixed[] $yValues, mixed[] $xValues = [], mixed[] $newValues = [], bool $const = true)

TREND.

Returns values along a linear Trend

Parameters

mixed[] $yValues Data Series Y
mixed[] $xValues Data Series X
mixed[] $newValues Values of X for which we want to find Y
bool $const a logical value specifying whether to force the intersect to equal 0

Return Value

array of float

static float|string TRIMMEAN(...$args)

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)

Parameters

...$args

Return Value

float|string

static float VARFunc(mixed ...$args)

VARFunc.

Estimates variance based on a sample.

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

Parameters

mixed ...$args Data values

Return Value

float

static float VARA(mixed ...$args)

VARA.

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

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

Parameters

mixed ...$args Data values

Return Value

float

static float VARP(mixed ...$args)

VARP.

Calculates variance based on the entire population

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

Parameters

mixed ...$args Data values

Return Value

float

static float VARPA(mixed ...$args)

VARPA.

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

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

Parameters

mixed ...$args Data values

Return Value

float

static float WEIBULL(float $value, float $alpha, float $beta, bool $cumulative)

WEIBULL.

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

Parameters

float $value
float $alpha Alpha Parameter
float $beta Beta Parameter
bool $cumulative

Return Value

float

static float|string ZTEST(float $dataSet, float $m0, float $sigma = null)

ZTEST.

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

Parameters

float $dataSet
float $m0 Alpha Parameter
float $sigma Beta Parameter

Return Value

float|string