The ON × Store cell of the Average pivot summarises orders 1003 (760) and 1009 (305). Give its value to 2 dp.
The ON × Store cell of the Average pivot summarises orders 1003 (760) and 1009 (305). Give its value to 2 dp.
Answer
532.5
Cells - Average of amount, ON × Store · ±0.005 (760 + 305) / 2 = 532.50 — the mean over the rows where prov = ON AND channel = Store. `=AVERAGEIFS(D2:D13, B2:B13, "ON", C2:C13, "Store")`; R: aggregate(amount ~ prov + channel, orders, mean), the ON Store row.