Given this libreoffice command:(adsbygoogle = window.adsbygoogle || []).push({});

HYPGEOM.DIST(X; NSample; Successes; NPopulation; Cumulative)

>X is the number of results achieved in the random sample.

>NSample is the size of the random sample.

>Successes is the number of possible results in the total population.

>NPopulation is the size of the total population.

>Cumulative : 0 or False calculates the probability density function. Other values or True calculates the cumulative distribution function.

Consider: Two players have 10 cards each, face down. Player one flips a card over and gets a 6. What's the probability of player two flipping a card greater than six.

Is this the right way to use the command:

=HYPGEOM.DIST(1,10,4,52,0)

It gives ~35.8%. Just wondering if I was interpreting the question and the command right.

Edit: I assumed suits are irrelevant and repetition is allowed.

**Physics Forums - The Fusion of Science and Community**

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# I Hypergeometric Distribution Calculation in Libreoffice

Have something to add?

Draft saved
Draft deleted

Loading...

Similar Threads - Hypergeometric Distribution Calculation | Date |
---|---|

A Complex parameters of 1F1 resulting in real values | Jun 27, 2017 |

I Simplifying integral of Gauss' hypergeometric function | Sep 6, 2016 |

Orthogonal properties of confluent hypergeometric functions | Sep 15, 2015 |

Integral could lead to Hypergeometric function | Nov 8, 2013 |

Hypergeometric distribution | Apr 1, 2007 |

**Physics Forums - The Fusion of Science and Community**