Syntax

QRS.VAR.​NORMAL(​level, [mean], [stdev], [tail])

levelnumber

The confidence level. Must be strictly between 0 and 1.

meannumberoptional

The mean of the distribution. Defaults to 0.

stdevnumberoptional

The standard deviation of the distribution. Defaults to 1.

tailnumberoptional

The tail of the distribution containing the value-at-risk. Must be either -1 for left tail or 1 for right tail. Defaults to -1.

Options

Remarks

• Blank cells are read as zeros and dates are read as numbers due to Excel limitations.

Examples

• QRS.VAR.NORMAL(95%) = -1.64485.
• QRS.VAR.NORMAL(99%, 10, 2) = 5.34730.