Survival distribution function chart

[max0d]

Is anyone familiar with the Kaplan-Meier estimator, and if there is a
way I can get excel to draw a traditional survivior curve? The charts
on this page http://www.xlstat.com/demoKM.xls are the style that I
would like to produce. However, these appear to have been produced
using an add-on called XLstat Pro. I am attempting to produce a
spreadsheet to analyse various statistical models which are all reliant
on producing a survivor curve in this style. Any help anyone could
offer me would be gratefully received as I have spent days trying and
can not find a way of doing this.

 

[Jon Peltier]

If you know the formulas for the values (I didn't download the Excel workbook), you
can set up a helper column with the transformed values you need to plot to make the
chart look right. This example might help you step out of the box; it's a
probability chart, in which I've used Excel's statistics functions to compute the Y
values for the chart, and a fake axis to display the corresponding probabilities
along the Y axis:

http://peltiertech.com/Excel/Charts/ProbabilityChart.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______