Question: Hello, I am having some trouble on an assignment on probability and hypergeometric distribution. Cluster bombs are weapons composed of several smaller bomblets in a

Hello, I am having some trouble on an assignment on probability and hypergeometric distribution.

Cluster bombs are weapons composed of several smaller bomblets in a dispensing tubes. When delivered by air, a timed system opens the container at a predesigned time during free-fall.A small parachute on the soda can-sized bomblet decelerates the unit, which allows dispersal of the bomblets over a football-field sized area.One such munition used by the US in Yugoslavia (1999) and the first Gulf War (1991) is the CBU-87, which carries 202 bomblets.On average, 10 bomblets in each CBU-87 are unexploded due to fuse failures, creating a continuing hazard to civilians and soldiers alike.Suppose that during construction of a bomblet, 202 bomblets are obtained from a shipment of 1000, of which 5% are defective.Let a success correspond to a bomblet that is not defective.

Use the appropriate formula to write an equation in Excel to find the probability that 200 of the bomblets are not defective.

I am confused mainly on what the formula would be and how I would get this to work. Thanks

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!