I know the data analysis toolpak enables a stupid hardcoded correlation table to be produced, but does anybody have any ideas of how to write a formula in the cell b8 that can be dragged to fill out the table and automatically calculate the correlations of the data set.
At the moment I am manually typing in formulas to calculate correlations which is slow inefficient and tedious.
Thanks so much. File attached.
Bookmarks