Finding the new average when a value joins
When the count changes, there are two totals. One before, one after. The new average does not come from the old average. It comes from the new total.
When the count changes, there are two totals. One before, one after. The new average does not come from the old average. It comes from the new total.