header

Empirical Probability

The empirical probability is given by:

n(E)/n(S)
= # of favorable outcomes / total # of outcomes
= observed frequency / number of trials
= D5/D$11 (in cell E5)

You must use an absolute reference in the denominator because the location of the cell containing the number of trials is fixed (D11).