please use excel! Please show all formulas and steps to each part! thank you!

1. Team uses the random numbers in cells C13:C18 of Fig-ure 12.1 to generate six random observations for each of the fol-lowing situations. a. Throwing an unbiased coin. b. A baseball pitcher who throws a strike 60 percent of the time and a ball 40 percent of the time. c. The color of a traffic light found by a randomly arriving car when it is green 40 percent of the time, yellow 10 percent of the time, and red 50 percent of the time. FIGURE 12.1