Run PCA in Excel
To run a PCA in excel, do the following:
1. Open this âFactorsâ excel file and enable the file
2. Open your data file you want to run the PCA on (itâs important you open and enable the âFactorsâ file first, before you open your data file.
3. Click âadd-insâ option in your data file and select âprinicpal components.â Follow/complete the dialogue box and run. When complete, you will have sheets with eigen values, loadings, rotated loadings, etc. for your output.













