Excel Function : HYPGEOMDIST
Category
Compatibility
Description
Returns the hypergeometric distribution
Microsoft Excel Reference Page
https://support.office.com/en-us/article/HYPGEOMDIST-function-23e37961-2871-4195-9629-d0b2c108a12e
Syntax and Description of the HYPGEOMDIST Excel Function
, and it is working fine for me. Here is my code: Sub test() Dim NumberOfSuccesses As Integer NumberOfSuccesses = Range("I5").Value Dim SampleSpace As Integer SampleSpace = Range("I6").Value Dim NumberOfSuccessesInSample As Integer NumberOfSuccessesInSample = Range("I7").Value Dim p As Double p = Range("I8").Value Dim q As Double q = Range("I9").Value Worksheets("Sheet1").Activate Sheets("Sheet1").Range("A1").Select Dim x1 As Integer x1 = Range("I10").Value Dim x2 As Integer x2 = Range("I11").Value
About HYPGEOMDIST Excel Function
The HYPGEOMDIST function returns the hypergeometric distribution. For example, if you have a sample data set of 100 elements, and you want to know the probability of having 60 or more successes (a success is defined as an element that meets a specified criterion), you would use the HYPGEOMDIST function.