[Libreoffice-bugs] [Bug 142643] LibreOffice Calc power regression coefficients error

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=142643

--- Comment #4 from Ming Hua <ming.v.hua at qq.com> ---
(In reply to m.a.riosv from comment #2)
> Please can you attach the example file?
I don't think an example file is really needed, as this regression analysis
feature is based on UI, not formulas.

Steps to reproduce:
1. Copy the data given in comment #0 to a sheet.  Copy the data from Bugzilla
page, in Calc choose menu Edit > Paste Special > Paste Unformatted Text, the
Text Import dialog should automatically recognize the data as a ten-row,
two-column range, and if not, adjust the "Separator Options" to use "Separated
by" and "Tab";

2. Select the data range, choose menu Data > Statistics > Regression.  The
first two data boxes, X-range and Y-range, should be preset as A1:A10 and
B1:B10 (or similar, if you pasted to different place on the sheet), select a
cell for the "Results to:" box, A12 for example, then choose "Power Regression"
radio button;

3. Press "OK" button, the regression analysis result should be written to cells
starting at A12.  Find the Intercept and LN(X1) coefficients in cell B38 and
B39, respectively.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210604/4da3a988/attachment.htm>