Also include a histogram to describe the distribution of


Supermarket customers load their carts with goods totaling between $5 and $200, uniformly (and continuously) distributed; call this the raw order amount. Assume that customers purchase independently of each other. At checkout, 63% of customers have a loyalty card that gives them a 4% discount of their raw order amount. Also at checkout, 18% of customers have coupons that give them 7% off their raw order amount. These two discounts occur independently of one another, and a given customer could have one of them, both of them, or neither of them, to get their net order amount, the amount they actually end up paying. Construct a spreadsheet simulation to simulate 100 customers and collect statistics on the net order amount; these statistics should include the average, standard deviation, minimum, and maximum. Also include a histogram to describe the distribution of the net order amounts between $0 and $200 with an interval length of $25. How I can calculate the NET AMOUNT?

Request for Solution File

Ask an Expert for Answer!!
Operation Management: Also include a histogram to describe the distribution of
Reference No:- TGS02483735

Expected delivery within 24 Hours