Income and work

Median or average monthly income: which to budget on when it swings

With six made-up months, see how one big month distorts the average and why the median or lowest-quarter figure is a safer base for a budget.

Editorial illustration for Median or average monthly income: which to budget on when it swings

When income swings, the average can mislead and the median is usually the safer budgeting figure. One unusually large month drags the average up, so you plan on money that most months do not deliver. The median, the middle value, ignores that outlier. A lowest-quarter figure is more cautious still.

How can one month distort the average?

Six invented months of income: ₹28,000, ₹31,000, ₹26,000, ₹30,000, ₹29,000 and one project month of ₹1,10,000. The total is ₹2,54,000. Divide by 6 and the average comes to about ₹42,333.

Now look at what actually happened. In five of the six months you earned between ₹26,000 and ₹31,000. A budget built on ₹42,333 would have been short by roughly ₹11,000 to ₹16,000 in each of those five months.

What are the median and the lowest-quarter figure?

Sort the months from smallest to largest: ₹26,000, ₹28,000, ₹29,000, ₹30,000, ₹31,000, ₹1,10,000. With six values the median is the mean of the middle two, 29,000 and 30,000, which is ₹29,500. The lowest-quarter figure is the value a quarter of the way up the sorted list. Here that is about ₹28,250.

MeasureResult (₹)What it tells you
Average42,333Pulled up by the one big month
Median29,500A typical month, ignoring extremes
Lowest quarter28,250A cautious floor to plan essentials on

The gap between average and median, ₹42,333 minus ₹29,500, is about ₹12,833. That is roughly how much a plan based on the average overshoots a typical month.

Now change one thing. Suppose the project month had been ₹32,000 instead of ₹1,10,000. The total becomes ₹1,76,000 and the average about ₹29,333, while the median stays at ₹29,500. When the two figures sit this close, your income is steady and either one is fine to plan on.

Which formulas give me these in a sheet?

With the six incomes in B2:B7, use these in Excel or Google Sheets:

  • Average: =AVERAGE(B2:B7)
  • Median: =MEDIAN(B2:B7)
  • Lowest quarter: =QUARTILE(B2:B7,1)

Use at least twelve months if you have them. Six is fine for an illustration but too few for a reliable pattern.

A month with no income at all belongs in the list as zero. The median copes with it better than the average does, and the lowest-quarter figure will show how often your income has dipped that low.

A quick way to use all three: plan essentials on the lowest-quarter figure, plan flexible spending and saving on the median, and treat the gap between the median and the average as a warning about how lumpy your income is. Recalculate each month as a new month closes, using the latest twelve months. If a single month looks wildly out of line, check whether it was one project or a catch-up of several late payments before you decide it is typical.

Which should I budget on?

Match the figure to the job. Essentials such as rent, EMI, groceries and utilities should be planned on the cautious figure, because missing them has consequences. Flexible spending and saving can follow the median. Anything above the median is a bonus that goes to the buffer, to an annual bill you know is coming, or to a goal, before it reaches daily spending.

What do I do with the big month?

  1. Enter it in your records on the day it arrived.
  2. Do not raise your spending to match it.
  3. Send a pre-decided share to the buffer.
  4. Park some to cover the slower months you can see in your own history.
  5. Review the sorted list again next month, to see whether the median has moved.

If you have statements to import, SpendixAI can give you monthly income totals to feed these formulas, so you are not adding credits by hand.

SPENDIXAI JOURNAL

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

Explore your reports