Combine the SUMPRODUCT and SUM to Calculate the Weighted Average. You simply write-out the formula of the weighted average. Example 1 Step 1 Identify the numbers to average.
The weighted average multiplies each loans interest rate by the loan balance and divides the sum by the total loan balance.
Combine the SUMPRODUCT and SUM to Calculate the Weighted Average. 93-100 A 90-92 A-87-89 B 83-86 B 80-82 B-77-79 C 70-76 C 67-69 C-64-66 D 62-63 D. Searching for a typical formula for a weighted average yields something like this you multiply each average by a weighting factor that is calculated from the proportion of the impressions they represent then add them together. You simply write-out the formula of the weighted average.