How to calculate a correlation coefficient on a weighted average Excel spreadsheet
Microsoft Excel is an Excel software that can be used to create a weighted average.The formula for calculating the correlation coefficient is a bit complicated, and you’ll want to have a look at our article on how to calculate it.Here’s a simple example that shows…