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