QRS Toolbox for Excel

QRS.ES.​PEARSON


Premium function (only USD 29)   Server-side function

Returns expected shortfall for the Pearson distribution.

Syntax

QRS.ES.​PEARSON(​level, [mean], [variance], [skewness], [kurtosis], [tail])

levelnumber
The confidence level. Must be strictly between 0 and 1.
meannumberoptional
The mean of the distribution. Defaults to 0.
variancenumberoptional
The variance of the distribution. Defaults to 1.
skewnessnumberoptional
The skewness of the distribution. Defaults to 0.
kurtosisnumberoptional
The kurtosis of the distribution. Must be greater than the squared skewness plus 1. Defaults to 3.
tailnumberoptional
The tail of the distribution containing the expected shortfall. Must be either -1 for left tail or 1 for right tail. Defaults to -1.

Remarks

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

Examples

Get from AppSource


Get it from Microsoft AppSource

Get from Excel


  1. Click Insert > Get Add-ins
  2. Search for QRS Toolbox
  3. Click Add