SIM function reference
58 probability distributions, 13 time-series processes, and 108 correlation, fitting, Six Sigma, and result functions (294 total including percentile and What-If forms). Click any chip to inspect its syntax and variants.
Categories: Distributions (58) Input properties & correlation (17) Outputs (4) Run statistics (29) Theoretical statistics (16) Distribution fitting (4) Time series (17) Six Sigma (19) What-If (5) Simulation control (10)
Distributions (58 families)
Continuous, discrete, and empirical random inputs. 24 families also have percentile forms (ALT / ALTD) and 56 have multi-way What-If forms (MULTI).
Common & continuous (22)
A beta distribution on [0, 1]. In Excel the cell shows the mean, alpha1/(alpha1+alpha2), or the SIM.STATIC value.
SIM.BETAMULTI(alpha1, alpha2, [options…])Varies across multi-way What-If scenarios.
A beta distribution scaled to [min, max]. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.BETAGENERALALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, arg4type, arg4value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.BETAGENERALALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, arg4type, arg4value, [options…])Define by descending percentiles P(X ≥ v).
SIM.BETAGENERALMULTI(alpha1, alpha2, min, max, [options…])Varies across multi-way What-If scenarios.
A beta distribution on [min, max] with the given most likely value and mean. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.BETASUBJMULTI(min, mlikely, mean, max, [options…])Varies across multi-way What-If scenarios.
A Cauchy distribution with location gamma and scale beta. Its mean does not exist, so in Excel the cell shows the median without a SIM.STATIC value or a two-sided truncation.
SIM.CAUCHYALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.CAUCHYALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.CAUCHYMULTI(gamma, beta, [options…])Varies across multi-way What-If scenarios.
A chi-square distribution with nu degrees of freedom. In Excel the cell shows the mean, nu, or the SIM.STATIC value.
SIM.CHISQMULTI(nu, [options…])Varies across multi-way What-If scenarios.
An Erlang distribution with integer shape m and scale beta. In Excel the cell shows the mean, m beta, or the SIM.STATIC value.
SIM.ERLANGMULTI(m, beta, [options…])Varies across multi-way What-If scenarios.
An exponential distribution with the mean beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.EXPONALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.EXPONALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.EXPONMULTI(beta, [options…])Varies across multi-way What-If scenarios.
A largest-extreme-value (Gumbel) distribution with location alpha and scale beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.EXTVALUEALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.EXTVALUEALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.EXTVALUEMULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
A gamma distribution with shape alpha and scale beta. In Excel the cell shows the mean, alpha beta, or the SIM.STATIC value.
SIM.GAMMAALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.GAMMAALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.GAMMAMULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
An inverse Gaussian distribution with mean mu and shape lambda. In Excel the cell shows the mean, mu, or the SIM.STATIC value.
SIM.INVGAUSSALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.INVGAUSSALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.INVGAUSSMULTI(mu, lambda, [options…])Varies across multi-way What-If scenarios.
A Laplace (double exponential) distribution with location mu and standard deviation sigma. In Excel the cell shows the mean, mu, or the SIM.STATIC value.
SIM.LAPLACEALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.LAPLACEALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.LAPLACEMULTI(mu, sigma, [options…])Varies across multi-way What-If scenarios.
A logistic distribution with location alpha and scale beta. In Excel the cell shows the mean, alpha, or the SIM.STATIC value.
SIM.LOGISTICALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.LOGISTICALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.LOGISTICMULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
A log-logistic distribution with location gamma, scale beta and shape alpha. In Excel the cell shows the mean (the median for alpha <= 1), or the SIM.STATIC value.
SIM.LOGLOGISTICALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.LOGLOGISTICALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.LOGLOGISTICMULTI(gamma, beta, alpha, [options…])Varies across multi-way What-If scenarios.
A lognormal distribution with the given mean and sd of the variable. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.LOGNORMALALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.LOGNORMALALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.LOGNORMALMULTI(mean, sd, [options…])Varies across multi-way What-If scenarios.
A normal distribution. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.NORMALALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.NORMALALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.NORMALMULTI(mean, sd, [options…])Varies across multi-way What-If scenarios.
A Pareto distribution with shape theta and scale a. In Excel the cell shows the mean (the median for theta <= 1), or the SIM.STATIC value.
SIM.PARETOALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.PARETOALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.PARETOMULTI(theta, a, [options…])Varies across multi-way What-If scenarios.
A PERT distribution. In Excel the cell shows the mean, (min + 4 mode + max)/6, or the SIM.STATIC value.
SIM.PERTALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.PERTALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.PERTMULTI(min, mode, max, [options…])Varies across multi-way What-If scenarios.
A Rayleigh distribution with the mode beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.RAYLEIGHALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.RAYLEIGHALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.RAYLEIGHMULTI(beta, [options…])Varies across multi-way What-If scenarios.
A Student t distribution with nu degrees of freedom. In Excel the cell shows the mean, 0 (the median 0 for nu = 1), or the SIM.STATIC value.
SIM.STUDENTMULTI(nu, [options…])Varies across multi-way What-If scenarios.
A triangular distribution. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.TRIANGULARALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.TRIANGULARALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.TRIANGULARMULTI(min, mode, max, [options…])Varies across multi-way What-If scenarios.
A uniform distribution. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.UNIFORMALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.UNIFORMALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.UNIFORMMULTI(min, max, [options…])Varies across multi-way What-If scenarios.
A Weibull distribution with shape alpha and scale beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.WEIBULLALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.WEIBULLALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.WEIBULLMULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
Discrete & count (10)
1 with probability p, else 0. In Excel the cell shows the mean, p, or the SIM.STATIC value.
SIM.BERNOULLIMULTI(p, [options…])Varies across multi-way What-If scenarios.
A binomial distribution. In Excel the cell shows the mean, n p, or the SIM.STATIC value.
SIM.BINOMIALMULTI(n, p, [options…])Varies across multi-way What-If scenarios.
The sum of a frequency number of severity samples, each less the deductible and at most the limit. In Excel the cell shows the frequency times the severity after the deductible and the limit, or the SIM.STATIC value.
A discrete distribution on the given values. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.DISCRETEMULTI(values, probs, [options…])Varies across multi-way What-If scenarios.
Each cell of the range is equally likely. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.DUNIFORMMULTI(values, [options…])Varies across multi-way What-If scenarios.
The number of failures before the first success. In Excel the cell shows the mean, (1-p)/p, or the SIM.STATIC value.
SIM.GEOMETMULTI(p, [options…])Varies across multi-way What-If scenarios.
The number of successes in n draws without replacement from M items with D successes. In Excel the cell shows the mean, nD/M, or the SIM.STATIC value.
SIM.HYPERGEOMULTI(n, D, M, [options…])Varies across multi-way What-If scenarios.
A uniform distribution on the integers from min to max. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.INTUNIFORMMULTI(min, max, [options…])Varies across multi-way What-If scenarios.
The number of failures before the s-th success. In Excel the cell shows the mean, s(1-p)/p, or the SIM.STATIC value.
SIM.NEGBINMULTI(s, p, [options…])Varies across multi-way What-If scenarios.
A Poisson distribution with the mean lambda. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.POISSONMULTI(lambda, [options…])Varies across multi-way What-If scenarios.
Empirical, Johnson & specialized (26)
A Burr type XII (Singh-Maddala) distribution with location gamma, scale beta and shapes alpha1 and alpha2. In Excel the cell shows the mean (the median for alpha1 alpha2 <= 1), or the SIM.STATIC value.
SIM.BURR12MULTI(gamma, beta, alpha1, alpha2, [options…])Varies across multi-way What-If scenarios.
A distribution with a piecewise linear CDF through (min, 0), the points (x, p), and (max, 1). In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.CUMULMULTI(min, max, values, probs, [options…])Varies across multi-way What-If scenarios.
A distribution with a piecewise linear CDF through (min, 0), the points (x, 1 - p), and (max, 1), where p = P(X > x). In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.CUMULDMULTI(min, max, values, probs, [options…])Varies across multi-way What-If scenarios.
A Dagum distribution with location gamma, scale beta and shapes a1 and a2. In Excel the cell shows the mean (the median for a1 <= 1), or the SIM.STATIC value.
SIM.DAGUMMULTI(gamma, beta, a1, a2, [options…])Varies across multi-way What-If scenarios.
A double triangular distribution: two triangles that meet at the most likely value, with the probability p below it. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.DOUBLETRIANGMULTI(min, mlikely, max, p, [options…])Varies across multi-way What-If scenarios.
An error function distribution: a normal distribution with mean 0 and variance 1/(2 h^2). In Excel the cell shows the mean, 0, or the SIM.STATIC value.
SIM.ERFMULTI(h, [options…])Varies across multi-way What-If scenarios.
A smallest-extreme-value distribution with location alpha and scale beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.EXTVALUEMINALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.EXTVALUEMINALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.EXTVALUEMINMULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
An F distribution with nu1 and nu2 degrees of freedom. In Excel the cell shows the mean (the median for nu2 <= 2), or the SIM.STATIC value.
SIM.FMULTI(nu1, nu2, [options…])Varies across multi-way What-If scenarios.
A fatigue life (Birnbaum-Saunders) distribution with location gamma, scale beta and shape alpha. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.FATIGUELIFEALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.FATIGUELIFEALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.FATIGUELIFEMULTI(gamma, beta, alpha, [options…])Varies across multi-way What-If scenarios.
A Frechet distribution with location gamma, scale beta and shape alpha. In Excel the cell shows the mean (the median for alpha <= 1), or the SIM.STATIC value.
SIM.FRECHETALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.FRECHETALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.FRECHETMULTI(gamma, beta, alpha, [options…])Varies across multi-way What-If scenarios.
A distribution with a piecewise linear density through (min, 0), the points (x, weight), and (max, 0). In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.GENERALMULTI(min, max, values, weights, [options…])Varies across multi-way What-If scenarios.
A histogram distribution: [min, max] in N equal classes with the given weights. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.HISTOGRMMULTI(min, max, weights, [options…])Varies across multi-way What-If scenarios.
A hyperbolic secant distribution with location gamma and scale beta (the standard deviation). In Excel the cell shows the mean, gamma, or the SIM.STATIC value.
SIM.HYPSECANTALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.HYPSECANTALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.HYPSECANTMULTI(gamma, beta, [options…])Varies across multi-way What-If scenarios.
The Johnson distribution (normal, lognormal, SU or SB) with the given mean, standard deviation, skewness and kurtosis. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.JOHNSONMOMENTSMULTI(mean, stdDev, skewness, kurtosis, [options…])Varies across multi-way What-If scenarios.
A Johnson SB (bounded) distribution with shapes alpha1 and alpha2 on [a, b]. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.JOHNSONSBMULTI(alpha1, alpha2, a, b, [options…])Varies across multi-way What-If scenarios.
A Johnson SU (unbounded) distribution with shapes alpha1 and alpha2, location gamma and scale beta. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.JOHNSONSUMULTI(alpha1, alpha2, gamma, beta, [options…])Varies across multi-way What-If scenarios.
A Kumaraswamy distribution with shapes alpha1 and alpha2 on [min, max]. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.KUMARASWAMYMULTI(alpha1, alpha2, min, max, [options…])Varies across multi-way What-If scenarios.
A Levy distribution with location a and scale c. Its mean does not exist, so in Excel the cell shows the median without a SIM.STATIC value or an upper truncation bound.
SIM.LEVYALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.LEVYALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.LEVYMULTI(a, c, [options…])Varies across multi-way What-If scenarios.
A lognormal distribution: e to the power of a normal sample with mean mu and standard deviation sigma. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.LOGNORM2MULTI(mu, sigma, [options…])Varies across multi-way What-If scenarios.
A Pareto distribution of the second kind with scale b and shape q. In Excel the cell shows the mean (the median for q <= 1), or the SIM.STATIC value.
SIM.PARETO2ALT(arg1type, arg1value, arg2type, arg2value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.PARETO2ALTD(arg1type, arg1value, arg2type, arg2value, [options…])Define by descending percentiles P(X ≥ v).
SIM.PARETO2MULTI(b, q, [options…])Varies across multi-way What-If scenarios.
A Pearson type V (inverse gamma) distribution with shape alpha and scale beta. In Excel the cell shows the mean (the median for alpha <= 1), or the SIM.STATIC value.
SIM.PEARSON5ALT(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by cumulative percentiles P(X ≤ v).
SIM.PEARSON5ALTD(arg1type, arg1value, arg2type, arg2value, arg3type, arg3value, [options…])Define by descending percentiles P(X ≥ v).
SIM.PEARSON5MULTI(alpha, beta, [options…])Varies across multi-way What-If scenarios.
A Pearson type VI distribution with shapes alpha1 and alpha2 and scale beta. In Excel the cell shows the mean (the median for alpha2 <= 1), or the SIM.STATIC value.
SIM.PEARSON6MULTI(alpha1, alpha2, beta, [options…])Varies across multi-way What-If scenarios.
A reciprocal (log-uniform) distribution on [min, max]. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.RECIPROCALMULTI(min, max, [options…])Varies across multi-way What-If scenarios.
Samples a data set of equally likely values: 1 in order, 2 at random with replacement, 3 at random without replacement. In Excel the cell shows the average of the values, or the SIM.STATIC value.
SIM.RESAMPLEMULTI(sampMethod, values, [options…])Varies across multi-way What-If scenarios.
dist1 below the splice point and dist2 at or above it, weighted so that the density is continuous at the splice point. In Excel the cell shows the mean, or the SIM.STATIC value.
A triangular distribution given by two percentiles and the most likely value. In Excel the cell shows the mean, or the SIM.STATIC value.
SIM.TRIGENMULTI(bottom, mlikely, top, bottomperc, topperc, [options…])Varies across multi-way What-If scenarios.
Input properties & correlation (17 functions)
Optional modifiers passed inside distribution functions to link inputs with correlation matrices or copulas, truncate tails, set static values, or name variables.
The category of the distribution in which it is an argument. Returns a marker text.
Marks the distribution in which it is an argument for sample collection: with Probistica_CollectSamples = Collect, only the marked inputs keep their samples. Returns a marker text.
Puts the distribution in which it is an argument in a copula. Returns 0.
Correlates the distribution in which it is an argument. Returns 0.
Makes the distribution in which it is an argument a dependent input of the input with SIM.INDEPC and the same ID, with a rank correlation. Returns a marker text.
Links the distribution in which it is an argument to a fit of the Fit Manager. When the data change, a run fits again at its start and rewrites the formula. Returns a marker text.
Makes the distribution in which it is an argument the independent input of the inputs with SIM.DEPC and the same ID. Returns a marker text.
Marks the values of the distribution or of SIM.OUTPUT in which it is an argument as dates. Returns a marker text.
Locks the distribution in which it is an argument: it is not sampled, and every trial uses one value. Returns a marker text.
Names the distribution in which it is an argument. Returns a marker text.
Gives the distribution in which it is an argument its own seed: the input has the same draws in every run and simulation. Returns a marker text.
Adds a number to every sample of the distribution in which it is an argument. Returns a marker text.
The value that the cell of the distribution shows instead of its mean. The samples do not change. Returns a marker text.
Limits the distribution in which it is an argument to [lo, hi], before SIM.SHIFT. A discrete family keeps the values from lo to hi, both included. Leave one bound empty for a one-sided limit.
Limits the distribution in which it is an argument to [lo, hi], after SIM.SHIFT.
Limits the distribution in which it is an argument to its percentiles plo to phi.
The units of the distribution or of SIM.OUTPUT in which it is an argument. Returns a marker text.
Outputs (4 functions)
Mark forecast cells and attach convergence, discrete, or Six Sigma output properties.
The convergence test of the output of SIM.OUTPUT; an omitted argument keeps the workbook setting. Returns a marker text.
Marks the output of SIM.OUTPUT as discrete (TRUE) or continuous (FALSE) for its statistics. Returns a marker text.
Marks the cell as a simulation output and returns 0, or the value that you give. SIM.OUTPUT(label, range, position) puts it in an output range. The properties are SIM.SIXSIGMA, SIM.ISDISCRETE, SIM.CONVERGENCE, SIM.UNITS, and SIM.ISDATE.
The Six Sigma settings of an output: a property of SIM.OUTPUT or of a Six Sigma function. Returns a marker text.
Run statistics (29 base (34 with D / DA))
Read simulated mean, standard deviation, percentiles, target probabilities, and sensitivity rankings back into worksheet cells.
A bound of the confidence interval of the mean (the Monte Carlo formula) of the latest run. #N/A before a run, and for LHS unless Probistica_LhsPrecision is MonteCarlo.
The coefficient of variation (sd / mean) of the latest run. #N/A before a run.
The Pearson (1) or Spearman rank (2) correlation of the paired trials of two outputs or inputs of the latest run. #N/A before a run.
The value of one trial of the latest run, from trial 1. #N/A before a run.
SIM.DATADA(ref, [sim], [applyFilters], [removeErrors], [sort], [addLabels])Spills all trial values as a dynamic array.
The fraction of the paired trials of the latest run where both conditions hold, such as A1 <= 2 and A2 > -0.3. #N/A before a run.
The fraction of the trials of the latest run where every SIM.JPVARDEF condition holds (up to 10 variables). #N/A before a run.
One variable of SIM.JOINTPROBMULTIDIM: a reference with one or two conditions and an optional filter. Returns a marker text.
The kurtosis of the latest run, where a normal distribution has 3 (Excel KURT + 3). #N/A before a run.
The largest value of the latest run. #N/A before a run.
The mean of the latest run. #N/A before a run.
The mean absolute deviation from the mean of the latest run. #N/A before a run.
The smallest value of the latest run. #N/A before a run.
The mode of the latest run: the most frequent value of discrete data, else the half-sample mode. #N/A before a run.
The value at the cumulative probability p (PERCENTILE.INC) of the latest run. #N/A before a run.
SIM.PERCENTILED(ref, q, [sim], [filter])Descending percentile: value exceeded with probability p.
The same as SIM.PERCENTILE.
The same as SIM.PERCENTILED.
The maximum minus the minimum of the latest run. #N/A before a run.
The square root of SIM.SEMIVARIANCE. #N/A before a run.
The lower (or upper) semivariance of the latest run; the two add up to the variance. #N/A before a run.
The ranked sensitivity of an output of the latest run: the input name or a value. #N/A before a run.
SIM.SENSITIVITYDA(ref, [sim], analysisType, [extraInfo], [addLabels])Spills sensitivity table as a dynamic array.
The change in output statistic sensitivity of an output of the latest run. #N/A before a run.
SIM.SENSITIVITYSTATCHANGEDA(ref, [sim], numBins, whichStatistic, percentile, [addLabels])Spills sensitivity stat-change table as a dynamic array.
The skewness (Excel SKEW) of the latest run. #N/A before a run.
The sample standard deviation (n - 1) of the latest run. #N/A before a run.
The standard error of the mean, sd/sqrt(n), of the latest run. #N/A before a run, and for LHS unless Probistica_LhsPrecision is MonteCarlo.
The fraction of the trials <= x in the latest run. #N/A before a run.
SIM.TARGETD(ref, x, [sim], [filter])Upper-tail probability P(X ≥ target).
The number of trials with a value in the latest run. #N/A before a run.
The sample variance (n - 1) of the latest run. #N/A before a run.
The same as SIM.TARGET.
The same as SIM.TARGETD.
Theoretical statistics (16 base (18 with D))
Exact analytical moments, densities, and quantiles computed directly from a distribution formula.
The kurtosis of a distribution, where a normal distribution has 3, without a simulation.
The largest value of a distribution, without a simulation. #NUM! when it is unbounded.
The mean of a distribution with its properties, without a simulation.
The smallest value of a distribution, without a simulation. #NUM! when it is unbounded.
The most likely value of a distribution (the smallest one of a tie), without a simulation.
The value at the cumulative probability p of a distribution, without a simulation.
SIM.THEOPERCENTILED(ref, q)Theoretical descending percentile P(X ≥ x) = p.
The same as SIM.THEOPERCENTILE.
The same as SIM.THEOPERCENTILED.
The maximum minus the minimum of a distribution, without a simulation.
The skewness of a distribution, without a simulation. #DIV/0! when it does not exist.
The standard deviation of a distribution, without a simulation.
The probability of a value <= x, without a simulation.
SIM.THEOTARGETD(ref, x)Theoretical upper-tail probability P(X ≥ target).
The variance of a distribution, without a simulation.
The same as SIM.THEOTARGET.
The same as SIM.THEOTARGETD.
The density at x of a continuous distribution, or the probability of x of a discrete one, without a simulation.
Distribution fitting (4 base (6 with DA))
Fit probability distributions to historical worksheet data and return parameters and goodness-of-fit statistics.
The selected fit of a fit source as text: its SIM.* formula, or the family and its parameters.
Fits the candidate families to the data and samples the selected fit. The fit runs again when the data change and at the start of each run. The cell shows the static value of the fit.
A parameter of the selected fit of a fit source, in full precision. A shift of the fit is the last parameter.
SIM.FITPARAMETERDA(fitSource, [labels])Spills fitted parameters as a dynamic array.
A statistic of the selected fit of a fit source: AIC, BIC, ChiSq, KS, AD, RMSError, or LogLik.
SIM.FITSTATISTICDA(fitSource, [labels])Spills goodness-of-fit statistics as a dynamic array.
Time series (13 processes, 4 modifiers)
Correlated multi-period processes (AR, ARMA, GBM, GARCH, mean-reverting) plus transform, integration, and seasonality modifiers.
Processes (13)
An asymmetric power GARCH process.
A first-order autoregressive process.
A second-order autoregressive process.
A first-order autoregressive conditional heteroskedasticity process.
A first-order autoregressive moving average process.
A Brownian motion with mean reversion.
A Brownian motion with mean reversion and jump diffusion.
An exponential GARCH process.
A generalized ARCH process.
The log returns of a geometric Brownian motion; add SIM.TSTRANSFORM(1,0) and SIM.TSINTEGRATE(1,ln start) for the prices.
The log returns of a geometric Brownian motion with jump diffusion.
A first-order moving average process.
A second-order moving average process.
Time-series modifiers (4)
Integrates a time series once or twice; C1 is the value at time 0, C2 the value at time -1. Returns a marker text.
Seasonality of a time series (0 none, 1 or 2 seasonal integration, 3 additive). Returns a marker text.
Takes the start-up values of a time series from data (0 none, 1 first value, 2 last value, 3 the value at the start index). Returns a marker text.
The function of a time series (0 none, 1 exponentiate, 2 square), then minus the shift. Returns a marker text.
Six Sigma (19 functions)
Process capability indices (Cp, Cpk, Cpm), defect rates (DPM, PPM, PNC), and sigma levels.
The process capability Cp = (USL - LSL)/(6 sd) of the latest run. Needs LSL and USL. #N/A before a run.
Cpk = min(USL - mean, mean - LSL)/(3 sd) of the latest run. Needs LSL and USL. #N/A before a run.
The one-sided Cpk (mean - LSL)/(3 sd) of the latest run. Needs LSL. #N/A before a run.
The one-sided Cpk (USL - mean)/(3 sd) of the latest run. Needs USL. #N/A before a run.
The Taguchi index (USL - LSL)/(6 sqrt(sd^2 + (mean - target)^2)) of the latest run. Needs LSL, USL, and target.
The defective parts per million of the latest run: the trials below LSL or above USL, per million. No shift.
The process center k = |(LSL + USL)/2 - mean| / ((USL - LSL)/2) of the latest run. Needs LSL and USL.
mean - n sd of the latest run, with n the number of standard deviations of SIM.SIXSIGMA.
The fraction of the trials below LSL + shift*sd or above USL - shift*sd. Needs LSL and USL.
The fraction of the trials below LSL + shift*sd. Needs LSL.
The fraction of the trials above USL - shift*sd. Needs USL.
The defects below LSL + shift*sd per million trials. Needs LSL.
The defects above USL - shift*sd per million trials. Needs USL.
The process sigma level -NORM.S.INV(PNC/2) + shift; it assumes a normal output centered between the limits. #NUM! without a defect.
mean + n sd of the latest run, with n the number of standard deviations of SIM.SIXSIGMA.
The yield 1 - SIM.PNC of the latest run: the fraction of the trials without a defect. Needs LSL and USL.
The standard deviations from LSL to the mean, (mean - LSL)/sd, of the latest run. Needs LSL.
The smaller of SIM.ZLOWER and SIM.ZUPPER of the latest run. Needs LSL and USL.
The standard deviations from the mean to USL, (USL - mean)/sd, of the latest run. Needs USL.
What-If (5 functions)
Define systematic parameter sweeps and multi-way scenario inputs (in addition to the 56 MULTI distribution forms).
As SIM.VARY, with "Uniform" as the default distribution.
In Excel the cell shows the base value; in a run it is a distribution on the range, and What-If varies it. A missing range type or distribution takes the What-If settings.
As SIM.VARY, also an input of a multi-way What-If; "Uniform" is the default distribution.
As SIM.VARYTABLE, also an input of a multi-way What-If.
What-If gives the input each value of the table; the cell shows the base value, also in a run.
Simulation control (10 base (12 with DA))
Multi-simulation tables, automatic stopping rules, embedded charts, correlation repair, and run metadata.
The convergence level of an output in the latest run: TRUE when it converged, else a number from 0 to 99. #N/A before a run, and for LHS unless Probistica_LhsPrecision is MonteCarlo.
The corrected (valid) correlation matrix of the matrix, as an array; with weights, the weighted method.
SIM.CORRECTCORRMATDA(matrix, [weights])Spills the corrected correlation matrix as a dynamic array.
The trial number (from 1) in a run; 0 in Excel.
The simulation number (from 1) in a run; 0 in Excel.
The correlation of the data in two ranges: type 1 Pearson, 2 Spearman rank, over the rows where both hold a number.
Makes the cell one input of the sensitivity analysis: the inputs that feed it leave the analysis of the outputs that they reach. Returns the value of the formula, or the SIM.STATIC value under a static option.
After each completed run, Probistica draws an Excel chart of the results in locationCellRange. The cell shows the graph type.
The value of the current simulation from a list. In Excel the cell shows the value of simulation 1.
A fact of the latest run: 1 date and time, 2 run time (s), 3 simulations, 4 trials, 5 seed, 6 random number generator, 7 TRUE when every simulation used the same seed, 8 sampling method. #N/A before a run.
SIM.SIMULATIONINFODA([info], [addLabels])Spills all simulation info fields as a dynamic array.
Stops a simulation after the first trial in which the condition is TRUE. Gives TRUE when the condition is TRUE, else FALSE; a number is not TRUE.