Compare finite sampling with a replacement model
Enter separate formulas in E2:E6. A finite population has B2 total records and B3 marked records; choose a uniformly random subset of B4 records without replacement. E2 is the probability of exactly B5 marked records, E3 is at most B5 and E4 is at least B6. E5 is the expected marked count. E6 is the contrasting exact-count probability if the B4 draws were instead independent with replacement, each having event proportion B3/B2. Do not use that contrasting model for E2:E4.
The answer cells begin blank. Enter a reusable formula and check it against the published practice datasets. Hints and the solution are available when you choose them.
Practice stays on this device. No worksheet data is uploaded.
A checkpoint records a fresh check of every dataset. This attempt tracks built-in hints, solutions, steps and worked examples; it does not establish independent authorship.
Help recorded: none of these built-in aids opened.
Make the formula your own.
View task requirements
Enter separate formulas in E2:E6. A finite population has B2 total records and B3 marked records; choose a uniformly random subset of B4 records without replacement. E2 is the probability of exactly B5 marked records, E3 is at most B5 and E4 is at least B6. E5 is the expected marked count. E6 is the contrasting exact-count probability if the B4 draws were instead independent with replacement, each having event proportion B3/B2. Do not use that contrasting model for E2:E4.
No account. No upload. Just try it.