"SOLVER" function as in Excel

[robmio]

(01-04-2022 11:50 AM)Tim Wessman Wrote:  

(01-03-2022 06:23 PM)robmio Wrote:  Good evening again:

is it possible in the "spreadsheet" APP to use an "IF THEN ELSE" statement as in EXCEL?

=IFTE(...)

???


You can directly use a lot of spreadsheets out there directly on prime unless they start getting into some of the more advanced stuff.

Dear Tim Wessman, is it possible to solve the following problem with the “spreadsheet” APP?
Figure 1: cell K4 contains the formula "1/(1+EXP(-$O$5-$O$6*I4))" and cell L4 contains the formula "(B4+C4)*(J4*LN(K4)+(1-J4)*LN(1-K4))". Column O5:O6 contains the coefficients of a logistic regression. Box L14 contains the formula “SUM(L4:L13)”. Is it possible, by utilising spreadsheets APP of HP PRIME calculator, to ask to calculate the coefficients "O5" and "O6" in order to maximize the value in cell "L14"? For example, with EXCEL I use "SOLVER" (see figure 2) to get figure 3: if you pay attention, the coefficients "B" in cells O5 and O6 have changed from 0 and 0 to 4.476711 and -0.00721, as well as the value of cell "L14", from -526.792 to -370.546.

Thanks a lot, Roberto.

Reference: Logistic Regression via Solver | Real Statistics Using Excel (real-statistics.com)
https://www.real-statistics.com/logistic...ls-solver/