8.5.11.53. xprob

xprob(x_range, prob_range, lower_limit, upper_limit=None)

PROB(x_range, prob_range, lower_limit, [upper_limit])

Excel-like behavior:

• Pairwise: ignore pairs where either x or p is text/boolean.

• Errors:

  • length mismatch (before filtering) -> #N/A (via _parse_yxp)

  • no valid numeric pairs -> #N/A

  • any probability < 0 or > 1 -> #NUM!

  • sum(probabilities) != 1 (±tol) -> #NUM!

• If upper_limit omitted -> P(X == lower_limit).

• If upper_limit provided -> P(lower_limit <= X <= upper_limit).

• If lower_limit > upper_limit -> 0.