<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Wrong SIGMA SLOPE value calculated with LINEST function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117318#c2">Comment # 2</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Wrong SIGMA SLOPE value calculated with LINEST function" href="https://bugs.documentfoundation.org/show_bug.cgi?id=117318">bug 117318</a> from <a class="email" href="mailto:pablofabian.wagnerboian@gmail.com" title="Pablo Wagner <pablofabian.wagnerboian@gmail.com>"> Pablo Wagner</a> <pre>(In reply to raal from <a href="show_bug.cgi?id=117318#c1">comment #1</a>) > Hello, please could you specify which formulas are wrong a what are expected > values? I compared values from range B35:C39 (only here I see function > linest) with excel and the values are the same. Thank you I've already tried in Excel and it's also wrong. The expected value for the variance of sigma_slope should be (J52)^2, not B36^2. M52^2 is the variance of sigma_slope calculated step by step, assuming the intercept with the Y-axis is zero. As can be seen, the LINEST function is returning the statistic sigma_slope as if the intercept with the Y-axis is zero, which, in this case, isn't zero (close, but not zero). The link in the OP points to the source code where that value is calculated, and apparently it's wrong.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>