2-15 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 4% off 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 each other, and a given customer could have one or the

other of them, both of them, or neither of them, to get to their net order amount (what

they actually pay). 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, maximum, and a histogram to describe the distribution of

the net order amounts between $0 and $200. (HINT: to decide whether a customer gets a

loyalty discount, explore the Excel IF function with the first argument’s being a random

number RAND() distributed uniformly between 0 and 1; do similarly to decide on a

coupon discount.)

Subject | Mathematics |

Due By (Pacific Time) | 09/19/2014 10:15 pm |

Tutor | Rating |
---|---|

pallavi Chat Now! |
out of 1971 reviews More.. |

amosmm Chat Now! |
out of 766 reviews More.. |

PhyzKyd Chat Now! |
out of 1164 reviews More.. |

rajdeep77 Chat Now! |
out of 721 reviews More.. |

sctys Chat Now! |
out of 1600 reviews More.. |

sharadgreen Chat Now! |
out of 770 reviews More.. |

topnotcher Chat Now! |
out of 766 reviews More.. |

XXXIAO Chat Now! |
out of 680 reviews More.. |