Posted to microsoft.public.excel.misc

Eric

external usenet poster

Posts: 1,670

How to create a correlation matrix in excel?

There are 26 column of data starting from A to Z for 100 rows. I would like
to create a correlation matrix to show all combinations of 2 sets. Does
anyone have any suggestion on how to create a correlation matrix in excel?
Thanks in advance for any suggestions
Eric

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Correlation matrix	Chrissy Wissy[_2_]	Excel Discussion (Misc queries)	7	July 11th 07 12:26 PM
Toolpack Correlation Matrix	TarrynG	Excel Worksheet Functions	0	September 4th 06 03:59 PM
Correlation Matrix	katie	Excel Worksheet Functions	5	May 16th 06 07:21 PM
CORRELATION / COVARIANCE MATRIX	Walker	Excel Worksheet Functions	1	April 30th 05 06:36 AM
Correlation matrix	Peppino	Excel Worksheet Functions	1	March 10th 05 01:32 PM

All times are GMT +1. The time now is 02:19 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us