Question

CENGAGE | MINDTAP Q Search this course Ch 05: Mastery Assignment - Discrete Probability Distributions < Back to Assignment =1-POISSON.DIST(6.1,4, TRUE) =POISSON.DIST(4,6.1, TRUE) Attempts: Average: /4 =POISSON.DIST(4,6.1, FALSE) 10. Using Excel - Poisson probabilities =POISSON.DIST(6.1,4, TRUE) =POISSON.DIST(6,6.1, FALSE) =POISSON.DIST(6.1,4,FALSE) =POISSON.DIST(6.1,6, FALSE) Suppose the number of fouls called per game in an under 16 girls indoor soccer league follows a Poisson distribution with 6.1 fouls per game. Define x as the number of fouls called in a game. You will answer questions concerning the probabilities of different values of x in this sample Excel spreadsheet: =1-POISSON.DIST(4,6.1, TRUE) =1-POISSON.DIST(6,6.1, TRUE) =POISSON.DIST(6.1,6,TRUE) = 1-POISSON.DIST(6.1,6, TRUE) =POISSON.DIST(6,6.1, TRUE) 1 2 3 P(x = 4) P(x56) P(x > 3) =POISSON.DIST(6.1,3,FALSE) =1-POISSON.DIST(3,6.1, TRUE) You are about to watch an under 16 girls indoor soccer game. In cell B1 of the sample spreadsheet, select the correct Excel formula for computing the probability that four fouls will be called in this game. 0.1294 =POISSON.DIST(3,6.1, TRUE) 0.5902 0.8576 Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that four fouls will be called in this game is (Round your answer to 4 decimal places.) =1-POISSON.DIST(6.1,3, TRUE) =POISSON.DIST(6.1,3, TRUE) =POISSON.DIST(3,6.1,FALSE) 0.2718 In cell B2 of the sample spreadsheet, select the correct Excel formula for computing the probability that six fouls or fewer will be called in this game. 0.9841 0.2718 0.0137 0.0137 Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that six fouls or fewer will be called in this game is (Round your answer to 4 decimal places.) 0.5902 0.9841 In cell B3 of the sample spreadsheet, select the correct Excel formula for computing the probability that more than three fouls will be called in this game. 0.1294 0.8576 Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that more than three fouls will be called in this game is . (Round your answer to 4 decimal places.) 0.5902 Grade It Now Save & Continue 0.9841 Continue without saving 0.8576 0.1294 0.2718 0.0137

Answer 1

1. pCX342 → POLSSON: DEST(4,6.1, FALSE) 2 P(X+6) + PO ISSO NOD EST (616.1, TRUE) 3. P(X73)1-PO ESSONDEST (3161, TRUE)._- = P(x=4 = prob. that the four foulot will be called in this game = 0.1294 ( 626) zprob. that six or fewer Fauls will be called = o. 5902 P (873)= Poobability that more than : 8 fault will be called in this game is to 0. 8576 ėjual