๐๐ฒ๐ง๐๐ฆ๐ข๐ ๐๐จ๐ซ๐ซ๐๐ฅ๐๐ญ๐ข๐จ๐ง ๐๐๐ญ๐ซ๐ข๐ฑ ๐ข๐ง ๐๐ฑ๐๐๐ฅ ๐ฎ๐ฌ๐ข๐ง๐ ๐๐๐๐๐๐๐๐๐ ๐ ๐ฎ๐ง๐๐ญ๐ข๐จ๐ง
We have the option to compute Correlation Matrix in Excel under Data Analysis Toolpak. But the output is static as in if more data gets added or if there are any changes to the input data the Matrix does not update.
In this video, we shall explore the MAKEARRAY Function to quickly generate Correlation Matrix in Excel.
