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
AppSheet is not a BI tool so far, so there is no capability to do that.
But would it work as a backend excel formula on appsheet?
Best practice with Appsheet is not to use Spreadsheet formula.
Better to ask Excel forum if or not you can achieve your goal.
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?
AppSheet canโt do integrals.
User | Count |
---|---|
43 | |
32 | |
25 | |
23 | |
14 |