| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21
peaceful k -
CORREL (correlation coefficient) measures the linear relationship between two variables, not four. You can use the Correlation tool of the Analysis ToolPak to obtain all pairwise correlations. - Mike www.mikemiddleton.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using CORREL with arrays containing null values | Excel Discussion (Misc queries) | |||
| vba adding arrays | Excel Discussion (Misc queries) | |||
| Two arrays need highlight duplicate in one of the array | Excel Worksheet Functions | |||
| Confused about arrays and ranges in functions | Excel Worksheet Functions | |||
| Comparing Arrays | Excel Discussion (Misc queries) | |||
Linear Mode
