# XLSTAT version 2019.2

## Discover our latest features and options

A. Included in all XLSTAT solutions

• Data analysis on Excel filtered dataIt is now possible to perform XLSTAT analyses on filtered data. Once you have filtered your data in an Excel spreadsheet, simply select the feature from the XLSTAT menu and run the analysis. This option is currently available in most of the essential XLSTAT features (e.g. ANOVA, Histograms, Normality tests, PCA, etc) plus  a few advanced features (e.g. Conjoint analysis, Mann-Kendall, Random forest, etc). A tutorial is available here.

• Probability Calculator: This tool allows you to compute for a given distribution function, the density function, the cumulative distribution function or the inverse cumulative distribution function. It is useful for determining the probability of a random event (for example, the occurrence of a 2 when throwing a die or the arrival of 3 customers to a shop within an hour). This new feature can be found under the Mathematical Tools XLSTAT menu. A tutorial is available here.

• Nonlinear Regression: You can now carry out an analysis by groups. The curves of each group are displayed in a single graph. Global fit with shared settings has been added in order to adjust several curves at the same time, and to calculate for each shared parameter an overall optimal value applying to each of the groups. Finally, power functions are now available in the predefined functions. Accessible under the Modeling data menu. A tutorial is available here

• Stepwise Cox Regression: Select the best variables for your Cox model using a stepwise procedure. Accessible under the XLSTAT-R menu.

B. Included in XLSTAT-Sensory, Marketing and Premium

• TCATA: A new feature for analyzing temporal check-all-that-apply (TCATA) data. This dynamic method allows users (assessors) to select and update the attributes that characterize products as they evolve over time. An example of how to run a TCATA analysis is available here. Available under the Sensory data analysis XLSTAT menu.

• CATATIS: A new feature for processing CATA data in order to study the links between products and attributes and investigate the agreements between assessors. The benefit of CATATIS, compared to the usual method for CATA data, is that atypical assessors have a lower weight than those who agree with the rest of the panel. An example of how to run a CATATIS analysis is available here. This tool is available under the Sensory data analysis XLSTAT menu.

## How to get XLSTAT 2019.2?

If you are currently using our trial version or you have a valid license, you can download this version at:

If you have a perpetual license, but no longer have access to upgrades and maintenance, you can order an upgrade through your MyXLSTAT portal or contact our sales team.

### Analysis of Variance for Sensory & Consumer Tests – Beyond the Basics, December 3, 2020

This module focuses on Analysis of Variance, but this technique makes assumptions about the underlying distributions in our data

### Making Sense of Multivariate Data using XLSTAT, November 10th, 11th, 17th and 19th, 2020

This course covers the excellent features in XLSTAT for investigating, visualising and modelling data sets with measurements on many variables.

### Preference Mapping using XLSTAT, June 25th, 2020

This short course delivered online will show consumer scientists how to set up and learn about the routines available in XLSTAT for relating consumer acceptability to sensory/analytic measures.

### Últimos tweets

🔎 Are you new to #XLSTAT? 🧑🏼‍💻 Start your learning experience now with our new My Assistant interface! This helpfu… https://t.co/QrTF7EUvVm

🗓️ One week to go until the 52nd annual @DSIHomeOffice conference We will be showcasing a decision tree applicatio… https://t.co/igmtqiRASs

💡 Tip of the day Have you ever found yourself with too many variables to handle? Need an alternative to Linear Regr… https://t.co/6nee5dGqph