Solve 4th Order Polynomial in Excel - F(x) to F(y)

  • Thread starter Thread starter Geo_DW
  • Start date Start date
  • Tags Tags
    Excel
Click For Summary
To solve a fourth order polynomial in Excel, the equation y=F(x) can be rearranged to x=F(y). This transformation leads to the equation F(x)-y=0, which is a fourth degree equation in x. The solutions to this equation will yield four possible values for x, expressed as x=gi(y) for i=1,2,3,4. Excel can be utilized to find these solutions using numerical methods or the Solver tool. Understanding the relationship between x and y is crucial for accurately solving the polynomial.
Geo_DW
Messages
1
Reaction score
0
helo,

just wondering if anyone could tell me how to solve a fourth order polynomial in excel. i have a fourth order polynomial of form y=F(x), but i want it to be x=F(y)
 
Mathematics news on Phys.org
I don't fully understand what you want. However F(x)-y=0 is a fourth degree equation in x, which is solvable. The solutions will be of the form x=gi(y), where i=1,2,3,4.
 
Edit: Failure to read the original post...

--J
 

Similar threads

  • · Replies 11 ·
Replies
11
Views
2K
  • · Replies 6 ·
Replies
6
Views
2K
  • · Replies 3 ·
Replies
3
Views
2K
Replies
3
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 3 ·
Replies
3
Views
1K
  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 3 ·
Replies
3
Views
3K
Replies
1
Views
2K
  • · Replies 2 ·
Replies
2
Views
2K