![]() Nevertheless, see the formulas and coefficients in row 9 and row 10 as a demonstration of the principle. I suggest that either you format the trendline label to show the coefficients with greater precision (Scientific with 14 decimal places, in general Number with 17 decimal places, for your current formulas), or you use LINEST to calculate the coefficients directly in the worksheet.Īctually, when I tried the latter for the AUTOBRAKE1 data (B8:K8), I could not duplicate any "mistake" even with the less precise coefficients. ![]() The mistake would be: using the imprecise coefficients. I see no evidence in your attached Excel file to indicate any error in the trendlines.īut let me guess: you used the displayed precision of the coefficients in formulas, and you found that your calculated data points are not close to the apparent trendline data points in some cases. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |