Reference no: EM131242179
Answer the following question.
Understand the formulas used to get the answer.
The question was: Supermarket customers load their carts with goods totaling between $5 and $200 uniformly (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% of their raw order amount.
Also at checkout, 18% of customers have coupons that give them 7% of 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 amounts between $0 and $200.
(HINT: to decided 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 similarily to decide on a coupon discount.
|
Evaluate the effectiveness of the organization hr policies
: Evaluate the effectiveness of the organization's HR policies and processes that are designed to promote a diverse workforce. Next, outline one (1) strategy for the organization that recognizes affirmative action. Include a plan to mitigate both th..
|
|
What type of business product is a camelbak backpack
: Discuss how business relationships and strategic partnerships have helped to increase the value of CamelBak's products and the business itself.
|
|
Horizontal distance between the end of the rifle
: The barrel is pointed directly at the center of the bull's-eye, but the bullet strikes the target 0.0257 m below the center. What is the horizontal distance between the end of the rifle and the bull's-eye?
|
|
Major-league pitcher can throw a baseball
: A major-league pitcher can throw a baseball in excess of 39.3 m/s. If a ball is thrown horizontally at this speed, how much will it drop by the time it reaches a catcher who is 19.0 m away from the point of release?
|
|
Construct a spreadsheet simulation to simulate 100 customers
: Construct a spreadsheet simulation to simulate 100 customers and collect statistics on the net order amount; - Describe the distribution of the net amounts between $0 and $200.
|
|
The economics of uncontrolled asthma
: Evidence suggests there is a significant economic impact due to the number of people with uncontrolled asthma in Australia. You must provide evidence to support or refute this argument and compare with at least one other similar and dissimilar eco..
|
|
How does role of government affect market structures ability
: How does the role of the government affect each market structure's ability to price their products? How does international trade affect each market structure?
|
|
Create a perceptual map for the product you chose
: Create a perceptual map for the product you chose. Write a short statement that describes the overall position of each producCreate a perceptual map for the product you chose. Write a short statement that describes the overall position of each prod..
|
|
Evaluate the effectiveness of the organization hr policies
: Evaluate the effectiveness of the organization's HR policies and processes that are designed to promote a diverse workforce. Next, outline one (1) strategy for the organization that recognizes affirmative action. Include a plan to mitigate both th..
|