The weekly demand of a slow-moving product has the accompanying probabexty mass function. Use VLOOKUP to gonerate 25 tandom varistes from this distribution. Click here to view the nrobability mass function. Click here to view 25 random values Set up an Excel workshent with the "Demand, x column of the probabily mass function in columin A and the "ProbabEly. f(y)" column of the probability mass function in column B In column D, and an "Interval Upper Bound" column, a column for the upper bound of the interval for each row, in column E. Duplicate the "Demand x " column from column A in columi F. Construct a Random Number" column, a column with tandom numbers generated by aRANDO. in column G and an "Outcome" column in column H Place all row headen in tow 1 and place the "Demand, x categories "0, " 1,2,2,3,, and 4 or more" in cells A2,A3,A4,A5, and A6, respectively Then, for a worksheet set up in this tashion, the appeoptate VLOOKUP function for cell H2 using the appropelate random number getherated in column G would be a VLookup ekly demand of a slow-moving product has the accompanying probability mass function. Use VLOOKUP to gent re tquiew the probability mass function. are thlew 25 random values. Probability MaSS Function an Excel worksheet with th uct an "F(x)" column, a colv mnD; and an "Interval Upp nF. Construct a "Random N 1 and place the "Demand, for a worksheet set up in th $3. 3). emand of a slow- view the probabili view 25 random v The weekly demand of a slow-moving product has the accompanying probabexty mass function. Use VLOOKUP to gonerate 25 tandom varistes from this distribution. Click here to view the nrobability mass function. Click here to view 25 random values Set up an Excel workshent with the "Demand, x column of the probabily mass function in columin A and the "ProbabEly. f(y)" column of the probability mass function in column B In column D, and an "Interval Upper Bound" column, a column for the upper bound of the interval for each row, in column E. Duplicate the "Demand x " column from column A in columi F. Construct a Random Number" column, a column with tandom numbers generated by aRANDO. in column G and an "Outcome" column in column H Place all row headen in tow 1 and place the "Demand, x categories "0, " 1,2,2,3,, and 4 or more" in cells A2,A3,A4,A5, and A6, respectively Then, for a worksheet set up in this tashion, the appeoptate VLOOKUP function for cell H2 using the appropelate random number getherated in column G would be a VLookup ekly demand of a slow-moving product has the accompanying probability mass function. Use VLOOKUP to gent re tquiew the probability mass function. are thlew 25 random values. Probability MaSS Function an Excel worksheet with th uct an "F(x)" column, a colv mnD; and an "Interval Upp nF. Construct a "Random N 1 and place the "Demand, for a worksheet set up in th $3. 3). emand of a slow- view the probabili view 25 random v
