XL: Incorrect Polynomial Trendline on XY (Scatter) ChartLast reviewed: February 2, 1998Article ID: Q114629 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you add a third-order polynomial trendline to an xy (scatter) chart, and you display the equation, both the trendline and the equation displayed on the chart are incorrect.
CAUSEThis behavior is most noticeable when you are working with an xy (scatter) chart, and the x values that are fairly close together relative to their absolute size (that is, the x range is < 20-percent of the mean x value). The degree to which the polynomial equation is incorrect depends on the chart data, both the absolute size and size of the range. The greater the order of the polynomial that you choose for the trendline, the greater the amount of error in the trendline equation. Also, the greater the chart data values, the lower the order of the polynomial that displays incorrectly. Additionally, the amount of error in the trendline equation is greater when your data sample is smaller than 5 points.
WORKAROUNDUse the following suggestions to avoid this behavior or to at least minimize the error in the trendline equation when you add a polynomial trendline to your xy (scatter) chart:
STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
REFERENCESFor more information about adding a trendline to a data series, choose the Search button in Help and type:
trendlines |
Additional query words: 7.00 5.00 5.00c regression
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |