# Calculate Binomial Probability of number 75 out of total 100 rows and each row containing 3 random numbers

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)


where:

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

-

If the numbers are random, the probability of $75$ appearing in any one row is $0.03$. That is your $p$. This counts on the fact that numbers are not repeated within a row.