**Question**

A soda bottling company’s manufacturing process is calibrated so that 99% of bottles are filled to within specifications, while 1% is not within specification. Every hour, 12 random bottles are taken from the assembly line and tested. If 2 or more bottles in the sample are not within specification, the assembly line is shut down for recalibration. What is the probability that the assembly line will be shut down, given that it is actually calibrated correctly? Use Excel to find the probability.

- Round your answer to three decimal places.

**Question**

Alex wants to test the reliability of “lie detector tests,” or polygraph tests. He performs a polygraph test on a random sample of 12 individuals. If there is more than a 50% chance that the tests result in no false positives (that is, the test does not result in a true statement being recorded as a lie), Alex will conclude that the tests are reliable. If the probability of a lie detector test resulting in a false positive is 5.5%, what will Alex conclude? Use Excel to find the probability, rounding to three decimal places.

**Question**

A database system assigns a 32-character ID to each record, where each character is either a number from 0 to 9 or a letter from A to F. Assume that each number or letter being selected is equally likely. Find the probability that at least 20 characters in the ID are numbers. Use Excel to find the probability.

- Round your answer to three decimal places.

**Question**

A roulette wheel has 38 slots, numbered 1 to 36, with two additional green slots labeled 0 and 00. Jim, a dealer at a roulette table, tests the roulette wheel by spinning a ball around the wheel repeatedly and seeing where the ball lands. The ball has an equally likely chance of landing in each slot. If Jim spins the ball around the wheel 25 times, what is the probability that the ball lands in a green slot at most twice? Use Excel to find the probability.

- Round your answer to three decimal places.

# Solution:

A soda bottling company’s manufacturing process is calibrated so that 99% of bottles are filled to within specifications, while 1% is not within specification. Every hour, 12 random bottles are taken from the assembly line and tested. If 2 or more bottles in the sample are not within specification, the assembly line is shut down for recalibration. What is the probability that the assembly line will be shut down, given that it is actually calibrated correctly? Use Excel to find the probability.

- Round your answer to three decimal places.

**Answer:** 0.006

Alex wants to test the reliability of “lie detector tests,” or polygraph tests. He performs a polygraph test on a random sample of 12 individuals. If there is more than a 50% chance that the tests result in no false positives (that is, the test does not result in a true statement being recorded as a lie), Alex will conclude that the tests are reliable. If the probability…**Please click the icon below to download the solution at $2**