#2 Below is the Excel spreadsheet for Monte Carlo simulations of rolls of a four- sided (i.e., tetrahedron) die with face values 1, 2, 3, and 4. The first simulation, shown in cells C8 to C17, presumes the die is weighted in proportions 1:3:3:1 so that the probabilities are 1/8, 3/8, 3/8, and 1/8 for sides 1, 2, 3, and 4, respectively. The second simulation, shown in cells D8 to D17, presumes the die is weighted in proportions 1:2:3:4 so that the probabilities are 1/10, 2/10, 3/10, and 4/10 for sides 1, 2, 3, and 4, respectively.

#2.1 How was the entry in cell E8 generated? (Be specific show the Excel equation.)

#2.2 How was the entry in cell C8 generated? (Be specific show the Excel equation.)

#2.3 How was the entry in cell D8 generated? (Be specific show the Excel equation.)

face 1:23:4 0.1 1:33:1 0.125 0.375 0.375 0.125 0.2 wN 0.3 0.4 observations 1:33:1 1:2:3:4 random number 0.61918 0.91039 0.62817 0.38966 0.28359 0.83285 0.52996 0.85601 0.94678 0.60662