R.DWEIBULL Function (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
- Current worksheet callback
- Tested-version worksheet callback
- Current dweibull calculation
- Tested-version dweibull 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.