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
Report DMCA
TutorRating
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..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy