How do I select grades of over a thousand student in a column into ranges like (1-20,20-40,40-60,60-80,80-100). I dont want the count which is what frequency does. i want the actual score into those ranges.
I have scores between 1 and 100. All the scores are in a column and over a thousand.
1. I want to be able to group those scores in the range of 0-20,20-40,40-60,60-80,80-100 in a column with the range as the heading.I want the scores under each range column.(e.g 45 will fall under column range 40-60, 75 will fall under column range 60-80) is there a function or formula for this.