Methods summary
private static
|
|
private static
0
|
#
_beta( p $p, q $q )
Beta function.
Parameters
Returns
0 if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow
Author
Jaco van Kooten
|
private static
0
|
#
_incompleteBeta( x $x, p $p, q $q )
Incomplete beta function
Parameters
Returns
0 if x<0, p<=0, q<=0 or p+q>2.55E305 and 1 if x>1 to avoid errors and over/underflow
Author
Jaco van Kooten
Paul Meagher
The computation is based on formulas from Numerical Recipes, Chapter 6.4 (W.H. Press et al, 1992).
|
private static
0
|
#
_logBeta( p $p, q $q )
The natural logarithm of the beta function.
The natural logarithm of the beta function.
Parameters
Returns
0 if p<=0, q<=0 or p+q>2.55E305 to avoid errors and over/underflow
Author
Jaco van Kooten
|
private static
|
#
_betaFraction( $x, $p, $q )
Evaluates of continued fraction part of incomplete beta function.
Based on an idea from Numerical Recipes (W.H. Press et al, 1992).
Evaluates of continued fraction part of incomplete beta function.
Based on an idea from Numerical Recipes (W.H. Press et al, 1992).
Author
Jaco van Kooten
|
private static
|
|
private static
|
|
private static
|
|
private static
|
|
private static
|
|
private static
|
|
public static
float
|
#
AVEDEV( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
AVERAGE( )
AVERAGE
Returns the average (arithmetic mean) of the arguments
Excel Function: AVERAGE(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
AVERAGEA( )
AVERAGEA
Returns the average of its arguments, including numbers, text, and logical values
Excel Function: AVERAGEA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
AVERAGEIF( mixed $aArgs, string $condition, mixed[] $averageArgs = array() )
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
- $aArgs
- $arg,... Data values
- $condition
- The criteria that defines which cells will be checked.
- $averageArgs
- Data values
Returns
float
Category
Mathematical and Trigonometric Functions
|
public static
float
|
#
BETADIST( float $value, float $alpha, float $beta, boolean $rMin = 0, $rMax = 1 )
BETADIST
Returns the beta distribution.
Parameters
- $value
- Value at which you want to evaluate the distribution
- $alpha
- Parameter to the distribution
- $beta
- Parameter to the distribution
- $rMin
- $cumulative
- $rMax
Returns
float
|
public static
float
|
#
BETAINV( float $probability, float $alpha, float $beta, float $rMin = 0, float $rMax = 1, boolean $cumulative,… )
BETAINV
Returns the inverse of the beta distribution.
Parameters
- $probability
- Probability at which you want to evaluate the distribution
- $alpha
- Parameter to the distribution
- $beta
- Parameter to the distribution
- $rMin
- Minimum value
- $rMax
- Maximum value
- $cumulative,…
Returns
float
|
public static
float
|
#
BINOMDIST( float $value, float $trials, float $probability, boolean $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
- $value
- Number of successes in trials
- $trials
- Number of trials
- $probability
- Probability of success on each trial
- $cumulative
Returns
float
Todo
Cumulative distribution function
|
public static
float
|
#
CHIDIST( float $value, float $degrees )
CHIDIST
Returns the one-tailed probability of the chi-squared distribution.
Parameters
- $value
- Value for the function
- $degrees
- degrees of freedom
Returns
float
|
public static
float
|
#
CHIINV( float $probability, float $degrees )
CHIINV
Returns the one-tailed probability of the chi-squared distribution.
Parameters
- $probability
- Probability for the function
- $degrees
- degrees of freedom
Returns
float
|
public static
float
|
#
CONFIDENCE( float $alpha, float $stdDev, float $size )
CONFIDENCE
Returns the confidence interval for a population mean
Parameters
- $alpha
- $stdDev
- Standard Deviation
- $size
Returns
float
|
public static
float
|
#
CORREL( array $yValues, array $xValues = null )
CORREL
Returns covariance, the average of the products of deviations for each data point pair.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
integer
|
#
COUNT( )
COUNT
Counts the number of cells that contain numbers within the list of arguments
Excel Function: COUNT(value1[,value2[, ...]])
Returns
integer
Category
Statistical Functions
|
public static
integer
|
#
COUNTA( )
COUNTA
Counts the number of cells that are not empty within the list of arguments
Excel Function: COUNTA(value1[,value2[, ...]])
Returns
integer
Category
Statistical Functions
|
public static
integer
|
#
COUNTBLANK( )
COUNTBLANK
Counts the number of empty cells within the list of arguments
Excel Function: COUNTBLANK(value1[,value2[, ...]])
Returns
integer
Category
Statistical Functions
|
public static
integer
|
#
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
- $aArgs
- $arg,... Data values
- $condition
- The criteria that defines which cells will be counted.
Returns
integer
Category
Statistical Functions
|
public static
float
|
#
COVAR( array $yValues, array $xValues )
COVAR
Returns covariance, the average of the products of deviations for each data point pair.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
integer
|
#
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 http://support.microsoft.com/kb/828117/ for details of the algorithm used
Parameters
- $trials
- number of Bernoulli trials
- $probability
- probability of a success on each trial
- $alpha
- criterion value
Returns
integer
Todo
Warning. This implementation differs from the algorithm detailed on the MS
web site in that $CumPGuessMinus1 = $CumPGuess - 1 rather than $CumPGuess - $PGuess
This eliminates a potential endless loop error, but may have an adverse affect on the
accuracy of the function (although all my tests have so far returned correct results).
|
public static
float
|
#
DEVSQ( )
DEVSQ
Returns the sum of squares of deviations of data points from their sample mean.
Excel Function: DEVSQ(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
EXPONDIST( float $value, float $lambda, boolean $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
- $value
- Value of the function
- $lambda
- The parameter value
- $cumulative
Returns
float
|
public static
float
|
#
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
Returns
float
|
public static
float
|
#
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
Returns
float
|
public static
float
|
#
FORECAST( float $xValue, array $yValues, array $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
- $xValue
- of X for which we want to find Y
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
float
|
#
GAMMADIST( float $value, float $a, float $b, boolean $cumulative )
GAMMADIST
Returns the gamma distribution.
Parameters
- $value
- Value at which you want to evaluate the distribution
- $a
- Parameter to the distribution
- $b
- Parameter to the distribution
- $cumulative
Returns
float
|
public static
float
|
#
GAMMAINV( float $probability, float $alpha, float $beta )
GAMMAINV
Returns the inverse of the beta distribution.
Parameters
- $probability
- Probability at which you want to evaluate the distribution
- $alpha
- Parameter to the distribution
- $beta
- Parameter to the distribution
Returns
float
|
public static
float
|
#
GAMMALN( float $value )
GAMMALN
Returns the natural logarithm of the gamma function.
Parameters
Returns
float
|
public static
float
|
#
GEOMEAN( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
array
|
#
GROWTH( array $yValues, array $xValues = array(), array $newValues = array(), boolean $const = True )
GROWTH
Returns values along a predicted emponential trend
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
- $newValues
- mixed Values of X for which we want to find Y
- $const
- logical value specifying whether to force the intersect to equal 0.
Returns
array of float
|
public static
float
|
#
HARMEAN( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
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
- $sampleSuccesses
- Number of successes in the sample
- $sampleNumber
- Size of the sample
- $populationSuccesses
- Number of successes in the population
- $populationNumber
- Population size
Returns
float
|
public static
float
|
#
INTERCEPT( array $yValues, array $xValues )
INTERCEPT
Calculates the point at which a line will intersect the y-axis by using existing x-values and y-values.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
float
|
#
KURT( )
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.
Returns
float
|
public static
float
|
#
LARGE( integer $entry,… )
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
- $entry,…
- Position (ordered from the largest) in the array or range of data to return
Returns
float
Category
Statistical Functions
|
public static
array
|
#
LINEST( array $yValues, array $xValues = NULL, boolean $const = TRUE, boolean $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
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
- $const
- logical value specifying whether to force the intersect to equal 0.
- $stats
- logical value specifying whether to return additional regression statistics.
Returns
array
|
public static
array
|
#
LOGEST( array $yValues, array $xValues = null, boolean $const = True, boolean $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
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
- $const
- logical value specifying whether to force the intersect to equal 0.
- $stats
- logical value specifying whether to return additional regression statistics.
Returns
array
|
public static
float
|
#
LOGINV( float $probability, float $mean, float $stdDev )
LOGINV
Returns the inverse of the normal cumulative distribution
Parameters
- $probability
- $mean
- $stdDev
Returns
float
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
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
Returns
float
|
public static
float
|
#
MAX( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
MAXA( )
MAXA
Returns the greatest value in a list of arguments, including numbers, text, and logical values
Excel Function: MAXA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
MAXIF( mixed $aArgs, string $condition, $sumArgs = array() )
MAXIF
Counts the maximum value within a range of cells that contain numbers within the list of arguments
Excel Function: MAXIF(value1[,value2[, ...]],condition)
Parameters
- $aArgs
- $arg,... Data values
- $condition
- The criteria that defines which cells will be checked.
- $sumArgs
Returns
float
Category
Mathematical and Trigonometric Functions
|
public static
float
|
#
MEDIAN( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
MIN( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
MINA( )
MINA
Returns the smallest value in a list of arguments, including numbers, text, and logical values
Excel Function: MINA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
MINIF( mixed $aArgs, string $condition, $sumArgs = array() )
MINIF
Returns the minimum value within a range of cells that contain numbers within the list of arguments
Excel Function: MINIF(value1[,value2[, ...]],condition)
Parameters
- $aArgs
- $arg,... Data values
- $condition
- The criteria that defines which cells will be checked.
- $sumArgs
Returns
float
Category
Mathematical and Trigonometric Functions
|
private static
|
|
public static
float
|
#
MODE( )
MODE
Returns the most frequently occurring, or repetitive, value in an array or range of data
Excel Function: MODE(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public 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
- $failures
- Number of Failures
- $successes
- Threshold number of Successes
- $probability
- Probability of success on each trial
Returns
float
|
public static
float
|
#
NORMDIST( float $value, float $mean, float $stdDev, boolean $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
- $value
- $mean
- Mean Value
- $stdDev
- Standard Deviation
- $cumulative
Returns
float
|
public 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
- $probability
- $value
- $mean
- Mean Value
- $stdDev
- Standard Deviation
Returns
float
|
public 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
Returns
float
|
public static
float
|
#
NORMSINV( float $value )
NORMSINV
Returns the inverse of the standard normal cumulative distribution
Parameters
Returns
float
|
public static
float
|
#
PERCENTILE( float $entry,… )
PERCENTILE
Returns the nth percentile of values in a range..
Excel Function: PERCENTILE(value1[,value2[, ...]],entry)
Parameters
- $entry,…
- Percentile value in the range 0..1, inclusive.
Returns
float
Category
Statistical Functions
|
public static
float
|
#
PERCENTRANK( array $valueSet, number $value, number $significance = 3 )
PERCENTRANK
Returns the rank of a value in a data set as a percentage of the data set.
Parameters
- $valueSet
- number An array of, or a reference to, a list of numbers.
- $value
- number whose rank you want to find.
- $significance
- number of significant digits for the returned percentage value.
Returns
float
|
public static
integer
|
#
PERMUT( integer $numObjs, integer $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
- $numObjs
- Number of different objects
- $numInSet
- Number of objects in each permutation
Returns
integer Number of permutations
|
public static
float
|
#
POISSON( float $value, float $mean, boolean $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
- $value
- $mean
- Mean Value
- $cumulative
Returns
float
|
public static
float
|
#
QUARTILE( integer $entry,… )
QUARTILE
Returns the quartile of a data set.
Excel Function: QUARTILE(value1[,value2[, ...]],entry)
Parameters
- $entry,…
- Quartile value in the range 1..3, inclusive.
Returns
float
Category
Statistical Functions
|
public static
float
|
#
RANK( number $value, array $valueSet, mixed $order = 0 )
RANK
Returns the rank of a number in a list of numbers.
Parameters
- $value
- number whose rank you want to find.
- $valueSet
- number An array of, or a reference to, a list of numbers.
- $order
- to sort the values in the value set
Returns
float
|
public static
float
|
#
RSQ( array $yValues, array $xValues )
RSQ
Returns the square of the Pearson product moment correlation coefficient through data points in known_y's and known_x's.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
float
|
#
SKEW( )
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.
Returns
float
|
public static
float
|
#
SLOPE( array $yValues, array $xValues )
SLOPE
Returns the slope of the linear regression line through data points in known_y's and known_x's.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
float
|
#
SMALL( integer $entry,… )
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
- $entry,…
- Position (ordered from the smallest) in the array or range of data to return
Returns
float
Category
Statistical Functions
|
public static
float
|
#
STANDARDIZE( float $value, float $mean, float $stdDev )
STANDARDIZE
Returns a normalized value from a distribution characterized by mean and standard_dev.
Parameters
- $value
- Value to normalize
- $mean
- Mean Value
- $stdDev
- Standard Deviation
Returns
float Standardized value
|
public static
float
|
#
STDEV( )
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[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
STDEVA( )
STDEVA
Estimates standard deviation based on a sample, including numbers, text, and logical values
Excel Function: STDEVA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
STDEVP( )
STDEVP
Calculates standard deviation based on the entire population
Excel Function: STDEVP(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
STDEVPA( )
STDEVPA
Calculates standard deviation based on the entire population, including numbers, text, and logical values
Excel Function: STDEVPA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
STEYX( array $yValues, array $xValues )
STEYX
Returns the standard error of the predicted y-value for each x in the regression.
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
Returns
float
|
public static
float
|
#
TDIST( float $value, float $degrees, float $tails )
TDIST
Returns the probability of Student's T distribution.
Parameters
- $value
- Value for the function
- $degrees
- degrees of freedom
- $tails
- number of tails (1 or 2)
Returns
float
|
public static
float
|
#
TINV( float $probability, float $degrees )
TINV
Returns the one-tailed probability of the chi-squared distribution.
Parameters
- $probability
- Probability for the function
- $degrees
- degrees of freedom
Returns
float
|
public static
array
|
#
TREND( array $yValues, array $xValues = array(), array $newValues = array(), boolean $const = True )
TREND
Returns values along a linear trend
Parameters
- $yValues
- mixed Data Series Y
- $xValues
- mixed Data Series X
- $newValues
- mixed Values of X for which we want to find Y
- $const
- logical value specifying whether to force the intersect to equal 0.
Returns
array of float
|
public static
float
|
#
TRIMMEAN( float $discard,… )
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
- $discard,…
- Percentage to discard
Returns
float
Category
Statistical Functions
|
public static
float
|
#
VARFunc( )
VARFunc
Estimates variance based on a sample.
Excel Function: VAR(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
VARA( )
VARA
Estimates variance based on a sample, including numbers, text, and logical values
Excel Function: VARA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
VARP( )
VARP
Calculates variance based on the entire population
Excel Function: VARP(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
VARPA( )
VARPA
Calculates variance based on the entire population, including numbers, text, and logical values
Excel Function: VARPA(value1[,value2[, ...]])
Returns
float
Category
Statistical Functions
|
public static
float
|
#
WEIBULL( float $value, float $alpha, float $beta, boolean $cumulative )
WEIBULL
Returns the Weibull distribution. Use this distribution in reliability
analysis, such as calculating a device's mean time to failure.
Parameters
- $value
- $alpha
- Alpha Parameter
- $beta
- Beta Parameter
- $cumulative
Returns
float
|
public static
float
|
#
ZTEST( float $dataSet, float $m0, float $sigma = NULL, boolean $cumulative,… )
ZTEST
Returns the Weibull distribution. Use this distribution in reliability
analysis, such as calculating a device's mean time to failure.
Parameters
- $dataSet
- $m0
- Alpha Parameter
- $sigma
- Beta Parameter
- $cumulative,…
Returns
float
|