In the Tools tab, select Excel Add-Ins ; Figure 3. Excel Add-Ins option in menu. In the Add-ins window, select Analysis Toolpak and click OK. Figure 4. Add-ins window. We have successfully loaded the Analysis Toolpak. Click the Data tab > Data Analysis command to see that the Data Analysis tools are now activated. Figure 5. Output: Load the Analysis Toolpak in Mac. Note: If the Analysis Toolpak is not available in the list of Add-Ins, click Browse to find it.
Principal component analysis (PCA) is the process of computing the principal components and using them to perform a change of basis on the data, sometimes using only the first few principal components and ignoring the rest. PCA is used in exploratory data analysis and for making predictive models.