"SOLVER" function as in Excel

[robmio]

(01-04-2022 01:18 PM)robmio Wrote:  

(01-04-2022 11:50 AM)Tim Wessman Wrote:  =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/

I forgot to attach the figures