Using Data Analysis Tool to calculate Correlation

Excel
1

Hi,

I’ve enabled the Data Analysis ToolPak in Excel to calculate the correlation.

image

image

After adjusting all settings, I’ve got this result:

image
image1920×1040 128 KB

My question is why there are results only for half of the data. for example, there is no correlation result between items where I colored the cell with red color.

Like O7

Like U10

Like AA6

Why there is no result?

Do I need to adjust anything to get a result for all cells?

Thanks

2

Also note that only half the matrix is complete, that is because the results would be the same if these empty cells were calculated.

1 Like