Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Deriving mathematical equations | Excel Worksheet Functions | |||
how do I use the solver to solve polynomial equations? | Excel Worksheet Functions | |||
Increaseing Precision in polynomial trendline equations | Charts and Charting in Excel | |||
Polynomial regression - how does Excel do it? (under "Trendline") | Charts and Charting in Excel | |||
Working with array equations | Excel Discussion (Misc queries) |