Part A Each time you press F9 on your keyboard, you see an alternate life for Jacob, with his status for each age range shown as
either alive or dead. If the dead were first to appear for the age range of 75 to 76, for example, this would mean that Jacob died between the ages of 75 and 76, or that he lived to be 75 years old. Press F9 on your keyboard five times and see how long Jacob lives in each of his alternate lives. How long did Jacob live each time? Part B The rest of the potential clients are similar to Jacob, but since they’ve already lived parts of their lives, their status will always be alive for the age ranges that they’ve already lived. For example, Carol is 44 years old, so no matter how many times you press F9 on your keyboard, Carol’s status will always be alive for all the age ranges up to 43–44. Starting with the age range of 44–45, however, there is the possibility that Carol’s status will be dead. Press F9 on your keyboard five more times and see how long Carol lives in each of her alternate lives. Remember that she will always live to be at least 44 years old, since she is already 44 years old. How long did Carol live each time? 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? Thank you in advance and I will mark branliest
