| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Coefficients of trendline
I have data obtained as following:
X: x1 x2 x3 x4 x5 Y: y1 y2 y3 y4 y5 (Five X Y values) From abovementioned data, chart is made and equation of trendline displayed. Question here. I want to get coefficients of that equation of trendline (Using VBA) without displaying it on chart (obtain local maximum values intentionally). For equation of degree of 4 is easy but for degree of 3, 2 I can not obtain by VBA programming It is thankful of you for your comment -- Message posted via http://www.officekb.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display Coefficients of a Polynomial Trendline | Excel Worksheet Functions | |||
| Extracting Trendline Coefficients | Excel Discussion (Misc queries) | |||
| How to get polynome (or other type) coefficients of a trendline? | Excel Discussion (Misc queries) | |||
| How to get polynome (or other type) coefficients of a trendline? | Excel Discussion (Misc queries) | |||
| Trendline coefficients | Charts and Charting in Excel | |||
Threaded Mode
