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.

All function names start with SIM. in Excel. Where a signature ends with [options…], you can pass up to 6 input property functions such as SIM.TRUNCATE, SIM.NAME, or SIM.CORRMAT. A small dot on a chip marks extra ALT / ALTD, MULTI, or DA forms inside.

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)

Discrete & count (10)

Empirical, Johnson & specialized (26)

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.

Outputs (4 functions)

Mark forecast cells and attach convergence, discrete, or Six Sigma output properties.

Run statistics (29 base (34 with D / DA))

Read simulated mean, standard deviation, percentiles, target probabilities, and sensitivity rankings back into worksheet cells.

Theoretical statistics (16 base (18 with D))

Exact analytical moments, densities, and quantiles computed directly from a distribution formula.

Distribution fitting (4 base (6 with DA))

Fit probability distributions to historical worksheet data and return parameters and goodness-of-fit statistics.

Time series (13 processes, 4 modifiers)

Correlated multi-period processes (AR, ARMA, GBM, GARCH, mean-reverting) plus transform, integration, and seasonality modifiers.

Processes (13)

Time-series modifiers (4)

Six Sigma (19 functions)

Process capability indices (Cp, Cpk, Cpm), defect rates (DPM, PPM, PNC), and sigma levels.

What-If (5 functions)

Define systematic parameter sweeps and multi-way scenario inputs (in addition to the 56 MULTI distribution forms).

Simulation control (10 base (12 with DA))

Multi-simulation tables, automatic stopping rules, embedded charts, correlation repair, and run metadata.