I would like to compute correlation matrices (using CORRELATE) for each group in a worksheet. The correlation matrices should be by group (5,6,7,12,13, or 14) on columns D - H. Ideally the new sheet would be named with at least the group number.
I have attached an example output for group 5. I also included a screen cast with an example worksheet of how I would do this in a non automated way.
I am looking for an automated way to do this (i.e. macro, formula). Annotation always appreciated.
Thank you kindly,