Q1 province totals: Ontario amount 1,995 on 14 units; Alberta amount 2,300 on 14 units. Compute the amount per unit for each province, to the cent.
Q1 province totals: Ontario amount 1,995 on 14 units; Alberta amount 2,300 on 14 units. Compute the amount per unit for each province, to the cent.
Answer
ON per unit → 142.5 · AB per unit → 164.29
Cells - ON per unit · ±0.005 - AB per unit · ±0.005 ON: 1995 / 14 = 142.50. AB: 2300 / 14 = 164.29. In Sheets, =SUMIF(B:B, "ON", D:D) / SUMIF(B:B, "ON", E:E); in R, aggregate(cbind(amount, units) ~ prov, data = orders, FUN = sum) then amount / units. Same base (14 units each), so the comparison is fair; state the base anyway.