Hi all,

I have a problem. I have a set of data (from 108 people, all percentages)
which I would like to put into a histogram. I can do this manually but as it
is part of an Excel Tool would like to be able to do it automatically. I was
wondering if anyone could help me, possibly with a macro, which will create a
set of data which will give me 5% ranges (0-5, 5-10, 10-15% etc) and the
number of people which fall into that category (i.e frequency)

I'm hoping this will give me something ressembling a normal distribution and
so I would like to know if it is possible to interpolate the data to give a
smooth curve? I would also like to mark where the lowest 20% and highest
20% occur!

Please help if you can!

Many thanks,

Ed