How to calculate the mode for crowdsourced data?

[Alice_T1]

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?

[Jeff_Haskin]

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.