Miles Jeremy N V
Department of Health Sciences (Area 4), University of York, York YO10 5DD, England.
Behav Res Methods. 2005 Nov;37(4):672-6. doi: 10.3758/bf03192739.
This article presents a method for using Microsoft (MS) Excel for confirmatory factor analysis (CFA). CFA is often seen as an impenetrable technique, and thus, when it is taught, there is frequently little explanation of the mechanisms or underlying calculations. The aim of this article is to demonstrate that this is not the case; it is relatively straightforward to produce a spreadsheet in MS Excel that can carry out simple CFA. It is possible, with few or no programming skills, to effectively program a CFA analysis and, thus, to gain insight into the workings of the procedure.
本文介绍了一种使用微软（MS）Excel进行验证性因子分析（CFA）的方法。CFA常常被视为一种难以理解的技术，因此在教授这一技术时，对于其机制或基础计算往往很少进行解释。本文的目的是证明情况并非如此；在MS Excel中制作一个能够执行简单CFA的电子表格相对简单。只需具备很少的编程技能或无需编程技能，就有可能有效地编写CFA分析程序，从而深入了解该程序的运作方式。
