[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#514935: openoffice.org-calc: Power regressions are wrong.



Package: openoffice.org-calc
Version: 1:2.4.1-17

Hi,

I was trying to do a power regression in a chart, and the results are completly wrong.

It's a gamma curve, so the formula should be in the form of y = x^gamma, and the result I
have are very close to a gamma curve.  But the regression curve it's showing me
doesn't fit at all, and has a power that's clearly wrong.

Trying to fit it manually, I get a curve in that looks very close.  It's a gamma curve
near 2.3, so I should get something like 1 * x^2.3, but instead I get 0.68 * x^1.61.

If I generate the gamma curve myself, so with very small errors, and let it do
the regression on that, I do get the correct result.


Kurt




Reply to: