excel for likert scale data

Helllo, 

I have a large report that lists 12 statements like the one below from a list of employees  The numbers 1-5 are meant to indicate strongly disagree(1) to strongly agree(5). Excel does not recognize these numbers as ordinal values. What is the best way to analyze this data without finding the average?

Employee info:                   Overall please rate this training   

4
3
5
4
3
3
4
4
5
4
4

  

 

By: Flori

Leave a Reply

Your email address will not be published. Required fields are marked *