![]() ![]() Can anyone figure out, what it is? Because I surely can't. I suppose Excel is working as it should, so it must be me doing something wrong. The only answer I have found is, that I should use more decimals, but I have tried to extend the number of decimals to 30, and it doesn't help. I have searched the internet for an explanation, but without succes. So there seems to something fundamentally wrong with the equation. ![]() If I put three of the numbers above into this formula, the results are this:Ĩ0 => 35,048 (real result in table: 13,88)ġ00 => 31,658 (real result in table: 24,53)ġ20 => 24,748 (real result in table: 31,63)Īpart from being very different from the results in the table, the Y-values gets smaller in the Trend formula, while they get bigger in the input table. But when I choose Display equation on chart, it comes up with a Trend formula that has nothing to do with reality. When I enter the following data into Excel and generates af Forecast Analysis with a Polynomial Trendline (Order 2) Excel shows an almost perfect trendline in the diagram. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |