Search research articles

ABOUT JoVE

Overview Leadership Blog JoVE Help Center

AUTHORS

Publishing Process Editorial Board Scope & Policies Peer Review FAQ Submit

LIBRARIANS

Testimonials Subscriptions Access Resources Library Advisory Board FAQ

RESEARCH

JoVE Journal Methods Collections JoVE Encyclopedia of Experiments Archive

EDUCATION

JoVE Core JoVE Business JoVE Science Education JoVE Lab Manual Faculty Resource Center Faculty Site

Terms & Conditions of Use

Search research articles

Related Experiment Videos

Confirmatory factor analysis using Microsoft Excel.

Jeremy N V Miles¹

¹Department of Health Sciences (Area 4), University of York, York YO10 5DD, England. jnvm1@york.ac.uk

Behavior Research Methods

|April 25, 2006

Summary

This article demonstrates how to perform confirmatory factor analysis (CFA) using Microsoft Excel. It simplifies this complex statistical technique, making it accessible without advanced programming skills.

Related Concept Videos

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by

Same author

Does competitive winning increase subsequent cheating?

Royal Society open science·2022

Same author

Evidence map of ductal carcinoma in situ management options.

Menopause (New York, N.Y.)·2019

Same author

Predictors of Retention in an Alcohol and Risky Sex Prevention Program for Homeless Young Adults.

Prevention science : the official journal of the Society for Prevention Research·2018

Same author

Optimizing Variance-Bias Trade-off in the TWANG Package for Estimation of Propensity Scores.

Health services & outcomes research methodology·2017

Same author

The Air Force Deployment Transition Center: Assessment of Program Structure, Process, and Outcomes.

Rand health quarterly·2017

Same author

Individual, peer, and family factor modification of neighborhood-level effects on adolescent alcohol, cigarette, e-cigarette, and marijuana use.

Drug and alcohol dependence·2017

Area of Science:

Psychometrics
Statistical Software Applications
Educational Technology

Background:

Confirmatory Factor Analysis (CFA) is a complex statistical technique often perceived as difficult to understand.
Traditional teaching methods for CFA may lack detailed explanations of underlying calculations and mechanisms.
Limited accessibility to advanced statistical software can be a barrier for some researchers and students.

Purpose of the Study:

To present a practical method for conducting Confirmatory Factor Analysis (CFA) using Microsoft Excel.
To demystify CFA by illustrating its fundamental calculations through a spreadsheet-based approach.
To enable individuals with limited programming experience to perform and understand CFA.

Main Methods:

Developing a Microsoft Excel spreadsheet designed to execute simple Confirmatory Factor Analysis (CFA).
Structuring the spreadsheet to clearly display the steps and calculations involved in CFA.
Utilizing built-in Excel functions and formulas to replicate CFA procedures.

Main Results:

A functional MS Excel spreadsheet capable of performing basic CFA was successfully created.
The spreadsheet provides a transparent view of the computational processes underlying CFA.
The method allows for the generation of interpretable CFA results directly within Excel.

Conclusions:

Microsoft Excel can be effectively utilized as a tool for teaching and performing basic Confirmatory Factor Analysis (CFA).
This approach enhances the accessibility and understanding of CFA for a wider audience.
The spreadsheet method empowers users with minimal programming skills to gain practical insights into CFA.

Related Experiment Videos