https://bugs.documentfoundation.org/show_bug.cgi?id=142643
--- Comment #4 from Ming Hua <[email protected]> ---
(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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
