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.

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

 

About KCS

Kovach Computing Services (KCS) was founded in 1993 by Dr. Warren Kovach. The company specializes in the development and marketing of inexpensive and easy-to-use statistical software for scientists, as well as in data analysis consulting.

Mailing list Join our mailing list

Home | Order | MVSP | Oriana | XLStat
QDA Miner | Accent Composer | Stats Books
Stats Links | Anglesey

Share: FacebookFacebook TwitterTwitter RedditReddit
Del.icio.usDel.icio.us Stumble UponStumble Upon

 

Like us on Facebook

Get in Touch

  • Email:
    sales@kovcomp.com
  • Address:
    85 Nant y Felin
    Pentraeth, Isle of Anglesey
    LL75 8UY
    United Kingdom
  • Phone:
    (UK): 01248-450414
    (Intl.): +44-1248-450414