Money tips

Average daily spending in pounds: mean, median and weekday split

Calculate average daily spending in the UK with pounds: why the mean can mislead, how to find the median, and how to split weekdays from weekends.

Editorial illustration for Average daily spending in pounds: mean, median and weekday split

Your average daily spend is total spending divided by the number of days, but one expensive weekend can make that figure describe nobody's real day. So work out three numbers from the same fortnight: the mean, the median and a weekday-versus-weekend split. Together they tell you what a normal day costs and what a treat day costs.

Why one average is not enough

Suppose your weekdays are quiet: a sandwich, a bus fare, a small shop. Then Saturday arrives with a meal out and a pair of shoes. Averaging those into one figure produces a number that is too high for Tuesday and too low for Saturday. If you budget with it, you will feel guilty on weekdays and be caught short at the weekend.

A worked fortnight

Say the daily totals for 14 days, starting on a Monday, are: £12, £8, £15, £9, £22, £95, £60, £11, £7, £14, £10, £18, £88, £35. The total is £404.

MeasureWorkingResult
Mean (average)£404 / 14 days£28.86
Median (middle day)Sorted: 7, 8, 9, 10, 11, 12, 14, 15, 18, 22, 35, 60, 88, 95. Middle two are 14 and 15£14.50
Weekday averageTen weekdays total £126, so £126 / 10£12.60
Weekend averageFour weekend days total £278, so £278 / 4£69.50

The mean of £28.86 matches neither kind of day. The median of £14.50 is closer to a typical day. The split tells the real story: about £12.60 on a weekday and £69.50 on a weekend day.

What is the difference between mean and median?

The mean adds everything and divides. A big day pulls it up. The median is the middle value when you line the days up in order, so a few extreme days barely move it. When the mean is much higher than the median, a handful of heavy days are doing the work, and that is where to look for savings or planning.

How do I get these in a spreadsheet?

Put the date in column A, the day's total in column B and add a helper in column C that labels each date. In row 2 of column C:

=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")

WEEKDAY with the second argument set to 2 numbers Monday as 1 and Sunday as 7, so 6 and 7 are the weekend. Then, for rows 2 to 15:

  • Mean: =AVERAGE($B$2:$B$15)
  • Median: =MEDIAN($B$2:$B$15)
  • Weekday average: =AVERAGEIFS($B$2:$B$15,$C$2:$C$15,"Weekday")
  • Weekend average: =AVERAGEIFS($B$2:$B$15,$C$2:$C$15,"Weekend")

If your data has several transactions on one day, add them up per day first, or use SUMIFS by date to build the daily list.

How much history do you need?

A fortnight is enough to see the pattern; four weeks is better, because a payday week and a mid-month week behave differently. Look again after a month with an unusual event, such as a holiday or a family visit, and set that period aside rather than blending it in.

Using the numbers to answer a real question

Say a friend suggests a £60 night out on a weekday. Your weekday average is £12.60, so that single evening equals nearly five ordinary weekdays. That is not a reason to say no; it is simply a clear picture, so you can choose which other days to trim. The same sum for a weekend, where the average is £69.50, shows the £60 sits within a normal weekend.

A checklist to keep beside the sheet

  • Zero-spend days included.
  • Fixed bills such as rent and regular household bills kept out of the daily list.
  • Transfers to your own savings or repayments of your own credit card left out.
  • Mean, median and the weekday and weekend averages all written down.
  • The fortnight recorded again next month to see if the split has moved.
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports