Table 2: Content of survival data in Excel® worksheets.
|
Categories |
Content |
|
Title (top of page) |
Description of data set or subset and years of inclusion |
|
Interval month (Column A) |
Consecutive number by months from date of diagnosis |
|
Alive in month (Column B) |
Number of patients known to be alive at the start of this month |
|
Dead in month (Column C) |
Number of patients known to have died during that month |
|
Last seen in month (Column D) |
Number of patients known to still be alive as of that month, but no subsequent follow up information |
|
Exposed to Risk (Column E) |
Computer calculation based on previous 3 columns for calculation used in actuarial survival figure |
|
Proportion Dying (Column F) |
Column C divided by Column B |
|
Proportion Surviving (Column G) |
Column B minus Column D, divided by Column B |
|
Proportion at end of interval (Column H) |
Calculation of the Kaplan-Meir statistic for overall survival (all-cause mortality) |
|
Proportion relative survival (Column I)
|
Adjusted calculation of Column H to produce the relative survival statistic (adjusted for competing causes of death based on age and gender of those dying in the interval compared to expected rates for year in use. |