The twelve amounts are 420, 180, 760, 250, 1320, 510, 90, 640, 305, 980, 215, 470. Remove order 1005 (the 1320) and give the mean of the remaining eleven amounts, rounded to 2 decimal places.
The twelve amounts are 420, 180, 760, 250, 1320, 510, 90, 640, 305, 980, 215, 470. Remove order 1005 (the 1320) and give the mean of the remaining eleven amounts, rounded to 2 decimal places.
Answer
438.18
Cells - Mean without 1320 · ±0.005 (6140 − 1320) / 11 = 4820 / 11 = 438.18. In Sheets, `=AVERAGE` over the eleven cells; in R, `mean(ordersamount[ordersorder_id != 1005])` prints 438.1818.