The sales activity at BestCar (see Example E.3) has changed. Weekly sales are now estimated to be distributed as follows:02 1 0.03 2 0.05 3 0.10 4…

Hello I need help with the following question. For this problem, I need help creating an Excel model that simulates weekly sales for 500 weeks and calculates average number of cars sold, revenue per week and a frequency table of cars sold. Can you help me?