Help

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 
Search instead for 
Did you mean: 

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?

Thanks in advance.

Regards Maichel

3 Replies 3

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).

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,

Hey Maichel,

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