need to solve 4th grade equation - help

  • Thread starter Thread starter Bosone
  • Start date Start date
B

Bosone

i need to solve a fourth grade equation like

A+Bx+Cx^2+Dx^3+Ex^4=0

using excel, where A,B,C,D,E are known and stored in excel cells
(both real and imaginary solutions, preferrable!)

how could i do?

thanks!


********************
Visita il mio sito
www.alchemystudio.it
************
 
1) In A1:E1 enter the letters A, B,C,D,E
2) In A2:E2 enter the values for each coefficient
3) In F1 enter the letter x, in F2 enter the number 1
4) Select A1:F2 and use Insert|Name|Create to give the cells A2:F2 the names
from the row above
5) In G2 enter =A*X+B*X^2+C_*X^3+e*x^4 (Note that the cell C2 gets the name
C_ not a simple C)
6) Use Tools|Solver and tell it to make G2 as small as possible (Minimum) by
varying A:E

Of course, with a fourth-order expression there can be up to 4 solutions.
You will get the one closed to 1 (the starting value in F2). Try other
values to find other solutions (or make a graph to find approximate value)

If you cannot see Solver in the Tools menu, read Help to find how to install
it.
Best wishes
 
Back
Top