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

ProbSurvivalW

ProbSurvivalW calculates the probability of survival due to turnover from current age 𝑥 to future age 𝑥 + 𝑛, based on the termination table assumption.

Syntax

ProbSurvivalW (CurrentAge, FutureAge, MortalityTable)

Parameter Name

Description

CurrentAge

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

FutureAge

Future age 𝑥 + 𝑛.

TerminationTable

One of the published T-Tables = "t1", "t2", … , "t17"; or a named range of rates; or a reference to a range of rates.