Les From RAND 512121 D 60349 90587 98976 90709 03255 72195 64581 33869 24012 55275 52995 32305 77762 0757 36128 1003 1497 3364 9215 8453 4967 2598 4753 6489 X hoving product has the accompanying probability mass function Use VLOOKUP to generate 25 random variates from this distribution Click here to view the probability mass function Click here to view 25 random values Set up an Excel worksheet with the Demand x column of the probability mass function in column A and the Probability f x column of the probability mass function in column B Construct an F x column column for the cumulative probability function in column C an Interval Lower Bound column a column for the lower bound of the interval for each row in column D and an Interval Upper Bound column column for the upper bound of the interval for each row in column E Duplicate the Demand x column from column A in column F Construct a Random Number column a column with random numbers generated by RAND in column G and an Outcome column in column H Place all row headers in row 1 and place the Demand x categories 0 1 2 3 and 4 or more in cells A2 A3 A4 A5 and respectively Then for a worksheet set up in this fashion the appropriate VLOOKUP function for cell H2 using the appropriate random number generated in column G would be VLOOKUP s 3 Probability Mass Function Demand x 0 1 2 3 4 or more Probability f x 0 2 0 4 0 3 0 1 0 www X