Customization of XLSTAT Tailored statistical module
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.
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.
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 a Getting started series on advanced techniques to save time as well as tutorials that will help you to learn using these features.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 | XLS42.5 KB |
| VBA code for running an ANOVA | XLS36.0 KB |
| VBA code for running an ARIMA | XLS32.0 KB |
| VBA code for running a Correspondence Analysis | XLS19.0 KB |
| VBA code for running a Distribution Fitting | XLS23.5 KB |
| VBA code for running a classification k-means | XLS27.0 KB |
| VBA code for running a classification k-means and a AHC | XLS55.0 KB |
| VBA code for running a classification k-means and parallel plots | XLS118 KB |
| VBA code for running Multidimensional scaling | XLS25.5 KB |
| VBA code for running nonlinear regression | XLS50.0 KB |
| VBA code for running PCA | XLS24.0 KB |
| VBA code for running PLS | XLS40.5 KB |
| VBA code for plotting a scatter plot | XLS56.5 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 |
Order a tailored-made application
If you have a development project that requires both interfaces with Microsoft Excel and statistical methods, don’t hesitate to contact us. Addinsoft has successful experiences in creating fitted solution for various applications. Simply provide us with a brief description of your project, and we will be pleased to give you a basic evaluation of timeframes and fees.