MATH225N Week 4 Assignment: Distribution with Probability Rules – Excel
Question 1
At a certain fast food restaurant, 77.5% of the customers order items from the value menu. If 14 customers are randomly selected, what is the probability that at least 9 customers ordered an item from the value menu? Use Excel to find the probability.
- Round your answer to three decimal places.
Question 2
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.
Question 3
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.
Ans:
Alex will conclude that the test is reliable since the probability of no false positives is less than 0.5.
Alex will conclude that the test is not reliable since the probability of no false positives is greater than 0.5.
Alex will conclude that the test is not reliable since the probability of no false positives is less than 0.5.
Alex will conclude that the test is reliable since the probability of no false positives is greater than 0.5.
Question 4
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.
Ans……………….please follow the link below to purchase the solution at $5
