Stat

O Points: 0 of 5 The weekly demand of a slow-moving 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, a 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, a 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 =RANDO. 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 A6, 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( , $ $ $ $ 3). X Random Values From =RANDO X Probability Mass Function 0.220972629 Demand, x Probability, f(x) 0.430604265 0 0.2 0.476363237 0.1 0 504894237 0.3 0.318112384 0.4 0. 186416841 4 or more 0 951548201 0 838541499 0.907428821 0.083165816 0 547086718 Print Done 0.375510316 0.729018602 0.287870641 0.841850563 0.352303464 0. 151807859 0.325099822 0.272997379 0 427686936 0.245747232 0.660694367 0.002108759 0.017322441 0.742369565 Clear all Check answer Etext pages Tech hel 5:10 PM C O Type here to search 90.F Partly sunny 7/5/2022