|
Posted to microsoft.public.excel.misc
|
|
|
Correlation matrix
Many thanks!
"Mike Middleton" wrote:
Chrissy Wissy -
You wrote: It is quite hard to find an application that can plot a
correlation matrix in its normal form. The only way with Excel in its bare
form as I see it is to convert the matrix into a very long list of x
(variable), y (variable), z (correlation coefficient) values! <
No, it's not hard. Excel's 3-D Column chart type and Surface chart type use
worksheet data in what you have called "normal form."
That is, X values across the top, Y values down the left side, and Z values
in the body of the table.
If the data is in list (database) form, i.e., a row for each x, y, and z
value, you can use the Pivot Table feature to put it into a table for
charting.
Jon Peltier has an article at
http://pubs.logicalexpressions.com/P...cle.asp?ID=447
- Mike
www.MikeMiddleton.com
|