Question

Run a simulation of two, 6-sided (fair) dies being rolled 5,000 each. The two die are rolled at the same time, and the sum is recorded. Find the probability the sum is larger than 9. Solve in SAS , give SAS formula/equation. SAS or EXCEL

Answer 1

EXCEL Steps:

Step 1. In A1, we use Excel function "=RANDBETWEEN(1,6)" then enter. Now click on A1 and hold the fill handle in the bottom right corner of the cell that contains the number. Drag the fill handle downward to A1:A5000. These give 5000 random integers between 1 to 6.

Step 2. As Step 1, we do same in Column B and B1:B5000 give another 5000 random integers between 1 to 6.

Step 3. Add Column A and Column B in store these in C1:C5000.

Step 4. Use Excel function "=5000-FREQUENCY(C1:C5000,9)" which gives the frequency of sums which are larger than 9.

Step 5. For simulated probability, we use Excel function "=(5000-FREQUENCY(C1:C5000,9))/5000".

Output: the frequency of sums which are larger than 9=840

Simulated probability the sum is larger than 9=0.1684.