please solve it in excel and also provide excel solvers and formulas

12.4. The weather can be considered a stochastic system, because it evolves in a probabilistic manner from one day to the next. Suppose for a certain location that this probabilistic evolution satisfies the following description: The probability of rain tomorrow is 0.6 if it is raining today. The probability of its being clear (no rain) tomorrow is 0.8 if it is clear today. a. Use the random numbers in cells C17:C26 of Figure 12.1 to simulate the evolution of the weather for 10 days, beginning the day after a clear day. E b. Now use a computer with the random numbers generated by Excel to perform the simulation requested in part a on a spreadsheet c D E 1 2 Coln-Flipping Game Required Difference Cash at End of Game S8 4 5 6 2 Summary of Game Number of Flips Winnings 9 10 TI 12 Total Heads Total Tails 0 Stop? 14 15 16 12 IX Flip 1 2 3 4 $ 6 7 1 1 1 20 21 23 3 4 6 3 Random Number 0.3039 0.7914 0.8542 0.6202 2004 0.03 OLUN 0,6052 0.223 0.4250 0.5229 0.793 01140 OXION 07589 0.2989 0.6427 0.2824 0.2124 0.6420 9 10 TI 12 13 14 45 46 47 48 49 50 Result Heads Tail This TH Heads Heads Heads This Heads Heads Heads Tails Heads Heads Tails Heads This Heads Heads Tails 1 2 3 3 3 3 4 4 4 4 5 5 5 19 24 23 20 57 38 39 60 61 7 2 * 9 26 27 27 Stop NA NA NA NA NA NA NA NA NA Cells Range Name CashAtEndoriame 19 20 20 20 21 29 29 C NumberOlips Random Number Required Difference Result Stop! TotalHeads Total Tails Win B1:B62 D7 CI: D) DIJ-1762 GJ.662 EJE62 F13F62 D D Smary of -COUNTBLANK Stop -CashAtEndon Numbers 6 7 Number of Flips Winning D 6 7 8 Summary of Game Number of Flips -COUNTBLANK(Stop?)+1 Winnings -CashAtEndorGame-NumberOfFlips Result Stop? TotalHeads Total Tails Winnings D E F 11 Random 12 Number 13 -RANDO 14 -RANDO 15 -RANDO 16 Total Result Heads IF(RandomNumber