R.DGUMBEL Function (Gnumeric)

• Introduced: Introduced in Gnumeric 1.12.25 release notes.
• Supported in: Gnumeric 1.12.62; no retirement is established.
• Scope: Desktop Gnumeric with its Statistical Functions From R plugin. English comma-separated formulas are shown.
• Checked: October 14, 2026. Tables and the named advanced check use 1.12.57 ssconvert. Current 1.12.62 source was inspected; that release was not executed.

R.DGUMBEL uses the maximum-type Gumbel density: with z=(x−location)/scale, density is EXP(−z−EXP(−z))/scale. Its optional mode returns the natural log density. Location is the mode, not the mean or median. Versioned function help.

=R.DGUMBEL(x,location,scale[,give_log])

x, location and scale are required. Scale must be positive. Optional give_log defaults to FALSE. x and location share units, and scale is expressed in those units; the distribution permits negative observations.

Brackets mark optional arguments; do not type them. Current worksheet implementation.

These self-contained formulas were recalculated natively. Ordinary-domain results were checked against independent mathematics; source guards explain the boundary cases. Results are rounded to twelve decimal places, or thirteen significant digits for small nonzero values. This is presentation precision, not a universal accuracy guarantee.

For location 0 and scale 1, the density at x=0 is EXP(−1), approximately 0.367879441171. At x=1 it is approximately 0.254646380044; at x=−1 it is approximately 0.179374078734, showing the asymmetric shape.

For location 2 and scale 3, the density at the mode is EXP(−1)/3, approximately 0.122626480390. The executed standardization check below multiplies this by 3 and subtracts the standard density at zero.

Log density is −z−EXP(−z)−LN(scale). For x=1000, location 0 and scale 1, the ordinary density underflows to zero in the tested engine, while the log density remains −1000.

At x=−100, the ordinary density also underflows, while the log result is approximately −2.688117141816E43. The two tails have different decay behavior. A returned ordinary zero at an extreme finite observation need not mean the mathematical density is exactly zero.

The saved advanced-check result for =R.DGUMBEL(2,2,3)*3-R.DGUMBEL(0,0,1) was 0.

Zero or negative scale gives #NUM!. Negative x itself is valid. Numeric text is parsed, nonnumeric text gives #VALUE!, and empty F5 is evaluated as x=0. Incorrect arity gives #N/A.

The log form is useful for the tested extreme densities, but that does not guarantee that every tail-related function avoids underflow: a separate Gumbel cumulative helper can lose a tiny intermediate even in its log-tail mode. Distinguish a density, a cumulative probability and their logarithms when interpreting the result.

F5 is genuinely empty, rather than a cell containing an empty string.

• Current worksheet callback
• Tested-version worksheet callback
• Current dgumbel calculation
• Tested-version dgumbel calculation
• Nonfinite worksheet-value handling
• Statistical Functions From R plugin declaration

The relevant complete worksheet callback and main calculation helper are unchanged between the inspected versions. That does not establish later-version numerical execution. Both stale and uncached SUM controls recalculated correctly. Native XML preserves the R.* identities. The secondary ODF export keeps these calls in the ORG.GNUMERIC namespace; it does not establish execution in another product. GUI entry, other locales and other spreadsheet products were not tested.

EXP, LN, R.DNORM.