Forum Discussion
SusuYes
Helper III
Helper IIICalculating the Mode and Median for Non-numeric data
Hello everyone, I have data on the number of staff who attended certain workshops. I have calculated the average number of attendance to every workshop type. However, I want to calculate the mode...
Ashish_Mathur
Super User
Super UserYou are welcome. In which case, is your question even relevant? I thought arithmatic functions (specially Median and Mode) work only on numeric columns.
SusuYesHelper III
Helper IIIHello Ashish, I am hoping to report on the number of attendees to each workshop type and finding the median, mean, and mode of the attendance for each workshop type.
Would using a count for Attendees serve the same purpose?
- Ashish_Mathur
Just show the exact result you are expecting.