Part C
Now you will find the percent survival of each of your eight clients to the end of his or her policy using the simulation in the spreadsheet.

For each potential client, you will see whether he or she would be alive at the end of his or her policy. The cells in the spreadsheet that you should look at to determine this are highlighted in yellow.

Next, go to the worksheet labeled Task 2b and record either alive or dead for the first trial. Once you do this, the All column will say yes if all the clients were alive at the end of their policies or no if all the clients were not alive at the end of their policies. Were all the clients alive at the end of their policies in the first trial?

Part D
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?