Im trying to calculate the chance or probability of number 75 appearing. I have total 100 rows in microsoft excel and have frequency of number 75. Each row contains 3 cells and each cell contains a random number between 1-100. For example typical table cells:
75 23 01 91 64 67 05 12 75
Im trying to use the formula:
P(k out of N) = (N! / (k!(N-k)!)) * (pk)(qN-k)
N = 100 Total rows k = 15 Number of times number 75 appears in these 100 rows p = ? q = 1 - q
Im stuck on calculating p.
Notes: numbers never repeat in the same cell. meaning there will never be a case like:
75 75 22