Good day,
I have a data set with roughly 250,000 rows with 147 distinct attribute labels and 1 data point per row. I'd like to run the same attributes across the vertical and horizontal axes of my pivot table (easy to do by just mirroring the attribute labels in 2 different columns) and have the data field show the correlation coefficient of the 147 attributes against each other. So, for example, if I had the following attribute labels in the pivot table results the data would show the correlation coefficient of all values of data set AB against itself (=1.0), AB to CD and AB to EF. I want it in a pivot table so that an end user can dynamically filter several other variables and easily select alternative attributes for comparison. Is this possible in Excel 2010?
| AB | CD | EF |
AB |1.0 | 0.5 |0.4|
CD |0.5| 1.0| 0.2|
EF | 0.4| 0.2| 1.0|
Thanks in advance,
Jeff
I have a data set with roughly 250,000 rows with 147 distinct attribute labels and 1 data point per row. I'd like to run the same attributes across the vertical and horizontal axes of my pivot table (easy to do by just mirroring the attribute labels in 2 different columns) and have the data field show the correlation coefficient of the 147 attributes against each other. So, for example, if I had the following attribute labels in the pivot table results the data would show the correlation coefficient of all values of data set AB against itself (=1.0), AB to CD and AB to EF. I want it in a pivot table so that an end user can dynamically filter several other variables and easily select alternative attributes for comparison. Is this possible in Excel 2010?
| AB | CD | EF |
AB |1.0 | 0.5 |0.4|
CD |0.5| 1.0| 0.2|
EF | 0.4| 0.2| 1.0|
Thanks in advance,
Jeff