Question: 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

Part D Next, go back to the Task 2a worksheet,
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?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!