Covariance and correlation matrices: Three methods (Excel)
How can you efficiently calculate a covariance or correlation matrix in Excel? Today we are investigating the three most popular methods - using the Data Analysis tab, the built-in Excel covariance function and the INDEX function, as well as matrix multiplication.
Don't forget to subscribe to NEDL and give this video a thumbs up for more videos in Statistics!
Please consider supporting NEDL on Patreon: / nedleducation