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
|