Who asked: Elena, the manager of fictional Rowan Corner Cafe.
Question: Tuesday had the lowest revenue. Was that only because fewer people bought something, or did they also spend less per transaction?
Data: Week contains five weekdays of drinks revenue, food revenue, and transaction counts. All amounts are fictional practice data. A transaction can contain several items.
Deliverable: total revenue by day, Tuesday's average transaction value, the weighted average for the other four days, Tuesday's share of weekly revenue, and a checked finding. Do not infer foot traffic or customer counts from transactions.
Revenue can fall because there are fewer transactions, because each transaction is smaller, or both. A daily revenue ranking can't separate those causes. Divide revenue by transactions to compare average transaction value.
The other-days comparison needs a weighted average: total revenue across those days divided by their total transactions. Averaging the daily averages gives each day equal weight even when they have different transaction counts. Tuesday belongs in neither part of that comparison.
Build the analysis in order. Your formulas carry into the next step, and the last task asks you to record the finding supported by the sheet. Stay within the data. Transactions don't tell you how many visitors entered, why anyone bought less, or whether a promotion would work.