Forum Discussion
Trendline
I have always wondered, how do I replace the following formula to get the value of y? Like what is the formula in Excel for this so that if I replace x=23 I get y for example?
Replace each x with the cell address containing the value for y, e.g. A2 then to get the power, replace the numbers with ^ followed by that number. Also, in Excel a formula starts with the equal sign:
=-0.0008*A2^6+0.0605*A2^5+ ......
=-0.0008*A2^6+0.0605*A2^5+ ......
JKPieterse Thank you, yes I have done that but the result is a number completely out of the curve, it does not make any sense.