Subject: Handling Missing Cells in Your Correlation Table

Dear [Recipient],

Your issue: Some cells are missing in your correlation table.

I recommend that you first understand the technique for visualizing correlation tables as described in my article:

see attached.

Once you feel confident with the technique, compile all cells into an Excel spreadsheet, including the missing ones, which you should initially fill with zeros. For technical reasons, the first two lines of the sheet must be left empty.

Next, download my macro, see attached.

Then, activate the macro so it can be executed with Ctrl+S. Instructions for activating the macro are explained in my article.

I hope that visualizing the table will help you estimate reasonable values for the

Something get wrong

Dear Dr. Joseph Emmanuel Mullat

Thank you so much for sharing your article and explanations. I understand the issue. Based on your recommendation, I will consider those missing correlations as zero.