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?
12 Replies
Click on Format Trendline (or box with the formula) and in formatting assign 17 decimal places, not 4 as you have now. Try formula again with updated parameters.
SergeiBaklan no difference at all.
How trendline formula looks after you changed the number of decimals?
- 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+ ......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.
