584
RANDGAMMA RANDGAMMA(alpha, beta) returns a random
number from the gamma distribution with
parameters alpha and beta.
RANDINTEGER RANDINTEGER(lower, upper) returns a random
integer from a discrete uniform distribution
with the lower boundary = lower and the upper
boundary = upper.
RANDLOG RANDLOG(mean, stdev) returns a random
number from the log normal distribution with
m 5 mean and s5stdev.
RANDNORM RANDNORM(mean, stdev) returns a random
number from the normal distribution with
m 5 mean and s5stdev.
RANDPOISSON RANDPOISSON(lambda) returns a random
number from the Poisson distribution where
l5lambda.
RANDT RANDT(df) returns a random number from the
t distribution with degrees of freedom df.
RANDUNI RANDUNI(lower, upper) returns a random number
from the uniform distribution where the lower
boundary = lower and the upper boundary =
upper.
Statistical Analysis
Function Name Description
ACF ACF(range, lag) calculates the autocorrelation
function for values in range for lag = lag. Note:
Range values must lie within one column.
Bartlett Bartlett(range, range2,.. .) calculates the p value
for the Bartlett test assuming that the data are
arranged in multiple columns.
Bartlett2 Bartlett2(range, range2) calculates the p value
for the Bartlett test assuming one column of data
values and one column of category values.
DW DW(range) calculates the Durbin-Watson
statistics for data in a single column.
FTest2 FTest2(range, range2) calculates the p value for
the F test assuming one column of data values
and one column of category values.
Levene Levene(range, range2,.. .) calculates the p value
for Levene test assuming that the data are
arranged in multiple columns.
Levene2 Levene2(range, range2) calculates the p value
for the Levene test assuming one column of data
values and one column of category values.
