Contact

R.DWEIBULL Function (Gnumeric)

Statistical Intermediate Gnumeric

Calculate Weibull density with Gnumeric R.DWEIBULL. Distinguish shape and scale, reconcile zero-boundary cases and inspect a finite log-density underflow failure.

Verification status: 24 reference, boundary and advanced-check formulas were recalculated with Gnumeric 1.12.57 ssconvert. Saved identities, the blank input and numerical results were independently checked. Gnumeric 1.12.62 was source-checked only. How formula examples are checked

Extreme log-density limitation: R.DWEIBULL(1E-200,3,1,TRUE()) returned #NUM! in 1.12.57, although the mathematical log density is finite, about −919.935424908950. An intermediate ordinary power underflows before its logarithm is taken.

Quick answer: =R.DWEIBULL(1,2,3) gives 0.198853181514 in Gnumeric 1.12.57.

Availability and version history

  • Introduced: First release not established; present in the retained 1.12.57 source.
  • 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.

What R.DWEIBULL returns

R.DWEIBULL gives the Weibull density, or its natural logarithm. For x>0, shape k>0 and scale λ>0, density is (k/λ)(x/λ)^(k−1)EXP(−(x/λ)^k). The density describes height, not probability mass at an individual value. Versioned function help.

Syntax and arguments

=R.DWEIBULL(x,shape,scale[,give_log])

x, shape and scale are required. Both shape and scale must be positive. Optional give_log defaults to FALSE. Scale has the same units as x and is not an inverse-rate argument.

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

Reproducible examples

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.

Formula Gnumeric 1.12.57 result
=R.DWEIBULL(1,2,3) 0.198853181514
=R.DWEIBULL(2,2,3) 0.284969061524
=R.DWEIBULL(3,2,3) 0.245252960781
=R.DWEIBULL(1,1,2) 0.303265329856
=R.DWEIBULL(1,.5,2) 0.174326107638
=R.DWEIBULL(1,2,3,TRUE()) -1.615188507887
=R.DWEIBULL(0,1,2) 0.5
=R.DWEIBULL(0,2,3) 0

Practical worksheet

With shape 2 and scale 3, the density at x=2 is approximately 0.284969061524. At x=3 it is approximately 0.245252960781. For a worksheet curve, put positive x values in A2:A20 and use =R.DWEIBULL(A2,2,3).

Shape 1 is the exponential distribution with the same scale. The saved comparison below checks x=2 and scale 3 against R.DEXP and returns zero. Changing shape affects the curve, while changing scale stretches its x-axis.

Advanced interpretation and checks

At x=0, the density limit is infinite for shape<1, 1/scale for shape=1, and zero for shape>1. The tested rows show 0.5 for shape 1 and scale 2, zero for shape 2, and #NUM! when the limit is infinite.

For positive x, an independent log-density expression is LN(k/λ)+(k−1)*LN(x/λ)−(x/λ)^k. It explains why the extreme log-density in the warning is finite even though the implementation’s power intermediate becomes zero. That expression is a mathematical reference, not a blanket guarantee of every alternative floating-point evaluation.

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

Boundaries and troubleshooting

Negative x returns density zero; its log form becomes #NUM!. Nonpositive shape or scale gives #NUM!. A mathematically zero density or infinite density can therefore produce the same displayed error when logarithms or nonfinite limits are involved; inspect the input and requested mode.

Numeric text follows scalar conversion, while nonnumeric text gives #VALUE!. Empty F5 becomes zero. Wrong arity gives #N/A. The helper’s own comment notes the problematic zero intermediate; it is byte-identical between inspected 1.12.57 and 1.12.62, but only the former was executed.

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

Formula Gnumeric 1.12.57 result
=R.DWEIBULL(-1,2,3) 0
=R.DWEIBULL(-1,2,3,TRUE()) #NUM!
=R.DWEIBULL(0,.5,2) #NUM!
=R.DWEIBULL(0,.5,2,TRUE()) #NUM!
=R.DWEIBULL(0,2,3,TRUE()) #NUM!
=R.DWEIBULL(1,0,3) #NUM!
=R.DWEIBULL(1,-1,3) #NUM!
=R.DWEIBULL(1,2,0) #NUM!
=R.DWEIBULL(1,2,-1) #NUM!
=R.DWEIBULL(1E-200,3,1) 0
=R.DWEIBULL(1E-200,3,1,TRUE()) #NUM!
=R.DWEIBULL("abc",2,3) #VALUE!
=R.DWEIBULL(F5,2,3) 0
=R.DWEIBULL(1,2) #N/A
=R.DWEIBULL(1,2,3,0,1) #N/A

Official evidence and checking scope

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.