View Single Post
 
Old 07-09-2012, 09:05 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 519
Jamal NUMAN is on a distinguished road
Question Categorising values in intervals

Categorising values in intervals

Is there a way in excel to categorise the values in interval and then show the count included in each interval. i.e, is possible in excel to derive intervals from raw values and to assign the frequency of each interval.

For example, in the attached screenshot, it is shown raw values from which intervals and their frequencies are derived.

Is there a way to do that automatically in excel?

Thank you for the help

Best

Jamal
Attached Images
File Type: jpg Clip_259.jpg (97.9 KB, 9 views)
Attached Files
File Type: xlsx intervals.xlsx (11.6 KB, 7 views)
Reply With Quote