Excel Functions in EAC ToolsExcel Functions in EAC Tools\Life expectancy and survival functionsLife expectancy and survival functions\AgeOfSurvival

AgeOfSurvival

AgeOfSurvival calculates age at death for a life 𝑥, for a given probability of survival, based on the mortality assumption. This is based on an iterative process using the ProbSurvival function.

Syntax

AgeOfSurvival (CurrentAge, ProbSurv, MortalityTable, [AgeSetback], [NotUsed], [IssueAge])

Parameter Name

Description

CurrentAge

Current age 𝑥. May be provided as an integer, or as a fractional amount (e.g. years & months).

ProbSurv

A given probability of survival, for which the function will solve for a future age such that the probability of survival from CurrentAge to the future age equals ProbSurv. For example:

·        If ProbSurv is 0, then AgeOfSurvival returns omega, 𝜔, the terminal age of the table, plus 1, because there is zero chance of living to that age.

·        If ProbSurv is 1, then AgeOfSurvival returns CurrentAge.

May be either a percent or a number, e.g. 50% or .5; not less than zero, not more than 1.

MortalityTable

Mortality table definition text string.

AgeSetback

Mortality table age set-back. A negative number is a set-forward.
Note that you can also define a setback using the "/sb" option in the table definition (or "/sf").
Optional, default = 0.

NotUsed

This parameter is not used, but it is kept for backward compatibility.

IssueAge

If using generational mortality projection, age at issue.
Optional, default = CurrentAge.