Grouping of numbers can be done for creating a frequency distribution table in a Pivot Table. This can be done in carrying out analysis of numerical values by carrying out grouping in several ranges. For understanding this in a better manner, an example can be considered. Analysis of the number of students who scored between 30 and 50 can be done. The same can be done for students who scored between 40 and 50. Frequency distribution of people within a group can also be analyzed. This would assist in the identification of people who fall in the age group of 30 to 40 or more.
Within the group dialog box, there is a need to specify the start and the end point. By value needs to be entered as well which will help in creating groups having an interval that would be equivalent to the By value. Click on OK. This would help in developing a Pivot Table that offers frequency distribution of the sales transactions carried out.
The Pivot table can be then analyzed for figuring out the stores that have high transactions. Information such as the stores that require improvement in sales can also be analyzed with this data. The grouped sales data can be moved to the column area for developing a matrix which can be read easily.
Sometimes, an error message is displayed such as “Cannot group selection” while using numbers for grouping. This may occur if cells consist of text and not numbers. This may require you to check the data source for removal of text and insert appropriate value that is numeric.