Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

# Calculate a Minimum Sample Size for an experiment

Topic Labels: Formulas
466 3
cancel
Showing results for
Did you mean:
4 - Data Explorer

Hi all, i am trying to reproduce an exel formula that calculates the Minimum Sample Size based on some values in Airtable.

the formula in excel is like this:
=IF(AB2;ROUNDUP((1,644853625*(2I2(1-I2))^0,5+0,8416212327*(I2*(1-I2)+(I2+(I2AC2))(1-I2-(I2AC2)))^0,5)^2/((I2AC2)^2);0)*K2;0,1)

Reference:
AB2 = value from call (TRUE/FALSE)
I2 = 10% (value from cell)
AC2 = 20% (value from cell)
K2 = 2 (value from sell)
I am stuck with the use of “^” (power)

any suggestions?

Regards Maichel

3 Replies 3
10 - Mercury

Excel > Airtable

The biggest transition will be converting your formula so that instead of cell references, you refer to an entire column or field. Example:

``````  A        B        C
1 Fruit    Color    Color + Fruit    Excel Formula    Airtable Formula
2 Apple    Red      AppleRed         A2 & B2          {Fruit} & {Color}
``````

Power

Checkout the formula field reference. Instead of `Base ^ Power`, you’ll use `POWER(base, power)`.

4 - Data Explorer

Thanks Zollie, i will need to play around with the (POWER(base,power) furmula. i will get back when i get it working or get stuck again,

4 - Data Explorer

Hey Maichel,

was wondering, did you manage to get this working?
We’re also using Airtable for experimentation tracking, maybe we could share tips?