Keep the same weekly sales distribution for Best Car as in Example but assume that the price of cars is distributed as follows:
Sales Price (price/car) Relative Frequency (probability)
$18,000 .................0.15
$20,000 .................0.35
$22,000 .................0.35
$24,000 .................0.10
$26,000 .................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.