Spreadsheets

Median or average monthly spend: which describes you better?

Median or average monthly spend? A twelve-month worked example with one big one-off shows MEDIAN and AVERAGE side by side and when each suits your budget.

Editorial illustration for Median or average monthly spend: which describes you better?

The average of your monthly spending is pulled upwards by any single large month, while the median is the middle month and barely moves. If one month contains a laptop, a trip or an insurance premium, the median describes a typical month better, and the average is the number to plan your yearly cash around. You often want both.

What is the difference, in plain terms?

The average adds up all twelve months and divides by twelve. The median puts the months in order from smallest to largest and picks the middle one; with twelve months, that is the mean of the sixth and seventh. A single huge month shifts the average noticeably but moves the median by at most a step.

A worked example with one large month

Say your monthly spending over twelve months, in rupees, was as below. These numbers are made up to show the effect.

MonthSpend (₹)MonthSpend (₹)
Apr30,000Oct33,000
May31,000Nov31,000
Jun29,000Dec30,000
Jul30,000Jan29,000
Aug32,000Feb31,000
Sep28,000Mar1,02,000

The twelve figures add up to ₹4,36,000. Divided by twelve, the average is ₹36,333. In order, the figures run 28, 29, 29, 30, 30, 30, 31, 31, 31, 32, 33 and 102 thousand. The sixth and seventh are 30 and 31 thousand, so the median is ₹30,500. The one-off March month pushes the average about ₹5,800 above what a normal month looked like.

In Excel or Google Sheets, with the twelve figures in B2:B13:

  • Average: =AVERAGE(B2:B13)
  • Median: =MEDIAN(B2:B13)
  • Average without the highest and lowest value: =TRIMMEAN(B2:B13,0.2)

TRIMMEAN with 0.2 drops 20 percent of the points; with twelve values it rounds to two points, one from each end. Here it gives ₹30,600. It is a quick way to see a typical month without deciding by hand what counts as an outlier.

Which one should I use for budgeting?

Question you are askingBetter figureWhy
What does a normal month cost me?MedianOne big month does not distort it
How much should I set aside for the whole year?Average times 12The one-off still has to be paid
Did this month look unusual?Compare with the medianShows the gap against a typical month
Is my spending creeping up?Median of the last six months against the six beforeResists one-offs on either side

If you budget to the median only, the one-off month will feel like a surprise every year. If you budget to the average only, you will think your normal month is dearer than it is and may skimp on it.

What if the big month is not really a one-off?

Some large months come back every year: an annual insurance premium, school fees in June, Diwali shopping and travel. They are irregular, not unusual. Treat them as planned items, divide the yearly total by twelve and put that sum aside each month in a separate pot, while you use the median for ordinary spending.

Does it matter how many months I have?

Yes. With three months of data, one large month dominates both figures. Twelve months, from April to March, is a good base because it contains the usual yearly events once each. If you have less, say so in your notes and treat the result as rough.

Where do the monthly totals come from?

The figures above need a total per month. In a sheet, a SUMIFS with a start and end date does it. If your spending sits on bank statements, SpendixAI can import them and show monthly totals through its reports, so the median and average are a short step from there.

Checklist

  • List twelve months of total spending, April to March.
  • Calculate AVERAGE and MEDIAN side by side.
  • Note the gap and find the months that cause it.
  • Move regular annual costs into a monthly set-aside amount.
  • Budget the ordinary month from the median.
SPENDIXAI JOURNAL

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

Explore your reports