Two percent-rank controls retain decimal places rather than significant digits

FN-PERCENTRANK-001: Two percent-rank controls retain decimal places rather than significant digits

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

In the retained catalogue capture, PERCENTRANK({37.15,46,54},38.59,6) returns 0.081355, and PERCENTRANK.INC({0,1,2,3,4,5,6,7,8,9,10,11,12},1) returns 0.083 with omitted significance. These results retain six and three decimal places respectively, and differ from keeping that many significant digits in the untruncated ranks. The scope is these two build 20527 calls.

Documentation: The opened PERCENTRANK and PERCENTRANK.INC pages describe significance as the number of significant digits; omission defaults to three. Source documentation · Source documentation

Basis: Two formula-literal rows in the landed statistics capture. Raw and reopened binary64 results agree, and the saved numeric text parses to those values. The first interpolated mathematical rank is about 0.0813559322; the second is 1/12. Six and three significant digits would retain 0.0813559 and 0.0833, respectively. This harvest made no new Excel calls.

Open: These two controls do not establish all duplicate-selection, significance-limit or cross-build behaviour. PERCENTRANK.EXC shares the current helper but is not a measured precision discriminator in this note.