LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MartinW
 
Posts: n/a
Default Polynomial equations

y = 1.083333333x4 - 7.3333333x3 + 16.416667x2 - 6.16667x + 4

Above is the polynomial equation of a trend line as shown on my chart,
I have extracted the numbers into separate cells using LINEST, so now
I have in cells A20 to E20 the numbers 1.083333333, -7.333333,
16.416667, -6.16667 and 4 respectively.
With a "y" value of 25 how do I go about solving for a value of "x".

I've been stubbornly struggling with this on and off for a couple of weeks
now and I'm not getting any closer to working it out and the websites
I've found explaining the procedure all seem to go over my head
by the time I get into the fourth or fifth paragraph. Any help would be
greatly appreciated.

Thank you
Martin


 
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
Deriving mathematical equations damo Excel Worksheet Functions 1 April 23rd 06 05:55 PM
how do I use the solver to solve polynomial equations? Cameron PE Excel Worksheet Functions 2 April 20th 06 10:20 PM
Increaseing Precision in polynomial trendline equations KevinW Charts and Charting in Excel 9 January 6th 06 06:41 PM
Polynomial regression - how does Excel do it? (under "Trendline") JH Charts and Charting in Excel 2 January 5th 06 05:07 PM
Working with array equations OkieViking Excel Discussion (Misc queries) 2 January 23rd 05 07:43 AM


All times are GMT +1. The time now is 05:11 AM.

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

About Us

"It's about Microsoft Excel"