Running a Weibull model (parametric survival regression) with XLSTAT-Life
Dataset for Parametric survival regression (Weibull model) XLS190 KB
Easy and user-friendly
Easy and user-friendly XLSTAT is flawlessly integrated with Microsoft Excel which is the most popular spreadsheet worldwide. This integration makes it one of the simplest available tools to work with as it utilizes the same philosophy as Microsoft Excel. The program is accessible in a dedicated XLSTAT tab. The analyses are grouped into functional menus. The dialog boxes are user-friendly and setting up an analysis is straightforward.
Data and results shared seamlessly
Data and results shared seamlessly One of the greatest advantages of XLSTAT is the way you can share data and results seamlessly. As the results are stored in Microsoft Excel, anyone can access them. There is no need for the receiver to have an XLSTAT license or any additional viewer which makes your team-work easier and more affordable. In addition, results are easily integrable into other Microsoft Office software such as PowerPoint, so that you can create striking presentation in minutes.
Modular XLSTAT is a modular product. XLSTAT-Pro is a core statistical module of XLSTAT which includes all the mainstream functionalities in statistics and multivariate analysis. More advanced features contained in add-on modules can be added for specific applications. This way you can adapt the software to your needs making the software more cost-efficient.
Didactic The results of XLSTAT are organized by analysis and are easy to navigate. Moreover useful information is provided along with the results to assist you in your interpretation.
Affordable XLSTAT is a complete and modular analytical solution that can suit any analytical business needs. It is very reasonably priced so that the return of your investment is almost immediate. Any XLSTAT license comes with top level support and assistance.
Accessible - Available in many languages
Accessible - Available in many languages We have ensured XLSTAT is accessible to everyone by making the program available in many languages, including Chinese, English, French, German, Italian, Japanese, Polish, Portuguese and Spanish.
Automatable and customizable
Automatable and customizable Most of the statistical functions available in XLSTAT can be called directly from the Visual Basic window of Microsoft Excel. They can be modified and integrated to more code to fit to the specificity of your domain. Adding tables and plots as well as modifying existing outputs becomes easy. Furthermore, XLSTAT includes some special tools on the dialog boxes to generate automatically the VBA code in order to reproduce your analysis using the VBA editor or to simply load pre-set settings. This effortless automation of routine analysis will be a huge time saver on your part.
Dataset to run a Weibull model
An Excel sheet with both the data and results can be downloaded by clicking here.
The data have been obtained in Kalbfleisch and Prentice (The Statistical Analysis of Failure Time Data, Wiley, 2002, p. 119) and represent a clinical trial investigating the effect of covariates on time to death of patients with lung cancer. Our goal is to determine which covariate influences the survival time.
Parametric survival model (Weibull model)
The parametric survival model is based on a classical regression scheme with an underlying distribuion function. The estimation of the model is performed with a maximum likelihood estimation.
In the dataset, the daysurv variable is the time data; the censoring variable is the status variable (1 for death, 0 for censored). The covariates are the performance status of the patient at the beginning of the study (perfstatus), the age of the patient at the beginning of the study (age), the number of month since lung cancer diagnostic at the beginning of the study (month) and the presence of an earlier treatment.
We suppose that the survival function follows a Weibull distribution and want to fit that model.
Setting up a Weibull model
After opening XLSTAT, select the XLSTAT / XLSTAT-Life / Parametric survival regression command, or click on the corresponding button of the XLSTAT-Life toolbar (see below).
Once you've clicked on the button, the Parametric survival regression box will appear. Select the data on the Excel sheet. The Time data corresponds to the durations when the patients either died or were censored. The "Status indicator" describes whether a patient died (event code=1) or was censored (censored code = 0) at a given time.
The covariates are all quantitative and can be selected in the quantitative box. The distribution chosen is the Weibull distribution.
Other options can be selected on the other tabs of the dialog box like individual residuals computation, model selection...
The computations begin once you have clicked on OK. The results will then be displayed on a new Excel sheet.
Interpreting the results of a parametric survival model
The first table displays a summary of the data. We can see that the number of observed times (time steps) is different than the number of observations.
The next table gives several indicators of the quality of the model (or goodness of fit). These results are equivalent to the R2 and to the analysis of variance table in linear regression. The most important value to look at is the probability of Chi-square test on the log ratio. This is equivalent to the Fisher's F test: we try to evaluate if the variables bring significant information by comparing the model as it is defined with a simpler model with no impact of the covariates. In this case, as the probability is lower than 0.0001, we can conclude that significant information is brought by the variables.
The following table gives details on the model. This table is helpful in understanding the effect of the various variables and parameters of the Weibull distribution.
On this table we can see that the intercept and scale parameters have a significant effect. The model fits well to a Weibull distribution. The explanatory variables do not have a significant effect on the model.
Finally, the cumulative survival function is displayed with both empirical values and theoretical values. We can see that the Weibull distribution seems to be a good choice to fit this regression model.
This study has shown that the Weibull distribution seems to be a good choice and the estimated values fit well the theoretical values (when all covariates are at their mean value).