Be Excellent To Each Other

My brain is fried, and while this is probably pretty simple I just can't work out the best way of doing it.

We've got a survey that asks how much on average people spend on Christmas presents, and they choose from a variety of options. The values for these selections are numeric, and in this case are 0, 50, 150, 300 and 1000 (representing various bands of spend, rather than absolute figures.)

They also select their gender in the survey.

Now, given the example phrase shown in our results page: "6 out of 10 men spend less than women."

What calculations would I use to work that out, and also to switch the genders around if more women spend less than men?

Now that I've written it out, I'm not convinced you can really do it. It's trivial to work out an average spend for both men and women, and then say "On average, men spend less than women" (or vice versa) but can you put a 6/10 style counter on it?

Get the average for both, then look for the number of men who spend more than the average woman?

Yeah, that occurred to me pretty much as I clicked Submit.

D'oh.

You should give me a job.