XLSTAT: Calculating an RV Coefficient in Excel

This tutorial will help you compute and interpret RV coefficients used to test the association between two matrices, in Excel using XLSTAT. Not sure this is the statistical test you are looking for? Check out this Statistical Test Guide.

Dataset for Example

The data used in this example correspond to a study where 12 cranberry juices have been evaluated by two sensory panels. See the attached file.

Each panel evaluated the product with their own lexicon. Panel FR used 6 attributes and panel CA used 7 attributes. Data were analyzed by mean of PCA. 

The RV Coefficient test will help us evaluate the similarity between the results obtained.

Setting Up

• Open XLSTAT.
• Click on the Correlation/Association tests menu and select the RV coefficients feature:

In the General tab:

• In the Matrix A data field, select the first quantitative dataset (only the variables) .
• In the Matrix B data field, select the second dataset.

In the Options tab:

• Select the User defined option for the Selected Variables
• Enter 1 in the from field and 5 in the to field.

• Click on the OK button to launch the computations.
• The results are displayed on a new Excel sheet.

Interpreting the Results

A table displays the RV coefficients for the series of dimensions chosen, i.e. the first variable, the two first variables, the three first variables, etc.

Together with the RV coefficients XLSTAT displays the adjusted RV coefficients, the standardized RV coefficients, the mean and the variance of the RV coefficient distribution and the corresponding p-values.

The closer the RV coefficient to 1, the more similar the matrices. The lower the p-value, the more different from 0 the RV coefficient.

A bar chart allows visualizing the RV coefficients. The color code allows to quickly check if the RV coefficients are significantly different from 0 or not and at what significance level (0.001, 0.01 or 0.05).