## Life Table in Excel with UNISTAT

The UNISTAT statistics add-in extends Excel with Life Table capabilities.

For further information visit UNISTAT User's Guide section 9.4.1. Life Table.

Here we provide a sample output from the UNISTAT Excel statistics add-in for data analysis.

### Survival Analysis

#### Life Table

Factor variable: Gender = Female

Time Variable: Survival time

Censor Variable: Status

Number of Cases Censored: 7 ( 24.1%)

Valid Number of Cases: 29, 19 Omitted

Median Survival Time: 18.0947

Interval Start | Number Entering | Number Censored | Number Exposed | Number Terminating | Proportion Surviving | Cumulative Proportion Surviving | Standard Error of Cumulative Surviving | Lower 95% of Cumulative Surviving |
---|---|---|---|---|---|---|---|---|

0 | 29 | 1 | 28.5 | 3 | 0.8947 | 0.8947 | 0.0575 | 0.7082 |

4 | 25 | 0 | 25.0 | 3 | 0.8800 | 0.7874 | 0.0771 | 0.5866 |

8 | 22 | 1 | 21.5 | 4 | 0.8140 | 0.6409 | 0.0911 | 0.4350 |

12 | 17 | 1 | 16.5 | 2 | 0.8788 | 0.5632 | 0.0952 | 0.3597 |

16 | 14 | 0 | 14.0 | 3 | 0.7857 | 0.4425 | 0.0970 | 0.2513 |

20 | 11 | 0 | 11.0 | 0 | * | * | * | * |

24 | 11 | 0 | 11.0 | 1 | 0.9091 | 0.4023 | 0.0962 | 0.2180 |

28 | 10 | 0 | 10.0 | 0 | * | * | * | * |

32 | 10 | 0 | 10.0 | 0 | * | * | * | * |

36 | 10 | 0 | 10.0 | 1 | 0.9000 | 0.3621 | 0.0946 | 0.1860 |

40 | 9 | 1 | 8.5 | 1 | 0.8824 | 0.3195 | 0.0926 | 0.1531 |

44 | 7 | 0 | 7.0 | 0 | * | * | * | * |

48 | 7 | 0 | 7.0 | 1 | 0.8571 | 0.2738 | 0.0899 | 0.1190 |

52 | 6 | 1 | 5.5 | 0 | * | * | * | * |

56 | 5 | 1 | 4.5 | 0 | * | * | * | * |

60 | 4 | 0 | 4.0 | 0 | * | * | * | * |

64 | 4 | 0 | 4.0 | 2 | 0.5000 | 0.1369 | 0.0819 | 0.0277 |

68 | 2 | 0 | 2.0 | 0 | * | * | * | * |

72 | 2 | 0 | 2.0 | 0 | * | * | * | * |

76 | 2 | 1 | 1.5 | 0 | * | * | * | * |

80 | 1 | 0 | 1.0 | 0 | * | * | * | * |

84 | 1 | 0 | 1.0 | 0 | * | * | * | * |

88 | 1 | 0 | 1.0 | 1 | 0.0000 | 0.0000 | 0.0000 | * |

Interval Start | Upper 95% of Cumulative Surviving | Proportion Terminating | Cumulative Proportion Terminating | Standard Error of Cumulative Terminating | Lower 95% of Cumulative Terminating | Upper 95% of Cumulative Terminating | Hazard Rate | Standard Error of Hazard Rate |

0 | 0.9648 | 0.1053 | 0.1053 | 0.0575 | 0.0352 | 0.2918 | 0.0278 | 0.0160 |

4 | 0.8984 | 0.1200 | 0.2126 | 0.0771 | 0.1016 | 0.4134 | 0.0319 | 0.0184 |

8 | 0.7883 | 0.1860 | 0.3591 | 0.0911 | 0.2117 | 0.5650 | 0.0513 | 0.0255 |

12 | 0.7244 | 0.1212 | 0.4368 | 0.0952 | 0.2756 | 0.6403 | 0.0323 | 0.0228 |

16 | 0.6180 | 0.2143 | 0.5575 | 0.0970 | 0.3820 | 0.7487 | 0.0600 | 0.0344 |

20 | * | * | * | * | * | * | * | * |

24 | 0.5802 | 0.0909 | 0.5977 | 0.0962 | 0.4198 | 0.7820 | 0.0238 | 0.0238 |

28 | * | * | * | * | * | * | * | * |

32 | * | * | * | * | * | * | * | * |

36 | 0.5413 | 0.1000 | 0.6379 | 0.0946 | 0.4587 | 0.8140 | 0.0263 | 0.0263 |

40 | 0.4997 | 0.1176 | 0.6805 | 0.0926 | 0.5003 | 0.8469 | 0.0313 | 0.0312 |

44 | * | * | * | * | * | * | * | * |

