Compare exact, cumulative and interval event counts
Your goal: Build a complete binomial report for a fixed number of independent trials with one constant event probability.
Full task requirements
Enter separate formulas in E2:E6. B2 is the fixed number of independent trials, B3 the same event probability in every trial and B4 an exact count. E2 is P(X=B4); E3 is P(X<=B4); E4 is P(X>=B7); E5 is P(B5<=X<=B6), including both endpoints; E6 is the expected count. Keep probabilities as unrounded proportions. Preserve small nonzero tails rather than rounding them to zero.
Twelve independent checksChoose the fixed-trial binomial model
Read each probability-model input beside its original A label. Count, event proportion and exposure units have different roles; probabilities retain full precision.
| # | ||
|---|---|---|
| 1 | ||
| 2 | ||
| 3 | ||
| 4 | ||
| 5 | ||
| 6 | ||
| 7 |
Step 1 of 4
Choose the fixed-trial binomial model
Rules for this step
Select trial count and event proportion. The trials are independent and each uses the same p; expected count need not be a whole observed count.