Excel Functions in EAC ToolsExcel Functions in EAC Tools\Single life functionsSingle life functions\Other single life functionsOther single life functions\SLProb

SLProb

SLProb calculates various single life mortality functions.

Syntax

SLProb(WhatFunction, CurrentAge, FutureAge, InterestRate, MortalityTable, [Frequency], [CalculationMethod], [IssueAge])

Parameter Name

Description

WhatFunction

What mortality function to calculate:

“qx”, “px”, “lx”, “dx”, “ex” (or “q”, “p”, “l”, “d”, “e”)

Age

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

MortalityTable

Mortality table definition text string.
Optional, default = none

CalculationMethod

Method of calculation for fractional ages. This applies only to qx, px, and ex.
CalculationMethod does not apply to lx and dx which are based on UDD.
Optional, default = 0

Method

Description

0

interpolate on values calculated at whole ages

1

assume that 𝑙𝑥+𝑡 is a linear function of 𝑡 for 0 ≤ 𝑡 ≤ 1 (UDD)

IssueAge

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

Term

(optional) term to be used for the selected function; for "qx", "px", and "dx" the default value is 1; for ex the default is (table omega - age); not used for "lx"