Is there a formula equivalent to CORREL in appsheet to determine the correlation coefficient for a series of values?

[Taylor_Felt]

I have a large data set of values that I need to determine the coefficient of determination for. For reference, this is the formula in excel I’m trying to replicate… =(CORREL(B13:B1812,’(2) Input - Test Period Data’!C6:C1805))^2

[Koichi_Tsuji]

AppSheet is not a BI tool so far, so there is no capability to do that.

[Taylor_Felt]

But would it work as a backend excel formula on appsheet?

[Koichi_Tsuji]

Best practice with Appsheet is not to use Spreadsheet formula.
Better to ask Excel forum if or not you can achieve your goal.

[Taylor_Felt]

It looks like appsheet supports the square root formula so I believe I can manually create this. Do you see any reason why this wouldn’t work?

[Steve]

AppSheet can’t do integrals.