SHOW ANSWER IN MS EXCEL

4. (15 pts) From records it has kept for several years, the Bonton Boutique has established the following frequency distribution for daily sales volume: Relative Frequency, % 2 Sales Volume 0 to $100 $100 to $200 $200 to $300 $300 to $400 $400 to $500 $500 to $600 $600 to $700 $700 to $800 8 30 25 15 11 6 3 a) Use Monte Carlo simulation for 25 days or more to determine the average daily sales. b) Use probability analysis with expected values to determine the average daily sales. c) Explain any difference between the values for average daily sales determined by Monte Carlo simulation and probability analysis. 4. (15 pts) From records it has kept for several years, the Bonton Boutique has established the following frequency distribution for daily sales volume: Relative Frequency, % 2 Sales Volume 0 to $100 $100 to $200 $200 to $300 $300 to $400 $400 to $500 $500 to $600 $600 to $700 $700 to $800 8 30 25 15 11 6 3 a) Use Monte Carlo simulation for 25 days or more to determine the average daily sales. b) Use probability analysis with expected values to determine the average daily sales. c) Explain any difference between the values for average daily sales determined by Monte Carlo simulation and probability analysis