ExcelBanter - Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21 (https://www.excelbanter.com/excel-worksheet-functions/91400-can-i-correlate-4-arrays-e-g-%3Dcorrel-c7-c21-d7-d21-e7-e21-f7-f21.html)

peaceful k

Can I correlate 4 arrays e.g =correl(C7:C21,D7:D21,E7:E21,F7:F21

Mike Middleton

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

All times are GMT +1. The time now is 09:17 AM.