RV coefficient test in Excel tutorial

This tutorial will help you compute and interpret RV coefficients used to test the association between two matrices, in Excel using XLSTAT.

Dataset to run an RV coefficient test in XLSTAT

An Excel sheet containing both the data and the results for use in this tutorial can be downloaded by clicking here.

The data used in this example correspond to a study where 12 cranberry juices have been evaluated by two sensory panels. 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.

Goal of this tutorial

The aim of this tutorial is to evaluate how similar the information gathered by the two PCAs are.

Setting up an RV coefficient test in XLSTAT

After opening XLSTAT, click on Test a hypothesis / Correlation/Association tests / RV coefficients.

RV correlation menu

In the General tab, select the first quantitative dataset (only the variables) in the Matrix A data field. Then, in the Matrix B data field, select the second dataset. 

 RV coefficient dialog box

In the Options tab, select the User defined option for the Selected Variables and enter 1 in the from field and 5 in the to field. 

RV dialog box options tab

Click the OK button and the Continue button in the following dialog box.

Interpreting the results of a RV coefficient test in XLSTAT

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. 

RV result 1

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 allow to visualize 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).

RV result 2

Click here for other tutorials.

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