Contact

R.PWEIBULL Function (Gnumeric)

Statistical Intermediate Gnumeric

Calculate Weibull probabilities with Gnumeric R.PWEIBULL. Verify survival and log tails, shape/scale units, zero support boundaries and interval probabilities.

Verification status: 22 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

Quick answer: =R.PWEIBULL(1,2,3) gives 0.105160683186 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.PWEIBULL returns

R.PWEIBULL returns the lower Weibull CDF by default. For positive x it is 1−EXP(−(x/scale)^shape). Upper-tail mode returns the survival probability EXP(−(x/scale)^shape), and log_p requests the log of the selected tail. Versioned function help.

Syntax and arguments

=R.PWEIBULL(x,shape,scale[,lower_tail[,log_p]])

x, shape and scale are required; shape and scale must be positive. lower_tail defaults to TRUE and log_p to FALSE. Match x and scale units; the shape parameter is dimensionless.

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.PWEIBULL(1,2,3) 0.105160683186
=R.PWEIBULL(2,2,3) 0.35881961157
=R.PWEIBULL(3,2,3) 0.632120558829
=R.PWEIBULL(2,2,3,FALSE()) 0.64118038843
=R.PWEIBULL(2,2,3,TRUE(),TRUE()) -1.024935491512
=R.PWEIBULL(2,2,3,FALSE(),TRUE()) -0.444444444444
=R.PWEIBULL(1,1,2) 0.393469340287
=R.PWEIBULL(0,2,3) 0

Practical worksheet

With shape 2 and scale 3, the probability of a value at most 2 is approximately 0.358819611570. The probability of exceeding 2 is approximately 0.641180388430. Their sum is one, as checked below.

At x equal to scale, the CDF is 1−EXP(−1), approximately 0.632120558829, regardless of positive shape. Scale is therefore not generally the median. For an interval from 1 to 2, subtract those two lower CDF values.

Advanced interpretation and checks

The upper log-tail has the particularly simple expression −(x/scale)^shape. At x=2, shape 2 and scale 3, it is exactly −4/9 mathematically. The native value is approximately −0.444444444444.

Use the requested tail directly when a probability is very small rather than subtracting a rounded value from one. With shape 1, the CDF reduces to the exponential model with the same scale. These identities check the interpretation of the parameters, not a guarantee of all extreme-tail precision.

The saved advanced-check result for =R.PWEIBULL(2,2,3)+R.PWEIBULL(2,2,3,FALSE()) was 1.

Boundaries and troubleshooting

At zero or negative x, the lower probability is zero and the upper probability is one. Their log forms are respectively negative infinity, displayed as #NUM!, and zero. This helper correctly selects the tail at the support boundary; do not transfer a boundary rule from another R.* function without checking it.

Nonpositive shape or scale gives #NUM!, including when x is at a boundary. Nonnumeric text gives #VALUE!, while empty F5 is treated as zero. Wrong arity gives #N/A. The table’s errors distinguish parameter validation from a requested logarithm of a zero probability.

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

Formula Gnumeric 1.12.57 result
=R.PWEIBULL(-1,2,3) 0
=R.PWEIBULL(-1,2,3,FALSE()) 1
=R.PWEIBULL(0,2,3,FALSE()) 1
=R.PWEIBULL(0,2,3,TRUE(),TRUE()) #NUM!
=R.PWEIBULL(0,2,3,FALSE(),TRUE()) 0
=R.PWEIBULL(1,0,3) #NUM!
=R.PWEIBULL(1,-1,3) #NUM!
=R.PWEIBULL(1,2,0) #NUM!
=R.PWEIBULL(1,2,-1) #NUM!
=R.PWEIBULL("abc",2,3) #VALUE!
=R.PWEIBULL(F5,2,3) 0
=R.PWEIBULL(1,2) #N/A
=R.PWEIBULL(1,2,3,0,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.