For the following hypothetical data construct the table that will have all the n
ID: 3134036 • Letter: F
Question
For the following hypothetical data construct the table that will have all the necessary columns to produce Kaplan Meir method for survivor function. Do not use SAS to produce KM but can use Excel to produce the calculations. The columns should include those at risk of the event at each time point, those who have the event/censored, the hazard and the survivor functions. Use the same above data to construct the table that will have all the necessary columns to produce the Life Table (LT) method for survivor function. Do not use SAS to produce LT but can use Excel to produce the calculations. Use a reasonable interval width to partition observation time. The columns should include those at risk of the event at each time point, those who have the event/censored, the hazard and the survivor functions. For each of the above methods, use Excel or any other plotting mechanism to plot survivor and hazard functions for each method.Explanation / Answer
1.
Time Number of event(s) censored, d Events at the start of the day, n Estimated Probability Censored, d/n Survival, 1 - (d/n) 1 2 19 0.1053 0.8947 2 1 17 0.0588 0.9412 3 1 16 0.0625 0.9375 4 1 15 0.0667 0.9333 6 1 14 0.0714 0.9286 8 1 13 0.0769 0.9231 9 1 12 0.0833 0.9167 12 1 11 0.0909 0.9091 14 1 10 0.1000 0.9000 20 1 9 0.1111 0.8889