LINEST sometimes returns an error or invalid coefficients (typically zero) when chart trendlines work properly. Apparently, there numerical methods for regression are not identical.Ģ. LINEST and chart trendlines do not always produce the same coefficients.
That will ensure that you use values with 15 significant digits of precision, the best that Excel will format.Įven better: use LINEST (or LOGEST) to generate "the coefficients". But I think it is important to note the following.ĭo not use the coefficients constants as they appear by default in the trendline formula.Īny arithmetic based on those rounded values is likely to be off significantly.Īt a minimum, format the "trendline label" to display coefficients in Scientific format with 14 decimal places. I do not have time to help you with the larger problem.
0 kommentar(er)
