Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TugboatEng on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by status
-
Excel Trendlines
Ah - Solved my own problem. Thanks for the formulae - top dollar!- status
- Post #14
- Forum: -Engineering spreadsheets
-
Excel Trendlines
Please can someone show me how this formula works. Equation: y = (c3 * x^3) + (c2 * x^2) + (c1 * x^1) + b c3: =INDEX(LINEST(y,x^{1,2,3}),1) c2: =INDEX(LINEST(y,x^{1,2,3}),1,2) C1: =INDEX(LINEST(y,x^{1,2,3}),1,3) b: =INDEX(LINEST(y,x^{1,2,3}),1,4) I've been using the auto generated formula...- status
- Post #13
- Forum: -Engineering spreadsheets
