Solve function problem (simple example)

Solve function problem (simple example) - 消息

#1 已发布: 2018/10/16 05:23:51
Michał Janowski

Michał Janowski

1个赞,共7个帖子。

组: User

Hello, please tell me what is wrong with this function?

Solve problem.jpg
Solve problem.sm (2.86 KiB)已下载 1348 次。
#2 已发布: 2018/10/16 06:38:47
sergio

sergio

127个赞,共342个帖子。

组: User

The solution method is numeric and depends on the search limits of the roots. By appropriately setting the limits to the nearest values (Tools->Options->Calculation->Roots (range)-10 + 10), you get the correct result. Downstream of a numerical solution, it is always necessary to proceed to the direct verification of the result (sanity check).

sergio
#3 已发布: 2018/10/16 06:43:10
Michał Janowski

Michał Janowski

1个赞,共7个帖子。

组: User

Full reinstallation (including deletion of plugins) repaired this problem. But what was exact source?.. I don't know.

Edit:
I was writing post when You answered my problem... Change of the range of roots - this is the correct answer.

But now, there is a question: how to use this range? (cuz I remember that I had to increase it becouse there were no roots in my previous calculations and now I need to decrease it).
How to handle with it if it is defined globally for spreadsheet and not for exact calculation?
#4 已发布: 2018/10/16 06:57:11
Davide Carpi

Davide Carpi

1,443个赞,共2,936个帖子。

组: Moderator

Wrote

How to handle with it if it is defined globally for spreadsheet and not for exact calculation?



Use solve(4) instead of solve(2). The one with 2 arguments it's handly for calculations on the fly, but not reliable for structured calculations.
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#5 已发布: 2018/10/16 07:08:50
Alvaro

Alvaro

1,139个赞,共1,805个帖子。

组: User

Wrote

Full reinstallation (including deletion of plugins) repaired this problem. But what was exact source?.. I don't know.



If you put some big range, you get wrong answers, like in this picture

Clipboard02.gif

Wrote


But now, there is a question: how to use this range? (cuz I remember that I had to increase it becouse there were no roots in my previous calculations and now I need to decrease it).
How to handle with it if it is defined globally for spreadsheet and not for exact calculation?



You can't. Solve with default range for search "all" the roots it's just a helper for some easy calculations. If it give the correct answer, good, but if not, there are not to much to do.

For that you must to use the solve with 4 arguments (or other numerical solver), and get the roots one by one.

Clipboard03.gif

Best regards.
Alvaro.
#6 已发布: 2018/10/16 07:18:02
Michał Janowski

Michał Janowski

1个赞,共7个帖子。

组: User

Thank you for your answers! It helped me a lot.

Mroczak
#7 已发布: 2018/10/16 09:41:28
Jean Giraud

Jean Giraud

983个赞,共6,866个帖子。

组: User

Wrote

Thank you for your answers! It helped me a lot.



That will help you more.

Solve roots.sm (25.34 KiB)已下载 1321 次。
  • 有新帖
  • 无新帖