This post explains how to calculate Weighted Average in Excel with percentages. In a standard arithmetic average where the sum of values is divided by the number of values, each data value is treated ...
If the S&P 500 remains exactly where it’s trading the last 6 weeks of the year, then the arithmetic average of the last two years’ return for the main benchmark is +26.6%. If we average 2022 through ...