48 | 0.4547 | 0.1429 | 0.7262 | 0.0899 | 0.5453 | 0.8810 | 0.0385 | 0.0383 |

52 | * | * | * | * | * | * | * | * |

56 | * | * | * | * | * | * | * | * |

60 | * | * | * | * | * | * | * | * |

64 | 0.3320 | 0.5000 | 0.8631 | 0.0819 | 0.6680 | 0.9723 | 0.1667 | 0.1111 |

68 | * | * | * | * | * | * | * | * |

72 | * | * | * | * | * | * | * | * |

76 | * | * | * | * | * | * | * | * |

80 | * | * | * | * | * | * | * | * |

84 | * | * | * | * | * | * | * | * |

88 | * | 1.0000 | 1.0000 | 0.0000 | * | * | 0.5000 | 0.0000 |

Interval Start | Lower 95% of Hazard Rate | Upper 95% of Hazard Rate | Probability Density | Standard Error of Probability Density | Lower 95% of Probability Density | Upper 95% of Probability Density | ||

0 | 0.0000 | 0.0592 | 0.0263 | 0.0083 | 0.0101 | 0.0426 | ||

4 | 0.0000 | 0.0680 | 0.0268 | 0.0146 | 0.0000 | 0.0555 | ||

8 | 0.0013 | 0.1013 | 0.0366 | 0.0169 | 0.0035 | 0.0698 | ||

12 | 0.0000 | 0.0769 | 0.0194 | 0.0132 | 0.0000 | 0.0452 | ||

16 | 0.0000 | 0.1274 | 0.0302 | 0.0163 | 0.0000 | 0.0620 | ||

20 | * | * | * | * | * | * | ||

24 | 0.0000 | 0.0704 | 0.0101 | 0.0098 | 0.0000 | 0.0293 | ||

28 | * | * | * | * | * | * | ||

32 | * | * | * | * | * | * | ||

36 | 0.0000 | 0.0778 | 0.0101 | 0.0098 | 0.0000 | 0.0293 | ||

40 | 0.0000 | 0.0924 | 0.0106 | 0.0104 | 0.0000 | 0.0310 | ||

44 | * | * | * | * | * | * | ||

48 | 0.0000 | 0.1136 | 0.0114 | 0.0111 | 0.0000 | 0.0331 | ||

52 | * | * | * | * | * | * | ||

56 | * | * | * | * | * | * | ||

60 | * | * | * | * | * | * | ||

64 | 0.0000 | 0.3844 | 0.0342 | 0.0205 | 0.0000 | 0.0744 | ||

68 | * | * | * | * | * | * | ||

72 | * | * | * | * | * | * | ||

76 | * | * | * | * | * | * | ||

80 | * | * | * | * | * | * | ||

84 | * | * | * | * | * | * | ||

88 | 0.5000 | 0.5000 | 0.0342 | 0.0205 | 0.0000 | 0.0744 |

#### Life Table

Factor variable: Gender = Male

Time Variable: Survival time

Censor Variable: Status

Number of Cases Censored: 5 ( 26.3%)

Valid Number of Cases: 19, 29 Omitted

Median Survival Time: 17.1199

Interval Start | Number Entering | Number Censored | Number Exposed | Number Terminating | Proportion Surviving | Cumulative Proportion Surviving | Standard Error of Cumulative Surviving | Lower 95% of Cumulative Surviving |
---|---|---|---|---|---|---|---|---|

0 | 19 | 0 | 19.0 | 0 | * | * | * | * |

4 | 19 | 1 | 18.5 | 5 | 0.7297 | 0.7297 | 0.1033 | 0.4678 |

8 | 13 | 1 | 12.5 | 1 | 0.9200 | 0.6714 | 0.1103 | 0.4091 |

12 | 11 | 1 | 10.5 | 2 | 0.8095 | 0.5435 | 0.1208 | 0.2878 |

16 | 8 | 2 | 7.0 | 2 | 0.7143 | 0.3882 | 0.1267 | 0.1556 |

20 | 4 | 0 | 4.0 | 1 | 0.7500 | 0.2911 | 0.1269 | 0.0850 |

24 | 3 | 0 | 3.0 | 0 | * | * | * | * |

28 | 3 | 0 | 3.0 | 0 | * | * | * | * |

32 | 3 | 0 | 3.0 | 0 | * | * | * | * |

36 | 3 | 0 | 3.0 | 0 | * | * | * | * |

40 | 3 | 0 | 3.0 | 1 | 0.6667 | 0.1941 | 0.1159 | 0.0352 |

44 | 2 | 0 | 2.0 | 0 | * | * | * | * |

48 | 2 | 0 | 2.0 | 1 | 0.5000 | 0.0970 | 0.0898 | 0.0062 |

52 | 1 | 0 | 1.0 | 0 | * | * | * | * |

