Financial functions – Juniper Systems Allegro CX Manual User Manual
Page 157
Allegro CX Owner’s Manual 157
Tdist(x, degOfFreedom, type)
Returns the Student’s t-distribution.
Tinv(probability, degOfFreedom) Returns the inverse of the Student’s
t-distribution.
Trimmean(reference, percentage)
Returns the mean of the interior portion of a set of data values.
Var(number, number, ...)
Estimates the variance based on a sample.
VarA(number, number, ...)
Estimates variance based on a sample (TRUE is 1, FALSE and texts
are 0).
VarP(number, number, ...)
Calculates variance of the entire population.
VarpA(number, number, ...)
Calculates variance based on an entire population (TRUE is 1, FALSE
and texts are 0).
Weibull(x, alfa, beta, cumulative)
Returns the Weibull distribution.
Ztest(reference, x, standardDeviation)
Returns a value of a z-test.
Financial Functions
Ddb(cost, salvage, life, period, factor)
Returns the depreciation of an asset for a specifi ed period using the
double-declining balance method (you can specify another method).
Cost is the initial cost of the asset. Salvage is the value at the end
of the depreciation. Life is the number of periods over which the
asset is being depreciated. Period is the period for which you want
to calculate the depreciation. Period must use the same units as life.
Factor is the rate at which the balance declines. If factor is omitted, it
is assumed to be 2. All the arguments must be positive numbers.
Example: Ddb(30000, 500, 3650, 10) equals 16.357.