How do you do this on Excel? Edward Owen is responsible for the maintenance, rental, and day to day operation of several large apartment complexes on the upper-east side of NYC. Owen is especially concerend about the cost projections for replacing air conditioner (A/C) compressors.

He would like to simulate the number of A/C failres each month. Using data from familier apartment buildings he manages in a NYC suburb, Owen established the probability of failuers during a month as follows:

Number of A/C FailuresProbability
00.10
10.17
20.21
30.28
40.16
50.07
60.01
A) Simulate Owen's monthly A/C failures for a period of three years (36 months). Compute the average number of failures per month and the expected failures per month.

B) Explain any difference between the simulated average failures and the expected value of failures computed using the probablity distribution.