| チョコレートを買った数 | エクセルでの計算式 | 少なくともひとつはシロクマのぬいぐるみが当たる確率 | ||
| 20 | =1-BINOMDIST(0,C42,0.05,FALSE) | 0.6415 | ||
| 30 | =1-BINOMDIST(0,C43,0.05,FALSE) | 0.7854 | ||
| 40 | =1-BINOMDIST(0,C44,0.05,FALSE) | 0.8715 | ||
| 50 | =1-BINOMDIST(0,C45,0.05,FALSE) | 0.9231 | ||
| 60 | =1-BINOMDIST(0,C46,0.05,FALSE) | 0.9539 | ||
| 70 | =1-BINOMDIST(0,C47,0.05,FALSE) | 0.9724 | ||
| 80 | =1-BINOMDIST(0,C48,0.05,FALSE) | 0.9835 | ||
| 90 | =1-BINOMDIST(0,C49,0.05,FALSE) | 0.9901 | ||
| 100 | =1-BINOMDIST(0,C50,0.05,FALSE) | 0.9941 | ||
| 50 | 0.9231 | |||
| 51 | 0.9269 | |||
| 52 | 0.9306 | |||
| 53 | 0.9340 | |||
| 54 | 0.9373 | |||
| 55 | 0.9405 | |||
| 56 | 0.9434 | |||
| 57 | 0.9463 | |||
| 58 | 0.9490 | |||
| 59 | 0.9515 | |||
| 60 | 0.9539 | |||
| 81 | 0.9843 | |||
| 82 | 0.9851 | |||
| 83 | 0.9858 | |||
| 84 | 0.9865 | |||
| 85 | 0.9872 | |||
| 86 | 0.9879 | |||
| 87 | 0.9885 | |||
| 88 | 0.9890 | |||
| 89 | 0.9896 | |||
| 90 | 0.9901 |