Skip to content

XLSTAT

Explore, visualise and model your data in Microsoft Excel

XLSTAT is a powerful and intuitive tool that is designed to help you analyse your data quickly and accurately, regardless of your level of expertise. Whether you’re an experienced data analyst or just starting out, XLSTAT has the tools and features you need to make sense of your data and make informed decisions.

So if you’re looking for reliable and easy-to-use data analysis software to help you make better business decisions, look no further than XLSTAT. Try it today and start unlocking the full potential of your data!

  • The most comprehensive statistical add-on for Microsoft Excel.
  • Compatible with both Windows and Mac.
  • Easy data preparation and processing.
  • Comprehensive data reports and customisable charts.

XLSTAT is a powerful yet flexible Excel data analysis add-on that allows 150,000+ users in over 120 countries worldwide to analyse, customise, and share results within Microsoft Excel.

Info

What is XLSTAT?

With XLSTAT, you can perform a wide range of statistical analyses, from basic descriptive statistics to advanced machine learning algorithms. You can visualise your data in various ways, including charts, graphs, and heatmaps, to better understand your data and communicate your findings to others.

Key features of XLSTAT

  • Comprehensive statistical analysis
    XLSTAT offers a wide range of statistical tools and tests, including descriptive statistics, hypothesis testing, regression analysis, time series analysis, and more. This means you can confidently analyse your data, knowing that you’re using the right methods for the job.
  • User-friendly interface
    Despite its advanced features, XLSTAT is easy to use and navigate, even for those with little or no experience in data analysis software. Its intuitive interface and user-friendly design make it accessible to users of all levels.
  • Integrated with your Microsoft Excel
    XLSTAT is seamlessly integrated with Microsoft Excel. This makes it easy to use XLSTAT alongside other Excel features, such as charts and graphs, to create more comprehensive reports.
  • Machine learning capabilities
    XLSTAT also offers machine learning algorithms, which allow you to build predictive models and uncover hidden patterns in your data. This can be especially useful for businesses looking to optimise their operations or improve their marketing strategies.
  • Affordable pricing
    Despite its advanced features, XLSTAT offers affordable pricing options for individuals, businesses, and academic institutions. This makes it a great choice for those looking to get the most bang for their buck regarding data analysis software.

News

New features in XLSTAT

The latest release of XLSTAT comes with three new features and three feature improvements that can help you save valuable time in your data analysis. The new features include the ability to view all the automatically generated graph options before making your choice and the incorporation of tornado diagrams and back-to-back histograms to help you easily improve your analysis of groups. Additionally, the update to the PROCESS feature lets you use covariables and new models and see conditional effects for deeper marketing insights.

For more information on XLSTAT’s new features and improvements, please refer to the highlights below:

Automatic Data Visualization (New feature)

Automatic Data Visualization is a feature available on Windows in Beta, Basic +, All Applied, and Premium.

With this feature, you can automatically build the right graphs for your data. You don’t have to worry about which graph to use as it will propose several graphs according to your data. Simply select your quantitative and qualitative variables in the “Dataviz” dialog box and let the feature guide you. Once you’ve chosen your graph, click on “export”.


Tornado Diagram (New feature)

This feature is available in all solutions.

With Tornado diagrams, you can quickly compare the measurements of two groups and obtain a beautiful, informative tornado chart.

Tornado graph in XLSTAT


Back-to-Back Histogram (New feature)

This feature is available in all solutions.

With Back-to-Back histograms, you can compare the distributions of two groups back-to-back.

Back-to-Back histograms in XLSTAT

PROCESS (Improved Feature)

The latest release of XLSTAT comes with an improved PROCESS feature that is available in Marketing and Premium.

With this feature, you can determine the conditional effects and use more sophisticated models with covariables to analyze mediation and moderation. Additionally, a new graph for visualizing the conditional effect of a variable on a mediator is now available.

Process model diagram in XLSTAT

Sample Size Calculation (Improved Feature)

The improved sample size calculation feature is available in Marketing and Premium.

