[Libreoffice-bugs] [Bug 109042] Add Calc extension with multivariate regression ( more than 2 variable input)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Regina Henschel <rb.henschel at t-online.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |rb.henschel at t-online.de

--- Comment #6 from Regina Henschel <rb.henschel at t-online.de> ---
The function LINEST can work with multiple variables. The only constrain is,
that they need to be in adjacent cells.

See the definition of LINEST in
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018704_715980110
or better use the odt-document, where the formulas are better rendered
http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt.

Some parts are cumbersome to read, because the data may be in columns or in
rows, and because LINEST can handles multiple Y-variables too. You might need
to extract your case to get a better readable document.

Only the wizard is limited. Calc has already all tools to calculate such
regressions, but you have to use the functions manually. Therefore this
enhancement request is essentially about extending the wizard.

-- 
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/20170711/9201679c/attachment-0001.html>