Frequency in excel

[Ashish Mathur]

Hi,

A friend of mine asked me this question

How can one know the numbers whivh fall with in a range. For e.g. - given a
list of numbers how can one know the numbers which fall with in the following
ranges.

<50, 50-100, 101-150 etc.

Hope this helps some of us

Regards,

Sachin Mandon

 

[Ashish Mathur]

Hi,

Try using the Frequency function in Excel. It is well explained i the Help
menu

Regards,

Ashish Mathur

 

[Myrna Larson]

Or try a Histogram, also explained in Help.

Hi,

Try using the Frequency function in Excel. It is well explained i the Help
menu

Regards,

Ashish Mathur