Weighted average is a powerful tool for an investor. It can be used to evaluate the performance of a portfolio. It can help us better understand how.

To understand how it can do all these things, we need to know how to calculate a weighted average. So let's start with the nuts and bolts of the calculation and how you can use this metric in your ...

To calculate the weighted average of this data set in Excel, follow these steps: Place your cursor in cell B9 (where the weighted average needs to be shown).

To calculate a price-weighted average, or any arithmetic average for that matter, add the numbers (stock prices) together and divide by the number of stocks in the average.