Running a sensory shelf life analysis with XLSTAT-MX

An Excel workbook with both the data and the results can be downloaded by clicking here.

The data used in this tutorial correspond to the evaluation of a fresh fruit juice by 19 assessors at different times. The juices have been tested 6 times at day 1, 2, 3, 4, 5 and 6. The assessors have given their liking (yes/no) for all these times. In the data, the assessors' evaluations are coded using 0 when the evaluation is negative and 1 when it is positive. Here is the data format:

data sensory shelf life

You can change the value (0/1) to any other value in XLSTAT-MX (yes/no for example).

Goal of the sensory shelf life analysis

The goal of this analysis is to visualize the best period to put a product in a shelf for selling it. Parametric survival models are used to model the time.

Setting up a panel analysis

Once XLSTAT is activated, select the XLSTAT-MX / Sensory Shelf Life Analysis command (see below), or click the corresponding button of the XLSTAT-MX toolbar.

menu sensory shelf life

Once you have clicked on the button, the dialog box appears. Select the assessor x date table as presented above and a column with the value associated to each date in the time data box. We use the Weibull distribution to fit the model.

dialog box sensory shelf life general

Other options are left with their default values.

Interpreting the results of a sensory shelf life analysis

After you have clicked on the OK button, the computations start.

The first table corresponds to basic summary statistics associated to the time data. A graphic is also displayed giving an overview of the answers of the assessors.

sensory shelf life date statistics

sensory shelf life preference plot

This plot shows a decrease in the number of assessors that appreciate the orange juice. At the end of the analysis, only 4 assessors still like the product.

The tables displayed afterward are similar to those displayed in a parametric survival curve. A Weibull curve is fitted to the model. We can see that both parameters are significant.

sensory shelf life parameters

The preference distribution function plot based on a Weibull distribution is as follows :

sensory shelf life preference distribution plot

Finally, the quantiles are obtained and are very useful for decision making.

sensory shelf life quantiles

We can see that median time is between 4 and 5 days after the product has been putted in the shelf.

Many more analysis and decisions can be taken with sensory shelf. Explanatory variables associated to each assessor can be added.

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


Like us on Facebook Facebook

Get in Touch

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