correlation matrix

Originally Posted by refreshplease3

i have a worksheet with monthly return data of different stock. I want to create a correlation matrix on another worksheet.

is there a quick way to create it? and what should i put in each cell (i mean the formula) and drag it over to next row and column? thanks.

thanks,
Philip

No idea, however, from another post :

Q: How do I get Excel to calculate a correlation matrix (i.e., correlations among several variables)?

A: If you want an entire correlation matrix, you'll need to use the Analysis ToolPak. First, make sure the Analysis ToolPak has been installed (see above). To generate a correlation matrix, select Data Analysis from the Tools menu and choose the Correlation procedure. A dialog box will open that will allow you to select the range of your data. (Note that you need to select one continuous range; you can't select a series of unconnected columns.) Indicate whether your variables are in columns or rows (it will almost always be columns). If you include the names of your variables in the selected range, make sure you check the “Labels in First Row” box.

Hope this helps.
---