🛠️ Scheduled Maintenance | We’ll be undergoing scheduled maintenance and upgrades between 00:00 PST Jan 26th until 00:00 PST Jan 28th. There may be brief interruption of services in that period. We apologize for the inconvenience.

The 365 Data Science team is proud to invite you to our own community forum. A very well built system to support your queries, questions and give the chance to show your knowledge and help others in their path of becoming Data Science specialists.
Anybody can ask a question
Anybody can answer
The best answers are voted up and moderated by our team

Categorical Variables – Relative Freq.

Categorical Variables – Relative Freq.


How do you order a large number of different categorical variables? The example in 3.6 gives three brands, but how can you use excel to order them and keep the relative frequency and cumulative frequency in the same line? 

1 Answer

365 Team

Hi Kasey,  
Thanks for reaching out.  
To sort the data according to frequency, first we highlight the data to be sorted.
Then on “Data” ribbon, click sort. Then on sort there appears a pop up. Choose “frequency”, and change the order, highest to lowest.  

Hope this helps.
The 365 Team