Please solve it in excel and show the formulas

0.15 0.06 QI. (10 Marks) Members of the Willow Creek Emergency Rescue Squad know from past experience that they will receive between zero and six emergency calls each night, according to the following discrete probability distribution: Calls Likelihood 0 0.05 1 0.12 2 0.15 3 0.25 4 0.22 5 6 Total probability: 1.00 The rescue squad classifies each emergency call into one of three categories: minor, regular, or major emergency. The discrete probability that a particular call will be each type of emergency is as follows: Emergency type Likelihood Minor 0.30 Regular 0.56 Major 0.14 Total probability: 1.00 The type of emergency call determines the size of the crew sent in response. A minor emergency requires a two-person crew, a regular call requires a three-person crew, and a major emergency requires a five-person crew. Simulate the emergency calls received by the rescue squad for 100 nights, compute the average number of each type of emergency call each night, and determine the 1. minimum 2. mean, and 3. maximum number of crew members that might be needed on any given night