The sales activity at Best Car has changed. Weekly sales are now estimated to be distributed as follows:
Weekly sales (cars) Relative Frequency (probability)
0 .....................0.02
1 .....................0.03
2 .....................0.05
3 .....................0.10
4 .....................0.15
5 .....................0.30
6 .....................0.20
7 .....................0.10
8 .....................0.05
Total 1.00
Create an Excel model that simulates 500 weeks at best car. It should calculate from the simulated experience the average number of cars and revenue per week and also a frequency table on car sales.