#### Survival Analysis in Excel

Survival analysis is a statistical technique used to analyze the time until an event of interest occurs.

While Excel may not have dedicated survival analysis functions, you can perform basic survival analysis by using its features. Below is a guide on how to conduct survival analysis in Excel:

## Data Preparation

1. Organize your data in Excel with columns for event times (time to an event or failure) and event indicators (1 if the event occurred, 0 if it did not). Include any relevant covariates (independent variables).

## Calculate Survival Function

2. Calculate the survival function, denoted as S(t), which represents the probability of surviving beyond time t. You can use Excel’s functions to compute survival probabilities based on your data. For example:

=PRODUCT(1-\$B\$2:\$B\$100*(A2>A\$2:A\$100))

Drag this formula down to calculate survival probabilities for different time points.

## Create Kaplan-Meier Survival Curves

3. Visualize your survival data by creating Kaplan-Meier survival curves. Plot time on the x-axis and S(t) on the y-axis using Excel’s charting tools.

## Perform Log-Rank Test

4. If you have multiple groups and want to compare survival curves, use the log-rank test:

• Calculate observed and expected events in each group.
• Compute the test statistic, which measures the difference between the observed and expected events.
• Use Excel functions or custom formulas to perform the test.