Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Weighted averages. A plain AVERAGE gives every row the same weight. A weighted average lets each row count by its size: SUMPRODUCT(values, weights) / SUM(weights). For prices weighted by quantity, that is total value ÷ total units.
=SUMPRODUCT(C2:C9,D2:D9)/SUM(D2:D9) average grade weighted by credits
The Coffee & Kitchen manager wants the average price Brightline got per unit sold in the first two weeks of February. Averaging the price column treats a one-unit line the same as a 28-unit line.
In G2, calculate the average unit price weighted by quantity: total list value of the lines in rows 2 to 34 (quantity in C × unit price in D) divided by the total quantity. Round to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Product | Qty | Unit price | ||||
| 2 | 50095 | Sugar Sticks (1000) | 13 | 11.00 | Weighted avg price | |||
| 3 | 50095 | Paper Cups (1000) | 7 | 36.00 | Plain average | 23.10 | ||
| 4 | 50097 | Sugar Sticks (1000) | 2 | 11.00 | ||||
| 5 | 50099 | Espresso Beans 1kg | 1 | 24.00 | ||||
| 6 | 50100 | Paper Cups (1000) | 10 | 36.00 | ||||
| 7 | 50102 | Espresso Beans 1kg | 13 | 24.00 | ||||
| 8 | 50103 | Oat Milk 12-pack | 7 | 21.50 | ||||
| 9 | 50109 | Sugar Sticks (1000) | 3 | 11.00 | ||||
| 10 | 50109 | Paper Cups (1000) | 4 | 36.00 | ||||
| 11 | 50111 | Sugar Sticks (1000) | 2 | 11.00 | ||||
| 12 | 50113 | Filter Coffee 1kg | 10 | 16.50 | ||||
| 13 | 50114 | Paper Cups (1000) | 2 | 36.00 | ||||
| 14 | 50115 | Paper Cups (1000) | 3 | 36.00 | ||||
| 15 | 50116 | Sugar Sticks (1000) | 2 | 11.00 | ||||
| 16 | 50117 | Espresso Beans 1kg | 1 | 24.00 | ||||
| 17 | 50119 | Paper Cups (1000) | 5 | 36.00 | ||||
| 18 | 50120 | Filter Coffee 1kg | 14 | 16.50 | ||||
| 19 | 50122 | Espresso Beans 1kg | 2 | 24.00 | ||||
| 20 | 50123 | Sugar Sticks (1000) | 6 | 11.00 | ||||
| 21 | 50123 | Filter Coffee 1kg | 4 | 16.50 | ||||
| 22 | 50127 | Tea Assortment (200) | 5 | 19.90 | ||||
| 23 | 50129 | Sugar Sticks (1000) | 4 | 11.00 | ||||
| 24 | 50131 | Paper Cups (1000) | 4 | 36.00 | ||||
| 25 | 50132 | Filter Coffee 1kg | 1 | 16.50 | ||||
| 26 | 50134 | Paper Cups (1000) | 6 | 36.00 | ||||
| 27 | 50134 | Tea Assortment (200) | 5 | 19.90 | ||||
| 28 | 50136 | Sugar Sticks (1000) | 28 | 11.00 | ||||
| 29 | 51106 | Espresso Beans 1kg | 24 | 24.00 | ||||
| 30 | 51106 | Paper Cups (1000) | 22 | 36.00 | ||||
| 31 | 51106 | Oat Milk 12-pack | 16 | 21.50 | ||||
| 32 | 51107 | Espresso Beans 1kg | 28 | 24.00 | ||||
| 33 | 51107 | Paper Cups (1000) | 17 | 36.00 | ||||
| 34 | 51107 | Oat Milk 12-pack | 10 | 21.50 | ||||
| 35 | ||||||||
| 36 | ||||||||
| 37 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe