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?
SergeiBaklan no difference at all.
How trendline formula looks after you changed the number of decimals?
SergeiBaklan the numbers have more decimals, but they are decimals, negligent enough to make a change on the final value.
Yes, they are decimals, but decimals which significantly affect calculation result.
- You are quite correct. This also means that you have to be careful in taking the fitted line seriously, small inaccuracies in the fit have huge effect on the outcome of predictions. This asks for careful statistical analysis.
