| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple correlations with one click?
I have a numerical data set with 11 columns and 1809 rows. I would like to
simply obtain a table of correlations involving Col 1 with each remaining Col (Col 2 thru Col 11), then Col 2 with each remaining Col (3 thru 11), then Col 4 with each remaining Col (5 thru 11), and so on until the last correlation, i.e., Col 10 with Col 11. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| multiple correlations with one click? | Excel Discussion (Misc queries) | |||
| Correlations, Group By Type? | Excel Discussion (Misc queries) | |||
| Correlations, how do I graph one? | Charts and Charting in Excel | |||
| Multiple Correlations and Multicollinearity | Excel Worksheet Functions | |||
| Partial correlations | Excel Discussion (Misc queries) | |||
Threaded Mode
