Question

suppose a retailer has two markets, 1 and 2. demand 1 follows normal distribution with mean...

suppose a retailer has two markets, 1 and 2. demand 1 follows normal distribution with mean 100 and standard deviation 12.4. demand 2 follows normal distribution with mean 110 and standard deviation 16.7. the retailer needs to know the mean and standard deviation of the difference between the two demands. please describe the conceptual analysis process to find out these two parameters by using simulation

0 0
Add a comment Improve this question Transcribed image text
Answer #1

For market 1, mean (μ1) = 100, stdev (σ1) = 12.4
For market 2, mean (μ2) = 110, stdev (σ2) = 16.7

For the difference, mean (μ) = μ2 + (- μ1)= 110 - 100 = 10
For the difference, variance (σ2) = σ22 + (- σ1)2 = (16.7)2 + (-12.4)2 = 432.65; so, stdev (σ) = √432.65 = 20.8

Therefore, Difference ~ Normal (10, 20.8)

--------------------------

Simulation model

Demand Simulation (2.500 runs 3 Market 1 -NORMINV(RANDO.100,12.4) 4Market 2 -NORMINV(RANDO,110,16.7 Difference-C4-C3 8 Average FAVERAGE(F4.F2503) Stdev STDEV S(F4 F2503) 10 Data Table Row input cell: Column input cell: SAS1 12 13 14 15 16 17 18 19 20 21 10 12 13 OK Cancel 15 16 17 18 19 20 21 24 25 26 27 28 23 24 25 30 31 27 2500 28

Result

Average 9.9
Stdev 20.6

So, based on simulation: Difference ~ Normal (9.9, 20.6)

Add a comment
Know the answer?
Add Answer to:
suppose a retailer has two markets, 1 and 2. demand 1 follows normal distribution with mean...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT