QRS Toolbox for Excel

QRS.RAND.​GAMMA


Free function   Client-side function

Returns random numbers from the gamma distribution.

Syntax

QRS.RAND.​GAMMA(​[rows], [cols], [shape], [rate])

rowsnumberoptional
The number of rows. Defaults to 1.
colsnumberoptional
The number of columns. Defaults to 1.
shapenumberoptional
The shape parameter (alpha) of the distribution. Must be greater than 0. Defaults to 1.
ratenumberoptional
The rate parameter (beta) of the distribution. Must be greater than 0. 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