RusselB wrote:Welcome to the Forums.
Are you wanting to work with single or multiple variables in the polynominal equation?
RusselB wrote:When I tried your equations with Solver, I also got "No solution was found", but I also got "The model is not linear"
The second message is important, as that tells me that a simple solution is not going to be found.
I tried your first formula on the website https://www.symbolab.com/solver/polynom ... calculator and it found the solution, but as i suspected, it's not a simple answer.
At this point in time, Calc, without extra programming, does not have the ability to handle these types of problems.
I seem to recall seeing another post along these same lines, but too tired to be able to think straight to try to find it. Maybe after I get up in the morning.
In the meantime, you can try your other formulas in the site referenced earlier.
Slpncrg wrote:...They all have complex roots.
Lupp wrote:Slpncrg wrote:...They all have complex roots.
I didn't use Excel for decades now, but I dare to doubt if it actually can work on parameters allowing (truly) complex values with the solver. Are you sure your instructional for Excel would actually work under the quoted condition?
There were THREE equations and only one of them has a real root. The others have one and respectively two pairs of conjugated complex solutions. I gave them all above.Slpncrg wrote:I know that the equation has one real root ...
Lupp wrote:There were THREE equations and only one of them has a real root. The others have one and respectively two pairs of conjugated complex solutions. I gave them all above.Slpncrg wrote:I know that the equation has one real root ...
In the case of the equation of degree 3 you can get the real solution by well known iterations (Newton type). Even in cases with more (2 or multiple) real solutions you will often only get one with the maximum amount (dependig on the start). Subsequently you need to reduce the degree by formally dividing the polynomial by the liner factor to the first solution. Neither Calc nor Excel are capable of doing this. It's CAS (or human's) work.
Since this was "Calc homework" we hope your teacher knew how to get it done. You are kindly invited to report the solution here.
the second through Solver, but in Excel
jrkrideau wrote:the second through Solver, but in Excel
I would refer you to my earlier post. It seems that Excel will give you a solution.
Whether the solution has any relationship to to problem is another question. Does the Excel solution agree with Lupp's solution?
lader wrote:Added conditions. The minimized cell must be in square.
Users browsing this forum: No registered users and 12 guests