![]() ![]() ![]() Nor did the other 4 points exactly match the trendline. When I tested the formula (with 2 decimal places) the values didn't match exactly the 3 original values of y. In the case of the second chart the equation had changed from y = 0.68x^2 + 2.05x + 99.75 to y = 0.00x^2 - 0.14x + 10.40. All this with a setting of 2 decimal places. I tried another 4 values of x and all gave y values that appear to match the trendline. ![]() I then used the new equation with the 3 original x values and all got exactly the correct y values. Amazingly, at least to me, while the 3 points for each chart were unchanged, the equations changed radically. Since my last post I have created a new worksheet and recreated the 2 charts and then added trendlines and equations. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |