Recorded hypergeometric calls admit zero counts and counts above the support

FN-HYPGEOM.DIST-001: Recorded hypergeometric calls admit zero counts and counts above the support

Documentation differs from behaviour · measured · recorded 2026-11-06

Four retained build 20430 controls return numeric values where the opened documentation specifies #NUM!: HYPGEOM.DIST(0,0,0,5,0) and its cumulative form both return 1; HYPGEOM.DIST(5,4,2,5,0) returns 0 and its cumulative form returns 1. These observations cover the listed inputs, not every out-of-support call.

Documentation: The opened HYPGEOM.DIST remarks specify #NUM! for a sample size or population success count at or below zero, and for sample successes above min(sample size,population successes). Source documentation

Call and input route	Inputs	Excel	Correct value	Recorded in
`HYPGEOM.DIST(0,0,0,5,0)` cell-value2	sample_s: `0` `0x0000000000000000` number_sample: `0` `0x0000000000000000` population_s: `0` `0x0000000000000000` number_pop: `5` `0x4014000000000000` cumulative: `0` `0x0000000000000000`	`1` `0x3ff0000000000000`	—	Excel 16.0 build 20430, Windows 64-bit (NT 10.00), Workbook Compatibility Version 2; CPU not recorded. Captured 29 September 2026.
`HYPGEOM.DIST(0,0,0,5,1)` cell-value2	sample_s: `0` `0x0000000000000000` number_sample: `0` `0x0000000000000000` population_s: `0` `0x0000000000000000` number_pop: `5` `0x4014000000000000` cumulative: `1` `0x3ff0000000000000`	`1` `0x3ff0000000000000`	—	Excel 16.0 build 20430, Windows 64-bit (NT 10.00), Workbook Compatibility Version 2; CPU not recorded. Captured 29 September 2026.
`HYPGEOM.DIST(5,4,2,5,0)` cell-value2	sample_s: `5` `0x4014000000000000` number_sample: `4` `0x4010000000000000` population_s: `2` `0x4000000000000000` number_pop: `5` `0x4014000000000000` cumulative: `0` `0x0000000000000000`	`0` `0x0000000000000000`	—	Excel 16.0 build 20430, Windows 64-bit (NT 10.00), Workbook Compatibility Version 2; CPU not recorded. Captured 29 September 2026.
`HYPGEOM.DIST(5,4,2,5,1)` cell-value2	sample_s: `5` `0x4014000000000000` number_sample: `4` `0x4010000000000000` population_s: `2` `0x4000000000000000` number_pop: `5` `0x4014000000000000` cumulative: `1` `0x3ff0000000000000`	`1` `0x3ff0000000000000`	—	Excel 16.0 build 20430, Windows 64-bit (NT 10.00), Workbook Compatibility Version 2; CPU not recorded. Captured 29 September 2026.

Basis: Read directly from four rows of the landed W111 domain capture. Its provenance names Excel build 20430, Windows 64-bit, Compatibility Version 2, exact-double bulk cell input and no cache. This harvest made no new Excel calls and did not compare builds.

Open: Whether every out-of-support and zero-count combination follows the same rule in other builds.

Evidence and capture sources

CalcFunc-Evidence · runs/w111-distribution-domain-20260929/answers-hypgeom.dist.json.gz 4287ba192d2e3a7fd54671ea1cee1c34cb2e84e2 · hypgeom.dist-domain-01118-integer-support, hypgeom.dist-domain-01119-integer-support, hypgeom.dist-domain-01404-integer-support, hypgeom.dist-domain-01405-integer-support Recorded answers and capture provenance.
DnaCalc · crates/calc-func/src/ported/discrete_dist.rs da3ecc4fb19a3a5529708c311d0e8f05688ac165 · hypergeom_mass and hypergeom_dist_kernel Current support checks, degenerate masses and cumulative endpoint shortcut.
CalcFunc-Evidence · runs/w111-distribution-domain-20260929/answers-hypgeom.dist.json.gz 4287ba192d2e3a7fd54671ea1cee1c34cb2e84e2 · hypgeom.dist-domain-01118-integer-support Original capture provenance records cell_value2_bulk input plumbing and no cache use.
CalcFunc-Evidence · runs/w111-distribution-domain-20260929/answers-hypgeom.dist.json.gz 4287ba192d2e3a7fd54671ea1cee1c34cb2e84e2 · hypgeom.dist-domain-01119-integer-support Original capture provenance records cell_value2_bulk input plumbing and no cache use.
CalcFunc-Evidence · runs/w111-distribution-domain-20260929/answers-hypgeom.dist.json.gz 4287ba192d2e3a7fd54671ea1cee1c34cb2e84e2 · hypgeom.dist-domain-01404-integer-support Original capture provenance records cell_value2_bulk input plumbing and no cache use.
CalcFunc-Evidence · runs/w111-distribution-domain-20260929/answers-hypgeom.dist.json.gz 4287ba192d2e3a7fd54671ea1cee1c34cb2e84e2 · hypgeom.dist-domain-01405-integer-support Original capture provenance records cell_value2_bulk input plumbing and no cache use.

Machine-readable note records