Description: Excel analysis pak allows multivariate regression and oo has an extension for multivariate regression. It is extremely useful for developing predictive models with more than one input variable and correction factors etc. If this function is in fact available already, I can find no documentation of it. Thank you : ) Actual Results: only one input variable is allowed under data stats regression :( Expected Results: ability to select multiple columns as input variables Reproducible: Always User Profile Reset: No Additional Info: multivariate regression excel analysis pak User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.114 Safari/537.36 Puffin/5.2.0IP
Created attachment 134567 [details] Screenshot Please what is your LibreOffice version?. At least since 5.1 there are two variables allowed. BTW usually OOo extensions works with LibreOffice.
Thank you for your fast response! For my specific use I require more than 2 variable input as I'm sure most multivariable models do! It would be very cool and useful if Libre calc could do more than 2 input variables!
Thank you. You are awesome : )
I tried an oo statistics extension but it didn't seem to work in libre.
enhancement request. status NEW
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.
*** Bug 114811 has been marked as a duplicate of this bug. ***
In comment 6, Regina Henschel tells that we can use The Linest and Logest Function because both accept to use more than to variables in Calc 6.0.0.1. But the result that show after run them aren't clear with labels and it is to hard to start to guess what is what. And there aren't options to Power and Polynomial curves. And it would be useful too, to have all of them in Statistical Menu into Regression Option with Multivariate Regression.
Created attachment 138856 [details] Comment 8: Confuse to know about the meaning of results of Linest and Logest Functions Please see comment 8
Dennis Francis committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=b7a02f2bb66b990289eb7f4dc80069d1545179a4 tdf#109042 : Add support for multivariate regression... It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.