(Solved)The sales activity at BestCar is estimated to be distribu
The sales activity at BestCar is 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 BestCar. It should calculate from the simulated experience the average number of cars and revenue per week and also a frequency table on car sales.
Expert Answer
Answer to The sales activity at BestCar is estimated to be distribu. . .
OR