The following problems involve simulations that are to be done by Excel. Please submit the excel worksheet as well. 9. Clark Property Management is responsible for the maintenance, rental, and dayto-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: (30 points) NUMBER OF AS. I'RDBJIBILITY COMPRESSOR FAILURES [RELATIVE FREQUENCY ] {II Ub 1 U. I 3 2 0.25 3 0.23 4 [1.21] 5 DH? fl- no] He decides to simulate the 20-year period by selecting random numbers using excel (randO). 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