Iterating a matrix operation

Hi All,

I have an inverted matrix and want to calculate partial correlations using the formula Pij = - Pij/sqrt(Pii*Pjj) where Pij is the elment in the i-th row and j-column of the inverted correlation matrix.

Can anyone tell me how to implement this formula into excel?

Thanks in advance



Attachment 162241