I'm trying to figure out how to analyse the data which consists of a number of visits to a website and the total amount the visitor ends up spending there.

There are obviously a lot of zeros - people leaving without buying anything - and few relatively large amounts, so the data is severely left skewed.

I'd like to transform it into some kind of normally distributed data, so I can analyse it properly, but I'm not sure how to go about doing that.

I've looked into various transformation functions, read about Weibull distributions, lognormal, chi-squared and goodness-of-fit, but for my lack of experience, it's too much information :-)

I'd like to get push in the right direction and maybe some comments from people who have worked on something similar.

Thanks!