Next, go back to the Task 2a worksheet, press F9, and repeat this process until you have recorded 20 trials in the Task 2b worksheet. In the Percent Survived row at the bottom of the table on the Task 2b worksheet, it will show the percentage of times each client survived to the end of his or her policy, and it will also show the percentage of times that all of the clients survived to the end of their respective policies. Check to see whether these percentages are in line with the probabilities that you calculated in questions 1 through 9 in Task 1.
Now save your spreadsheet and submit it to your teacher using the drop box.
Are your probabilities from the simulation close to the probabilities you originally calculated?