With this feature, you can more accurately determine the right sample size required for research and ensure that you achieve the desired level of precision. Choose the standard deviation from the sample size dialogue box to do this.

Sample size dialouge box in XLSTAT

Compare XGBOOST to Other Models Easily (Improved feature)

This feature is available in Forecasting and Premium.

The latest release of XLSTAT comes with an improved feature that allows you to compare your models with XGBOOST in the Easy Fit feature. Additionally, if you’re familiar with Excel and XLSTAT formulas, you can run XGBOOST directly in an Excel cell.

Easy fit models in XLSTAT

If you have any questions, please email us at info@alfasoft.com.

Solutions

XLSTAT Solutions

XLSTAT offers a range of solutions to help you analyze your data and make informed decisions. Each solution is tailored to a specific set of needs, making it easy for you to find the right tool for the job.

XLSTAT Basic Scatter Plot

XLSTAT BASIC

EXPLORE, VISUALIZE, AND MODEL YOUR DATA IN A SINGLE INTERFACE

The Basic solution is the perfect package to get started with data analysis. It includes more than 100 key statistical tools to help you gain in-depth insights into your data. You will benefit from data preparation and visualization tools, parametric and nonparametric tests, and modelling methods, such as ANOVA, regression, and generalized linear or nonlinear models.

Variation Bar Chart

XLSTAT BASIC+

UNLIMITED ANALYTICS CAPABILITIES THANKS TO THE R-GATEWAY

In addition to the features of Basic, Basic+ provides machine learning methods (association rules, random forests, k-nearest neighbours, and more). You can also run advanced models such as partial least squares, nonlinear, or mixed regression.

Another important part of XLSTAT Basic + are the XLSTAT-R and XLSTAT-R Notebook extensions, which extend XLSTAT’s capabilities by combining Excel with R.

  • XLSTAT-R is an interface between XLSTAT and open-source R software that allows you to run your own combined R and XLSTAT procedures within the XLSTAT dialogue boxes.
  • XLSTAT-R Notebook is an interface designed to run R scripts directly in Microsoft Excel.
XLSTAT Premium Biplot

XLSTAT PREMIUM

THE MOST COMPREHENSIVE STATISTICAL TOOL IN EXCEL

The Premium solution is an advanced statistical solution that includes all 250+ XLSTAT features currently available. In XLSTAT Premium, we have integrated them all so that you can access any method at any time:

  • Basic: Widely used statistical analyses such as ANOVA, PCA, regressions, and contingency tables.
  • Basic+: Machine learning tools for regression and classification and the ability to develop your own R scripts directly in Excel.
  • Sensory: All the sensometrics tools you need and the most advanced techniques (e.g. penalty analysis, CATA data analysis, multiple factor analysis, discrimination tests, and panel analysis).
  • Marketing: Unique quantitative marketing tools like TURF analysis, conjoint analysis, Bayesian networks, MaxDiff, PLS-PM, and text mining to help you understand customer behaviour and trends.
  • Quality: Statistical process control tools, such as subgroup control or individual control charts, and design of experiments, such as screening designs.
  • Forecasting: The most accurate prevision tools in Excel, like Mann-Kendall, smoothing, ARIMA, Monte Carlo simulations (Windows only), and the Easy Fit/Easy Predict to predict future events.
  • Life Sciences: All essential methods for biologists, medical researchers, and environmental researchers – Kaplan-Meier, survival analysis, Cox model, Bland-Altman, heat maps, and ROC curves.
XLSTAT Sensory Circle Diagram

XLSTAT SENSORY

THE SOLUTION THAT GIVES YOU IN-DEPTH INSIGHTS INTO YOUR PRODUCTS AND CONSUMERS

XLSTAT Sensory is the solution for sensory data analysts who want to save valuable time by using the latest methods available. Benefit from a solution that speaks your language (products, assessors, attributes…) and provides actionable results. With XLSTAT Sensory, you can empower your R&D department to develop the right products for target audiences at a reasonable cost.

XLSTAT Sensory has tools ranging from multiple-factor analysis to product characterization and panel analysis. It is used by some of the world’s largest food and consumer goods companies.

