HLTH 501
EXCEL EXERCISE MODULE/WEEK 8
Refer to the Survival Graph and Survival Analysis tabs in the Excel Assigment spresdsheet.
Move your mouse over the blue diamonds to read their exact values.
What percent of participants are assumed alive after 5 months? __84.44%__ 2 pt
How many patients started the study at time zero? __20___2 pt
What does it mean when a patient is censored? __contact with the patient was lost so
information on the patient’s survival is unavailable___2 pt
True/False. There is a blue diamond at t = 2 to denote that contact was lost with a participant.
__True___2 pt
Why is there no time 4 on the Survival Graph? __Because there was no event (death or
censoring of patient) recorded in time 4 period __2 pt
True/False. The relatively long period between 5 months and 13 months where the survival rate
stayed level was really a result of six patients being censored. _ True ___2 pt
How many patients actually died during the 24 months of the study? __6 patients___ 2 pt
How many patients stayed in contact with researchers and were alive until month 24?
_3 patients_2 pt
How many patients’ were lost to contact? ___11 patients___2 pts
What is the worst case survival rate after 24 months, assuming all the patients censored ended up
dying? What is the best case survival rate after 24 months? __Worst Survival Rate: 3/20 = 15%
Best Survival Rate: 14/20 = 70% _ 2 pt
Page 1 of 1
