# Project #40628 - spreadsheet

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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
amosmm

Chat Now!

out of 766 reviews
PhyzKyd

Chat Now!

out of 1164 reviews
rajdeep77

Chat Now!

out of 721 reviews
sctys

Chat Now!

out of 1600 reviews
sharadgreen

Chat Now!

out of 770 reviews
topnotcher

Chat Now!

out of 766 reviews
XXXIAO

Chat Now!

out of 680 reviews
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy