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

LifeExpect

LifeExpect calculates the life expectancy for a life 𝑥 based on the mortality assumption.

·        Curtate life expectancy

·        Complete life expectancy

 

Syntax

LifeExpect (CurrentAge, MortalityTable, [AgeSetback], [TypeOfCalc])

Parameter Name

Description

CurrentAge

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

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.

TypeOfCalc

Type of life expectancy calculation.
Optional, default = 0.

Type

Description

0

complete joint life expectancy

curtate joint life expectancy + 1/2

 + 1/2

1

curtate joint life expectancy