How to Calculate Weighted Average in Excel Using Pivot Table 

In accounting, the weighted average is often used for inventory calculations. Instead of the normal average, weighted averages sometimes provide a better picture of the data for various statistical ...