How to calculate the mode for crowdsourced data?

Topic Labels: Formulas
657 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hi everyone,

I’m trying to figure out how to calculate the Mode (ie. the most frequently occurring number in a series). I need this for the purposes of turning crowdsourced data into something useful. For example, if I ask 10 employees of one company how many days of holiday they get a year, I want to return the value most frequently cited, not the average (mean) because that would be inaccurate.

In google sheets, it’s simply the function: MODE() but Airtable doesn’t have this.

Does anybody know how I might do this?

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Bump. I too am wondering how to calculate mode since Airtable doesn't have a MODE() formula.

Edit: I asked a mathematics sub-forum how to calculate MODE using only +, −, ÷, ×, etc. I'll post here if I get an answer.