XLSTAT Marketing Spider Plot

XLSTAT MARKETING

ESSENTIAL FOR MARKETERS WHO NEED TO UNDERSTAND CONSUMER BEHAVIOR AND TRENDS

XLSTAT Marketing is the only quantitative marketing software that combines the functionalities of Microsoft Excel with the power of the most advanced marketing statistics tools on the market.

Analyze surveys with popular correspondence analysis or use more advanced techniques such as market basket analysis, conjoint analysis, churn analysis, or partial least square path modelling. Explore the complex relationships that may exist between latent variables such as intelligence, well-being, and academic achievement with structural equation modelling using partial least squares. Techniques for analyzing multiblock data are also available.

Root cause plot

XLSTAT QUALITY

THE ONLY ADD-ON SPECIFICALLY DESIGNED FOR QUALITY CONTROL AND RISK ANALYSIS

If you are looking for a comprehensive 6 Sigma toolkit to analyze your data directly in Excel, XLSTAT Quality is for you.

The Quality solution provides a user-friendly interface to perform various analyses such as normality tests, designs of experiments, and advanced features such as subgroup and individual control charts. This allows you to improve mass production, uncover the causes of production defects, and investigate the impact of hazards through risk analysis.

XLSTAT Time-series plot

XLSTAT LIFE SCIENCES

A COMPREHENSIVE SOLUTION FOR BIOLOGISTS, MEDICAL AND ENVIRONMENTAL RESEARCHERS

XLSTAT Life Sciences is a solution specifically designed for life sciences researchers and practitioners who would like to use well-known and validated methods to analyze their data and deepen their research. Get your results in just a few clicks, without leaving MS Excel. This way, you can spend more time on what really matters: interpreting your results.

As a biologist or medical researcher, use Cox or Kaplan-Meier models for survival analysis and study the time that passes before an event occurs. Compare methods with Passing and Bablok or Bland and Altman regressions, and estimate the sample size your experiment should have with Power Analysis

Forecasting with a lag plot

XLSTAT FORECASTING

A SOLUTION THAT COMBINES THE MOST ACCURATE PREVISION TOOLS AND BUSINESS STATISTICS IN EXCEL

XLSTAT Forecasting is designed for those who want to use the most advanced analysis methods to predict sales, rainfall, and sports results, analyze stock markets or create optimized portfolios.

The Forecasting solution offers user-friendly interfaces to perform various analyses, such as smoothing methods (e.g. Holt-Winters) and more advanced features, such as ARIMA, that consider historical values, seasonality, and covariates. Quantitative financial analysts will use our cointegration feature to explore relationships between stocks. Sales managers will enjoy creating pragmatic scenarios and running simulations to get reliable forecasts for their sales.

System requirements

System requirements

Windows

  • Windows 7, 8, 10 and 11 (32-bit & 64-bit)
  • Pentium or compatible processor
  • 4 GB RAM
  • 1 GB of available hard disk space
  • Microsoft Excel 2010 SP2, 2013 SP1, 2016, 2019, 2021 or Excel from Microsoft 365.
  • XLSTAT requires VBA to be installed and activated along with Office to work properly. Please read the instructions for activating VBA here!

Mac

  • macOS 10.10 Yosemite – 10.15 Catalina, macOS 11 Big Sur and macOS 12 Monterey.
  • Intel or Apple M1 processor
  • 4 GB RAM
  • 1 GB of available hard disk space
  • Excel 2016 (16.8 or greater), 2019 (16.18 or greater), 2021, and Excel from Microsoft 365.

Licensing

XLSTAT License Options

  • Single user licenses
  • Concurrent/Floating Network (Simus)
  • Classroom, Small Campus and Large Campus license agreements (Education/Research)
  • Student licenses

Annual subscription licenses for all license options.

Support

Support

Alfasoft provides free technical support to all our customers.

When contacting our support team, please describe your problem in as much detail as possible. Remember to include your serial/licence number, product version and operating system.

We also recommend these online support pages and resources: