Customization of XLSTAT
XLSTAT customization is based on the Visual Basic language of Microsoft Excel. XLSTAT codes uses both Visual Basic and C++ codes. Visual Basic (VBA) is a powerful language that enables you to automatize and customize your XLSTAT analysis quickly. Most of the statistical functions available in XLSTAT can be called directly from the Visual Basic window.
It is then relatively easy for you to adjust XLSTAT to the specificity of your domain by adding tables and plots as well as modifying existing outputs. Furthermore, XLSTAT includes a tool on every dialog box to generate VBA code in order to reproduce your analysis using the VBA editor. You can watch a video about customizing XLStat.
In addition, Addinsoft can create a tailored Excel add-in to fit your analytical business needs. Addinsoft has successfully developed tailor-made statistical software solution for some of the largest companies in the petroleum, food, chemical, financial and pharmaceutical industries.Contact us for details.
Automate routine analysis
In XLSTAT you have two options to save time on your analysis: you can save the settings of a dialog box to be reused later on, or you can also generate the VBA code of a dialog box and execute it on a new dataset from the VBA editor of Microsoft Excel.We have prepared tutorials that will help you to learn using these features.
- Save and reuse settings of an analysis, example of Principal Component Analysis
- Automate a routine analysis, example of Principal Component Analysis, in XLSTAT
Customize XLSTAT yourself
Using the Visual Basic language, customizing your outputs in order to fit to the specificity of your domain becomes easy. For example, if you want to automatize many Principal Component Analysis on different groups of variables, you can do it using XLSTAT and VBA and launch it in just one click.
You can also create your own application combining the power of VBA and XLSTAT.
To help you in doing so we have prepared some examples for the most common XLSTAT functions. They are available in the table below.
|Programming with XLSTAT and VBA||PDF1.25 MB|
|VBA code for running an ANCOVA||XLS33.0 KB|
|VBA code for running an ANOVA||XLS32.5 KB|
|VBA code for running an ARIMA||XLS32.0 KB|
|VBA code for running a Correspondence Analysis||XLS18.0 KB|
|VBA code for running a Distribution Fitting||XLS23.0 KB|
|VBA code for running a classification k-means||XLS19.5 KB|
|VBA code for running a classification k-means and a AHC||XLS37.0 KB|
|VBA code for running a classification k-means and parallel plots||XLS105 KB|
|VBA code for running Multidimensional scaling||XLS23.0 KB|
|VBA code for running nonlinear regression||XLS47.0 KB|
|VBA code for running PCA||XLS20.0 KB|
|VBA code for running PLS||XLS34.0 KB|
|VBA code for plotting a scatter plot||XLS48.0 KB|
|VBA code for running a distribution sampling||XLS28.0 KB|
|VBA code for running a Kaplan-Meier Analysis||XLS29.0 KB|
|VBA code for running a Cox proportional hazard regression||XLS35.5 KB|