Suppose I have 5 variables that I hope will predict, or at least correlate with a sixth and seventh.
1) I want to find out how to weight them.
2) But also, I suspect that some of the variables might “weigh” more when other variables are high or low.
3) In addition some of the variables may have a predictive lead that is more or less (in time) than the others.
I have an idea how to go about doing it in a tedious fashion in excel, but does anyone know of any software or plugins that do all…