An Introduction to Management Science 13th Edition by David Anderson,Dennis Sweeney ,Thomas Williams ,Jeffrey Camm, Kipp Martin

Exercise 23

Use a worksheet to simulate the rolling of dice. Use the VLOOKUP function as described in Appendix 12.1 to select the outcome for each die. Place the number for the first die in column B and the number for the second die in column C. Show the sum in column D. Repeat the simulation for 1000 rolls of the dice. What is your simulation estimate of the probability of rolling a 7?