MonteGrid | Distributions | Chi-squared

Chi-squared distribution

MC_CHISQ defines a Chi-squared assumption in MonteGrid. It is in the Statistical group of Define Assumption.

Syntax

=MC_CHISQ(df, MC_STATIC(value, name, group))

ArgumentDefine Assumption fieldValues
dfDegrees of freedomGreater than 0.

Note: MC_STATIC holds the value the cell shows outside a simulation, the assumption's name, and its correlation group ("" for none).

Example

Define Assumption suggests these parameters for a cell that holds 100. The static value is the median.

=MC_CHISQ(100,MC_STATIC(99.3341,"",""))

P10 P50 P90
Chi-squared — Degrees of freedom 100. Range shown: 0 to 149.45.
P10P50P90Mean
82.35899.334118.5100

Crystal Ball and @RISK

ProductEquivalentIn MonteGrid
Crystal Ball None in Oracle's distribution list. —
@RISKRiskChiSqConverted in place. Same order. See Lumivero @RISK on a Mac.

Statistical

All distributions