In: Statistics and Probability
Hello:
I am working on some homework problems for decision modeling. Here is the question: The weekly deman for a slow moving product has the following probability mass function:
Demand, x Probability f(x)
0 0.2
1 0.4
2 0.3
3 0.1
4 or more 0
Use VLOOKUP to generate 25 random variates from this distribution. I know i have to use RAND and VLOOKUP I just cannot get it to give me 25 random numbers. Thank you for any help you can give me.