HYPGEOM.DIST

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,TRUE)' with the result 0.4654. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The cumulative value is the sum of those two probability masses (x = 0 and x = 1), 2255/4845 = 0.4654282765737874097, which rounds to exactly the published 0.4654. Asserting the cumulative form alongside the mass form is the point of the modern name: HYPGEOM.DIST's whole reason for existing over HYPGEOMDIST is the cumulative argument. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,FALSE)' with the result 0.3633. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The mass at x = 1 is 1760/4845 = 0.36326109391124871001, which rounds to exactly the published 0.3633, and is the same value the legacy HYPGEOMDIST page publishes for the identical data. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Not published; derived from the definition. With a sample of 4 drawn from a population of 20 containing 8 successes, x ranges over 0..4, so the cumulative probability at x = 4 is the total mass and equals 1. In exact rational arithmetic the five masses are 495/4845, 1760/4845, 1848/4845, 672/4845 and 70/4845, which sum to 4845/4845 = 1 exactly. A good test of a cumulative implementation: summation errors and off-by-one loop bounds both show up here as a value near but not equal to 1. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOM.DIST returns the #NUM! error value." 5 successes cannot occur in a sample of 4. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_sample <= 0 or number_sample > number_population, HYPGEOM.DIST returns the #NUM! error value." Sampling 25 items without replacement from a population of 20 is impossible. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If population_s <= 0 or population_s > number_population, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_pop <= 0, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If any argument is nonnumeric, HYPGEOM.DIST returns the #VALUE! error value." Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,TRUE)' with the result 0.4654. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The cumulative value is the sum of those two probability masses (x = 0 and x = 1), 2255/4845 = 0.4654282765737874097, which rounds to exactly the published 0.4654. Asserting the cumulative form alongside the mass form is the point of the modern name: HYPGEOM.DIST's whole reason for existing over HYPGEOMDIST is the cumulative argument. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,FALSE)' with the result 0.3633. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The mass at x = 1 is 1760/4845 = 0.36326109391124871001, which rounds to exactly the published 0.3633, and is the same value the legacy HYPGEOMDIST page publishes for the identical data. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Not published; derived from the definition. With a sample of 4 drawn from a population of 20 containing 8 successes, x ranges over 0..4, so the cumulative probability at x = 4 is the total mass and equals 1. In exact rational arithmetic the five masses are 495/4845, 1760/4845, 1848/4845, 672/4845 and 70/4845, which sum to 4845/4845 = 1 exactly. A good test of a cumulative implementation: summation errors and off-by-one loop bounds both show up here as a value near but not equal to 1. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOM.DIST returns the #NUM! error value." 5 successes cannot occur in a sample of 4. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_sample <= 0 or number_sample > number_population, HYPGEOM.DIST returns the #NUM! error value." Sampling 25 items without replacement from a population of 20 is impossible. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If population_s <= 0 or population_s > number_population, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_pop <= 0, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If any argument is nonnumeric, HYPGEOM.DIST returns the #VALUE! error value." Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,TRUE)' with the result 0.4654. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The cumulative value is the sum of those two probability masses (x = 0 and x = 1), 2255/4845 = 0.4654282765737874097, which rounds to exactly the published 0.4654. Asserting the cumulative form alongside the mass form is the point of the modern name: HYPGEOM.DIST's whole reason for existing over HYPGEOMDIST is the cumulative argument. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Microsoft publishes '=HYPGEOM.DIST(A2,A3,A4,A5,FALSE)' with the result 0.3633. Derived independently from the equation the page states -- P(X = x) = C(M,x)*C(N-M,n-x)/C(N,n) with x = sample_s, n = number_sample, M = population_s, N = number_pop -- evaluated in exact rational arithmetic from binomial coefficients rather than from any statistics library's hypergeometric routine: C(8,1)*C(12,3)/C(20,4) = 8*220/4845 = 1760/4845 = 0.36326109391124871001, and C(8,0)*C(12,4)/C(20,4) = 495/4845 = 0.10216718266253869969. The mass at x = 1 is 1760/4845 = 0.36326109391124871001, which rounds to exactly the published 0.3633, and is the same value the legacy HYPGEOMDIST page publishes for the identical data. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Not published; derived from the definition. With a sample of 4 drawn from a population of 20 containing 8 successes, x ranges over 0..4, so the cumulative probability at x = 4 is the total mass and equals 1. In exact rational arithmetic the five masses are 495/4845, 1760/4845, 1848/4845, 672/4845 and 70/4845, which sum to 4845/4845 = 1 exactly. A good test of a cumulative implementation: summation errors and off-by-one loop bounds both show up here as a value near but not equal to 1. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If sample_s < 0 or sample_s is greater than the lesser of number_sample or population_s, HYPGEOM.DIST returns the #NUM! error value." 5 successes cannot occur in a sample of 4. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_sample <= 0 or number_sample > number_population, HYPGEOM.DIST returns the #NUM! error value." Sampling 25 items without replacement from a population of 20 is impossible. EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If population_s <= 0 or population_s > number_population, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If number_pop <= 0, HYPGEOM.DIST returns the #NUM! error value." EXECUTED RESULT: all four LibreOffice builds (24.2.0.3, 24.8.7.2, 25.2.0.3, 25.8.7.3) return #VALUE! here instead of the documented #NUM! -- the same systemic #VALUE!-substitution pattern already recorded across this corpus, an error-code difference rather than a computation one. Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.

Excel documents: "If any argument is nonnumeric, HYPGEOM.DIST returns the #VALUE! error value." Set up from Microsoft's own worked-example table: A2 = 1 (number of successes in the sample), A3 = 4 (sample size), A4 = 8 (number of successes in the population) and A5 = 20 (population size), pasted at A1 as the page describes. Column F is untouched because this harness writes the formula under test into cell F1.