I am performing a PCA to try to flush out the highly correlated variables real coefficients. I have a very large dataset but will try to simplify here. I have the formula:
lm(y~x1+x2+x3...x55) -> reg_linear_model
The issue I am having is that x1:x4 are all very highly correlated and some of them are coming in negative because of this. When I try I perform pca I get the list of components and their values. I would like to to test which components to use but the dependent Y is three years of data broken up by week so it is y1, y2, y3, y4, ....y156. 156 weeks. The issue I am having is that I cannot regress the components towards y because the lengths are different. Do I need to transform Y in some way to get it to fit into the number of rows as components? It is very hard to find an answer for this. A lot of PCR explanations just say to regress components onto y but Y is not in the pca.
Appreciate any help on this!