Microsoft Office Tutorials and References
In Depth Information
VARPA
Figure 11.54
The entry for Alaska is
None and is ignored by
the VARP function, but
picked up by the
VARPA function.
VARPA
VARPA calculates variance based on the entire population. In addition to numbers, text, and
logical values such as TRUE and FALSE are included in the calculation.
=VARPA(value1,value2,...)
Refer to Figure 11.54 for a comparison of VARP and VARPA .
Is the cell reference(s), range name, text representations of numbers,
array, or logical values that makes up the data set. Up to 30 arguments
can be specified.
VALUE N
WEIBULL
WEIBULL returns the Weibull distribution.
=WEIBULL(x,alpha,beta,cumulative)
The WEIBULL function is used in reliability testing, such as calculating an equipment’s average
time to failure, shown in Figure 11.55.
Is the value at which to evaluate the function.
X
Is a parameter to the distribution.
ALPHA
Is a parameter to the distribution.
BETA
Is a logical value that indicates which form of the exponential
function to provide. If TRUE, then WEIBULL returns the cumulative
distribution function. If FALSE, then WEIBULL returns the probability
density function.
CUMULATIVE
Search JabSto ::




Custom Search