https://bugs.documentfoundation.org/show_bug.cgi?id=153208
Stéphane Guillou (stragu) <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|Regression Analysis Error |Regression Analysis Error: | |LINEST array #VALUE! errors | |on specific dependent | |variables Blocks| |111310, 108827 Status|UNCONFIRMED |NEW Ever confirmed|0 |1 OS|Windows (All) |All CC| |stephane.guillou@libreoffic | |e.org Version|7.3.2.2 release |Inherited From OOo --- Comment #2 from Stéphane Guillou (stragu) <[email protected]> --- Thank you Luis! I can see the same in: Version: 7.4.4.2 / LibreOffice Community Build ID: 85569322deea74ec9134968a29af2df5663baa21 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded and: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: e125e6623fa1c0f39d927bb37547ca6d1e299cb1 CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded Same thing in: OpenOffice.org 3.3.0 OOO330m20 (Build:9567) Trying to find some logic in it, I think it has to do with having two series with a skewness of 0. Changing any number in X2 or X4 will change the skewness and give results in the LINEST array. MS Excel does *not* have the same issue. Microsoft® Excel® for Microsoft 365 MSO (Version 2212 Build 16.0.15928.20196) 64-bit Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements https://bugs.documentfoundation.org/show_bug.cgi?id=111310 [Bug 111310] [META] Data statistics bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
