Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
DW
 
Posts: n/a
Default How do you use solver to solve a polynomial

How can you solve a polynomial of the form y=x^4-x^3+x^2+x+5 , i want
something in the form x=F(y).
  #2   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

Solver finds a numeric solution, not a closed form function.

Start by plotting the function. You will see that it is roughly
parabolic, so there are no real solutions if y<4.82505060999037 and two
real solutions if y4.82505060999037.

Now, put the formula =A1^4-A1^3+A1^2+A1+5 in B1 and some x value in A1.
Tools|Solver, "Set Target Cell" to B1, select "Value of:" and put the
desired y value in the entry field, and set "By Changing Cells" to A1.
When you press the "Solve" button, then Solver will find an approximate
numerical solution to the polynomial equation. Which real solution it
finds for y4.82505060999037 will be determined by the initial guess
that you supply in A1.

Jerry

DW wrote:

How can you solve a polynomial of the form y=x^4-x^3+x^2+x+5 , i want
something in the form x=F(y).


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solver and dynamic ranges tim Excel Worksheet Functions 0 May 5th 05 01:29 AM
Solver Problems Walker Excel Worksheet Functions 2 May 2nd 05 07:33 PM
question on excel Solver Avalon Excel Worksheet Functions 1 May 1st 05 05:35 PM
solver constraint jojo Excel Worksheet Functions 0 February 17th 05 10:11 PM
solver can not solve polynomial eq. where one variable is five di. Amitava Excel Worksheet Functions 4 November 3rd 04 12:34 PM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"