how can I calculate the Kaplan-Meier estimates in Excel pls?
 

I am looking for a way to calculate the Kaplan-Meier survival curve in Excel.
Thanks

Answer: how can I calculate the Kaplan-Meier estimates in Excel pls?
 

Calculating Kaplan-Meier Estimates in Excel

To calculate the Kaplan-Meier estimates in Excel, follow these steps:

1. Ensure that your data is in the correct format. You should have a column for the time to event and a column for the event indicator.
2. Create a table with the time points at which you want to calculate the survival probabilities.
3. Use the following formula to calculate the Kaplan-Meier estimate for each time point:
   
   
   Formula:

   ---

   =PRODUCT(1-COUNTIF(A$2:A2,A2)/COUNTIF($B$2:$B$100,0)) 


   ---

4. Copy this formula down for all the time points in your table.
5. Create a line chart with the time points on the x-axis and the Kaplan-Meier estimates on the y-axis to visualize the survival curve.

Note: "A2" is the cell containing the time point, and "$B$2:$B$100" is the range containing the event indicator column.

how can I calculate the Kaplan-Meier estimates in Excel pls?
 

I found this page that may help - has a downloadable spreadsheet, and page
has instructions for entering your own data:
http://home.comcast.net/~pstlarry/KMUsrMan.htm

"FredericAdmis" wrote:

I am looking for a way to calculate the Kaplan-Meier survival curve in Excel.
Thanks