Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If I make a trendline from a graph Sales $ vs Time months.
y = -4E-10x^6 + 8E-05x^5 - 8.3566x^4 + 442188x^3 - 1E+10x^2 + 2E+14x - 1E+18 After making that ecuation on excel, I should just replace the month to get approx sales volume, but it does not work. The month I enter should be a series? like If I have 6 months on the graph then the next month should be x=7? or shoud I generate a series, i dont remember how this statistics work. JP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Trendline formula | Excel Discussion (Misc queries) | |||
how do i extract the formula from a trendline in Excel? | Charts and Charting in Excel | |||
Can I generate a mX+c Trendline Formula without a graph | Excel Worksheet Functions | |||
change formula for trendline settings | Charts and Charting in Excel | |||
Trendline Formula Problems | Charts and Charting in Excel |