A lab sensor records an average of 1.6 events per hour during a steady test. You want to know how often an entire hour might pass without an event under that model.
Put the expected count and the interval together
Enter 1.6 in B2 as the expected event count for 60 minutes. In C2, enter =POISSON.DIST(0,B2,FALSE) and display it as a percentage. The 0 asks about a quiet interval, and FALSE asks for the probability of that exact count. Expect about 20.19%. For zero events, =EXP(-B2) provides an independent check.

Example hourly model. The mean and the requested count refer to the same interval.
Recalculate when the interval gets shorter
For a 30-minute interval at the same rate, use 0.8 as the mean. The modeled chance of zero events rises to about 44.93%. Label the rows “60 minutes” and “30 minutes” so that a later reader can tell why the means differ.

Example scale check. Halve the expected count when you halve the interval.
The example assumes independent events and a steady average rate. If the readings arrive in bursts, compare the model against the observed share of quiet intervals before using the number to set expectations.



