## Interest Rate Modelling: Principal Component Analysis (PCA) : How to conduct a Principal Component Analysis in Excel: Solver Setup & Results

Earlier we had defined the various elements of the Principal component Analysis (PCA) process. In order to link these elements and arrive at a feasible solution we will use the Solver Function. We define target, change and constraint cells through this function and run it