Suppose I have a set of X's and Y's(both numneric data) which is dynamic i.e. changes based on certain conditions. Using those two sets of data a scatter plot is prepared with a polynomial trendline of degree 3. I have also called for its equation and now I want to utilise that dynamic equation for my further calculations.
How to use the formula of that trendline in calculations?
From: https://www.ablebits.com/office-addins-blog/2019/01/16/excel-trendline-types-equations-formulas/
By Svetlana Cheusheva
Equation: y = b3x3 + b2x2+ b1x + a
b3: =INDEX(LINEST(y, x^{1,2,3}), 1)
b2: =INDEX(LINEST(y, x^{1,2,3}), 1, 2)
b1: =INDEX(LINEST(y, x^{1,2,3}), 1, 3)
a: =INDEX(LINEST(y, x^{1,2,3}), 1, 4)
One cannot reference the trendline formula on the graph directly, but one can use the formulas above to get the parts needed to use with the regression analysis.
