O
o.menary
Member
To check the answers of the goal seek in scenario 4 and 5, the example summary explains the results of a mortality reduction of 51% and 9% are reasonable as:
1. 51% : "The magnitude is broadly as would be expected, since a 20% reduction factor resulted in an increase of 0.7 years to 8.5 years, and therefore approximately a further 30% would be required in order to increase it by another 1.5 years to 10.0 years."
2. 9% "The magnitude is not unreasonable: a 20% reduction factor resulted in an increase of 6.2 years to 14.0 years, and therefore between a third and a half of this would be appropriate to increase it by the 2.2 years required to achieve the target of 10.0 years."
Can someone please explain how the futher 30% in part 1 above and "between a third and a half" in part 2 are found?
Thanks!
1. 51% : "The magnitude is broadly as would be expected, since a 20% reduction factor resulted in an increase of 0.7 years to 8.5 years, and therefore approximately a further 30% would be required in order to increase it by another 1.5 years to 10.0 years."
2. 9% "The magnitude is not unreasonable: a 20% reduction factor resulted in an increase of 6.2 years to 14.0 years, and therefore between a third and a half of this would be appropriate to increase it by the 2.2 years required to achieve the target of 10.0 years."
Can someone please explain how the futher 30% in part 1 above and "between a third and a half" in part 2 are found?
Thanks!