Overview

Packages

  • JAMA
  • None
  • PHP
  • PHPExcel
    • CachedObjectStorage
    • Calculation
    • Cell
    • Chart
      • Renderer
    • Reader
      • Excel2007
      • Excel5
    • RichText
    • Settings
    • Shared
      • Escher
      • OLE
      • Trend
      • ZipArchive
    • Style
    • Worksheet
      • Drawing
    • Writer
      • 2007
      • CSV
      • Excel2007
      • Excel5
      • HTML
      • PDF

Classes

  • PHPExcel_CalcEngine_CyclicReferenceStack
  • PHPExcel_CalcEngine_Logger
  • PHPExcel_Calculation
  • PHPExcel_Calculation_Database
  • PHPExcel_Calculation_DateTime
  • PHPExcel_Calculation_Engineering
  • PHPExcel_Calculation_ExceptionHandler
  • PHPExcel_Calculation_Financial
  • PHPExcel_Calculation_FormulaParser
  • PHPExcel_Calculation_FormulaToken
  • PHPExcel_Calculation_Function
  • PHPExcel_Calculation_Functions
  • PHPExcel_Calculation_Logical
  • PHPExcel_Calculation_LookupRef
  • PHPExcel_Calculation_MathTrig
  • PHPExcel_Calculation_Statistical
  • PHPExcel_Calculation_TextData
  • PHPExcel_Calculation_Token_Stack

Exceptions

  • PHPExcel_Calculation_Exception

Functions

  • acosh
  • asinh
  • atanh
  • mb_str_replace
  • Overview
  • Package
  • Class
  • Tree
  • Deprecated
  • Todo
  • Download

Class PHPExcel_Calculation_Statistical

PHPExcel_Calculation_Statistical

Package: PHPExcel\Calculation
Category: PHPExcel
Copyright: Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
License: LGPL
Located at controlador/include/phpexcel/PHPExcel/Calculation/Statistical.php
Methods summary
private static
# _checkTrendArrays( & $array1, & $array2 )
private static 0
# _beta( p $p, q $q )

Beta function.

Beta function.

Parameters

$p
p>0
$q
q>0

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

Incomplete beta function

Parameters

$x
0<=x<=1
$p
p>0
$q
q>0

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

$p
p>0
$q
q>0

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
# _logGamma( $x )
private static
# _incompleteGamma( $a, $x )
private static
# _gamma( $data )
private static
# _inverse_ncdf( $p )
private static
# _inverse_ncdf2( $prob )
private static
# _inverse_ncdf3( $p )
public static float
# AVEDEV( )

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

AVERAGE

Returns the average (arithmetic mean) of the arguments

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

Returns

float

Category

Statistical Functions
public static float
# AVERAGEA( )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

$value

Returns

float
public static float
# FISHERINV( float $value )

FISHERINV

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

$value

Returns

float
public static float
# FORECAST( float $xValue, array $yValues, array $xValues )

FORECAST

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

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

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

GAMMALN

Returns the natural logarithm of the gamma function.

Parameters

$value

Returns

float
public static float
# GEOMEAN( )

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

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

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

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

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

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

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

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

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

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

LOGNORMDIST

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

Parameters

$value
$mean
$stdDev

Returns

float
public static float
# MAX( )

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

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

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

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

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

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

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
# _modeCalc( $data )
public static float
# MODE( )

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

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

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

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

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

$value

Returns

float
public static float
# NORMSINV( float $value )

NORMSINV

NORMSINV

Returns the inverse of the standard normal cumulative distribution

Parameters

$value

Returns

float
public static float
# PERCENTILE( float $entry,… )

PERCENTILE

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

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

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

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

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

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

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

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

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

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

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

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

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

STDEVP

Calculates standard deviation based on the entire population

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

Returns

float

Category

Statistical Functions
public static float
# STDEVPA( )

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

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

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

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

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

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

VARFunc

Estimates variance based on a sample.

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

Returns

float

Category

Statistical Functions
public static float
# VARA( )

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

VARP

Calculates variance based on the entire population

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

Returns

float

Category

Statistical Functions
public static float
# VARPA( )

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

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

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
Properties summary
private static float $_logBetaCache_p
# 0.0
private static float $_logBetaCache_q
# 0.0
private static float $_logBetaCache_result
# 0.0
private static float $_logGammaCache_result
# 0.0
private static float $_logGammaCache_x
# 0.0
Autene API documentation generated by ApiGen