Apache OpenOffice (AOO) Bugzilla – Issue 120419
strange cubic smoothing algorithm
Last modified: 2013-02-24 21:21:38 UTC
Created attachment 78790 [details] cubic smoothed linechart with inflection point at the wrong place In a case where the points are 1, 5, 4 the highest point of the smoothed curve should be 5. Currently its higher. When creating a cubic smoothed linechart the inflection point of the curve currently may fall before or after the actual datapoint. This is a problem because it creates the illusion that there maybe values larger (or smaller) than the largest (or smallest) datapoint.
That is no error but the property of cubic splines. Your given points have the coordinate (1|1) (2|5) and (3|4). An interpolating polynom for your given points is y = -2.5 * x^2 + 11.5 * x - 8. And that polynom has its maximum at x=2.25 with a maximum value of 5.125