Survival analysis Curve

Survival Curve

We now show how to create a step chart for the S(t) values in Example 1 of Kaplan-Meier Overview. First we copy the values in columns D and H to the range J3:K12, as shown in Figure 1. Next we put the values 1 through 9 in column L. We then copy range J5:J12 to range J13:J20 and copy range K4:L11 to K13:L20. We next sort range J3:L20 using Excel’s Data > Sort & Filter|Sort (we can then remove the values in column L since they are no longer needed). Alternatively we can use the Real Statistics QSORTRows array function to achieve the same result, as shown in range N3:O20 of Figure 1.

Figure 1 – Creating a Kaplan-Meier Curve

We can now highlight range N3:O20 and select Insert > Charts|Scatter, using the Scatter with Straight Lines and Markers option. After the usual modifications to the titles we obtain the step chart shown in Figure 2.

Figure 2 – Kaplan-Meier Curve

Also see Real Statistics Support for Kaplan-Meier for a simpler way to produce the survival curve