Kaplan-Meier Curves in Excel

Clinical studies often use Kaplan-Meier (aka survival) curves to show the proportion of patients that have survived after a certain period of time.  There are a several articles that show you how to do the math:

Unfortunately, Excel does not include a function to graph Kaplan-Meier curves.  You have to reformat the data to be able to create survival curves in Excel.  Check out SCEW, an Excel add-in that allows you to create Kaplan-Meier curves.  You do not have to download the add-in if you’re willing to manually type in the spreadsheet formulas that reformats the data (see Appendix A).  Once you have reformatted the data, you can use the scatter graph function to create the Kaplan-Meier curve.  For your convenience, I have created an Excel spreadsheet on Scribd that you can use.

Update: I realized that downloading from Scribd can be inconvenient, so I’ve included a link to the Excel file on Google Drive. For the more daring, try graphing Kaplan-Meier curves with R.

Advertisements
Tagged , ,

One thought on “Kaplan-Meier Curves in Excel

  1. […] spreadsheet programs) are powerful, they are not really suited for survival analysis. For example, graphing Kaplan-Meier curves with Excel is less than ideal. Survival analysis will often require a statistical software package, like […]

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: