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?

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. Best, The 365 Team

Follow this topic

Kasey Rice

Last answered:

03 Oct 2019

Posted on:

03 Oct 2019

Categorical Variables - Relative Freq.

1 answers ( 0 marked as helpful)

365 Team

Posted on:

03 Oct 2019

Categorical Variables - Relative Freq.

Submit an answer