Histograms

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

Hi,

What is the quickest (and most efficient) way to do the
following:

I have a set of data, which is a set of Rental Rates,
varying between a minimum value of £20 and a maximum value
of £60.

I want to produce a Histogram which shows:

the number of Rates that fall below £30;
the number of Rates that fall between £30 and £35;
the number of Rates that fall between £35 and £40;
the number of Rates that fall between £40 and £45;
the number of Rates that fall between £45 and £50;
the number of Rates that fall above £50.

How do I do this???
 
Gary -

Use the FREQUENCY function to set up a table of values separated into
the bins that you want, then make your chart. Or from the tools menu,
choose Data Analysis, and use the Histogram tool.

- Jon
 
Back
Top