Weighted average in Numbers

If column A is balances, column B is rates,

=SUMPRODUCT(A,B)/SUM(A)

That's the gist of what you would do if B was test scores and A was the weight of each toward the final grade.

To calculate a weighted average in Numbers, you can follow these steps:

1. Enter your data: Enter the values and corresponding weights into separate columns in a table. For example, if you have three values and their corresponding weights, you would enter them into two columns like this:
2. ValueWeight100.4150.3200.3Calculate the weighted value: Multiply each value by its weight to get the weighted value.

[Link Edited by Moderator]