how to make a survivorship curve on excel

Step-by-Step Guide: Create Survival Analysis Curve in Excel

By Rachel Moore
AD

Crafting a survivorship curve can be a powerful tool to visualize and understand patient data, especially in the field of cancer research and epidemiology. Microsoft Excel, with its robust data analysis capabilities, is an excellent choice for creating such a curve. Let's delve into a step-by-step guide on how to make a survivorship curve on Excel.

Before we begin, ensure you have a dataset with at least three columnas: 'Time', 'Censored' (1 for dead, 0 for alive), and the subject or 'ID' numbers. For this guide, let's assume you have a dataset like this, with years of follow-up as 'Time'.

Preparing Your Data

Before creating the curve, you need to adjust your data to the right format. Here's how:

AD
a graph shows the time and temperature for different types of plants
a graph shows the time and temperature for different types of plants
an animal and other animals are shown in the diagram, which is labeled as type i
an animal and other animals are shown in the diagram, which is labeled as type i
How to Create a Scoring System in Excel (With Easy Steps) - ExcelDemy
How to Create a Scoring System in Excel (With Easy Steps) - ExcelDemy

First, sort your data by 'Time' in ascending order. This will ensure that your data is sequenced chronologically.

Creating a Kaplan-Meier Estimate

Excel's built-in KUT function can generate the Kaplan-Meier estimate, a crucial element for survivorship curves. Here's how to use it:

How to Make a Progress Monitoring Chart in Excel - 2 Steps - ExcelDemy
How to Make a Progress Monitoring Chart in Excel - 2 Steps - ExcelDemy
How to Reverse Score in Excel (4 Easy Ways) - ExcelDemy
How to Reverse Score in Excel (4 Easy Ways) - ExcelDemy

In a new column, type the formula `=KUT(B3:B99,C2:C99)`, replacing the ranges with your dataset. This will calculate the cumulative survival rate for each 'Time' interval.

Creating a Column for Group Sizes

To calculate the number of subjects at risk at each time interval, follow these steps:

AD

In a new column, use the formula `=MAX($A$2:$A2)-COUNTIF($C$2:$C2,$A2)`, replacing 'A' with your 'ID' column, and 'C' with your 'Censored' column. This will give you the number of subjects at risk.

Plotting the Survivorship Curve

Now that you have your survival rates and group sizes, it's time to plot the curve.

Select your 'Time' and survival rate columns, then insert a scatter plot (X Y Scatter with Smooth Lines). Excel should automatically create your curve based on these data points.

AD

Styling Your Graph

You can now customize your graph. Change the title to something like "Survivorship Curve: Our Sample Group", and adjust the axes to have relevant labels.

Add a trendline (with linking values) and change its color and style for better visibility. Voila! Your survivorship curve is now ready to provide insights into your patient data.

Remember, survivorship curves can be a rich source of information, revealing patterns and trends that might otherwise go unnoticed. With your newfound skill in creating these curves, you're equipped to analyze and interpret data more effectively, driving better conclusions and decisions.

AD
AD