Post Reply 
"SOLVER" function as in Excel
01-04-2022, 01:22 PM
Post: #13
RE: "SOLVER" function as in Excel
(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


Attached File(s) Thumbnail(s)
           
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
"SOLVER" function as in Excel - robmio - 01-01-2022, 08:17 PM
RE: "SOLVER" function as in Excel - rawi - 01-02-2022, 03:59 AM
RE: "SOLVER" function as in Excel - robmio - 01-02-2022, 05:35 AM
RE: "SOLVER" function as in Excel - robmio - 01-02-2022, 06:44 AM
RE: "SOLVER" function as in Excel - robmio - 01-02-2022, 07:44 AM
RE: "SOLVER" function as in Excel - C.Ret - 01-02-2022, 11:35 AM
RE: "SOLVER" function as in Excel - robmio - 01-03-2022, 06:39 AM
RE: "SOLVER" function as in Excel - rawi - 01-02-2022, 08:21 AM
RE: "SOLVER" function as in Excel - robmio - 01-03-2022, 06:23 PM
RE: "SOLVER" function as in Excel - robmio - 01-04-2022, 01:18 PM
RE: "SOLVER" function as in Excel - robmio - 01-04-2022 01:22 PM
RE: "SOLVER" function as in Excel - C.Ret - 01-04-2022, 08:22 PM
RE: "SOLVER" function as in Excel - rawi - 01-04-2022, 08:47 AM



User(s) browsing this thread: 1 Guest(s)