1 2 3 A P(x = 2) P(x 5) P(x > 3) You are about...

  

Transcribed Image Text:

1 2 3 A P(x = 2) P(x ≤ 5) P(x > 3) 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 two goals will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that two goals will be scored in this (Round your answer to 4 decimal places.) game is In cell 82 of the sample spreadsheet, select the correct Excel formula for computing the probability that five goals or fewer will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that five goals or fewer will be scored in this game is (Round your answer to 4 decimal places.) In cell B3 of the sample spreadsheet, select the correct Excel formula for computing the probability that more than three goals will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that more than three goals will be scored in this game is (Round your answer to 4 decimal places.) Suppose the number of goals scored per game in an under 16 girls indoor soccer league follows a Poisson distribution with 5.2 goals per game. Define x as the number of goals scored in a game. You will answer questions concerning the probabilities of different values of x in this sample Excel spreadsheet: 1 2 3 A P(x = 2) P(x ≤ 5) P(x > 3) 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 two goals will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that two goals will be scored in this (Round your answer to 4 decimal places.) game is In cell 82 of the sample spreadsheet, select the correct Excel formula for computing the probability that five goals or fewer will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that five goals or fewer will be scored in this game is (Round your answer to 4 decimal places.) In cell B3 of the sample spreadsheet, select the correct Excel formula for computing the probability that more than three goals will be scored in this game. Using your own Excel spreadsheet, calculate the probability using the Excel formula you selected. The probability that more than three goals will be scored in this game is (Round your answer to 4 decimal places.) Suppose the number of goals scored per game in an under 16 girls indoor soccer league follows a Poisson distribution with 5.2 goals per game. Define x as the number of goals scored in a game. You will answer questions concerning the probabilities of different values of x in this sample Excel spreadsheet:

Answer rating: 100% (QA)

1 PX2 poisson252false 2PX 31poisson352true or poissondist252false or poiss... View the full answer