How to calculate Average Variance Extracted and Composite Reliability

  1. Download the excel file and open it on your device.

  2. Select the number of available indicators (see figure below). For example, we have four items or indicators measuring perceived quality of information in Wikipedia (Qu1, Qu2, Qu3 and Qu5), so we selected 4 indicators as shown below.

  1. Copy your factor loadings and paste them in the corresponding cell.
  1. Record your AVE and CR

  2. Repeat this process for all your constructs.

Note: Each construct must have an AVE and a CR

The table below shows the output for the AVE and CR of our study

Did you find this page helpful? Consider sharing it 🙌