Please help me to solve the following question using excel .

Please explain and show all formula used. Thank you

2. Clark Property Management is responsible for the maintenance, rental, and day-to-day operation of a large apartment complex on the east side of New Orleans. George Clark is especially concerned about the cost projections for replacing air conditioner compressors. He would like to simulate the number of compressor failures each year over the next 20 years. Using data from a similar apartment building he manages in a New Orleans suburb, Clark establishes a table of relative frequency of failures during a year as shown in the following table: NUMBER OF A.C. PROBABILITY COMPRESSOR (RELATIVE FAILURES FREQUENCY) 0.06 0.13 2 0.25 3 0.28 4 0.20 5 0.07 6 0.01 He decides to simulate the 20-year period by selecting two-digit random numbers from the third column of Table 14.4, starting with the random number 50. Conduct the simulation for Clark. Is it common to have three or more consecutive years of operation with two or fewer compressor failures per year