算不了 用手算 公式很简单

SPSS，STATA或MPLUS等软件都不提供AVE的计算。
根据AVE的计算公式，在EXCEL里可以方便计算。
同样，CR的计算也不在软件包里。在EXCEL里可以连同AVE一并实现。

There's no provision of AVE in SPSS, but you can calculate it manually:
1. Run EFA and note the factor loading of statements in every factor.
2. Take average of these factor loadings and square it. This is AVE

In a paper published in the Journal of Marketing Research in 1981, a group of statisticians introduced the concept of Average Variance Extracted, a statistic that states how much variance captured by the latent variable in a structural equation model is shared among other variables. The calculation of Average Variance Extracted requires a structural equation model to already exist, since it needs the loadings of the indicators for the latent variable for which it is to be calculated.
Sponsored Link
Calculator
Calculators: Different Calculators For Every Situation - Free!
calculator.utilitychest.com
Step 1
List the statistics that will be used for the Average Variance Extracted computation. The statistics needed are the loadings for the indicators on the latent variable of interest, the variance of the latent variable and the variances of the measurement errors for all of the indicators. These statistics should all come directly from your structural equation model.
Step 2
Compute the sum of squares for the indicators loading on the latent variable. List the loadings. Square these loadings. Sum the resulting numbers. Call this value "SSI."
Step 3
Sum the variances of the measurement errors. Call this value "SVe."
Step 4
Compute the denominator for the Average Variance Extracted. Multiply "SSI" by the variance of the latent variable. Add "SVe" to the result. Call this value "Denom."
Step 5
Compute the numerator for the Average Variance Extracted. Multiply "SSI" by the variance of the latent variable. Call this result "Numer."
Step 6
Calculate the Average Variance Extracted. Divide "Numer" by "Denom." The result will be a number between zero and one. This is the Average Variance Extracted.

xiexie