56 | 1 | 0 | 1.0 | 0 | * | * | * | * |

60 | 1 | 0 | 1.0 | 0 | * | * | * | * |

64 | 1 | 0 | 1.0 | 0 | * | * | * | * |

68 | 1 | 0 | 1.0 | 0 | * | * | * | * |

72 | 1 | 0 | 1.0 | 0 | * | * | * | * |

76 | 1 | 0 | 1.0 | 0 | * | * | * | * |

80 | 1 | 0 | 1.0 | 0 | * | * | * | * |

84 | 1 | 0 | 1.0 | 0 | * | * | * | * |

88 | 1 | 0 | 1.0 | 1 | 0.0000 | 0.0000 | 0.0000 | * |

Interval Start | Upper 95% of Cumulative Surviving | Proportion Terminating | Cumulative Proportion Terminating | Standard Error of Cumulative Terminating | Lower 95% of Cumulative Terminating | Upper 95% of Cumulative Terminating | Hazard Rate | Standard Error of Hazard Rate |

0 | * | * | * | * | * | * | * | * |

4 | 0.8775 | 0.2703 | 0.2703 | 0.1033 | 0.1225 | 0.5322 | 0.0781 | 0.0345 |

8 | 0.8372 | 0.0800 | 0.3286 | 0.1103 | 0.1628 | 0.5909 | 0.0208 | 0.0208 |

12 | 0.7419 | 0.1905 | 0.4565 | 0.1208 | 0.2581 | 0.7122 | 0.0526 | 0.0370 |

16 | 0.6180 | 0.2857 | 0.6118 | 0.1267 | 0.3820 | 0.8444 | 0.0833 | 0.0581 |

20 | 0.5392 | 0.2500 | 0.7089 | 0.1269 | 0.4608 | 0.9150 | 0.0714 | 0.0707 |

24 | * | * | * | * | * | * | * | * |

28 | * | * | * | * | * | * | * | * |

32 | * | * | * | * | * | * | * | * |

36 | * | * | * | * | * | * | * | * |

40 | 0.4480 | 0.3333 | 0.8059 | 0.1159 | 0.5520 | 0.9648 | 0.1000 | 0.0980 |

44 | * | * | * | * | * | * | * | * |

48 | 0.3424 | 0.5000 | 0.9030 | 0.0898 | 0.6576 | 0.9938 | 0.1667 | 0.1571 |

52 | * | * | * | * | * | * | * | * |

56 | * | * | * | * | * | * | * | * |

60 | * | * | * | * | * | * | * | * |

64 | * | * | * | * | * | * | * | * |

68 | * | * | * | * | * | * | * | * |

72 | * | * | * | * | * | * | * | * |

76 | * | * | * | * | * | * | * | * |

80 | * | * | * | * | * | * | * | * |

84 | * | * | * | * | * | * | * | * |

88 | * | 1.0000 | 1.0000 | 0.0000 | * | * | 0.5000 | 0.0000 |

Interval Start | Lower 95% of Hazard Rate | Upper 95% of Hazard Rate | Probability Density | Standard Error of Probability Density | Lower 95% of Probability Density | Upper 95% of Probability Density | ||

0 | * | * | * | * | * | * | ||

4 | 0.0105 | 0.1458 | 0.0676 | 0.0258 | 0.0170 | 0.1182 | ||

8 | 0.0000 | 0.0616 | 0.0146 | 0.0142 | 0.0000 | 0.0423 | ||

12 | 0.0000 | 0.1252 | 0.0320 | 0.0210 | 0.0000 | 0.0731 | ||

16 | 0.0000 | 0.1972 | 0.0388 | 0.0248 | 0.0000 | 0.0873 | ||

20 | 0.0000 | 0.2100 | 0.0243 | 0.0225 | 0.0000 | 0.0683 | ||

24 | * | * | * | * | * | * | ||

28 | * | * | * | * | * | * | ||

32 | * | * | * | * | * | * | ||

36 | * | * | * | * | * | * | ||

40 | 0.0000 | 0.2920 | 0.0243 | 0.0225 | 0.0000 | 0.0683 | ||

44 | * | * | * | * | * | * | ||

48 | 0.0000 | 0.4746 | 0.0243 | 0.0225 | 0.0000 | 0.0683 | ||

52 | * | * | * | * | * | * | ||

56 | * | * | * | * | * | * | ||

60 | * | * | * | * | * | * | ||

64 | * | * | * | * | * | * | ||

68 | * | * | * | * | * | * | ||

72 | * | * | * | * | * | * | ||

76 | * | * | * | * | * | * | ||

80 | * | * | * | * | * | * | ||

84 | * | * | * | * | * | * | ||

88 | 0.5000 | 0.5000 | 0.0243 | 0.0225 | 0.0000 | 0.0683 |