<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body>
<p>
<div>
<b><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#c3">Comment # 3</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 <span class="vcard"><a class="email" href="mailto:pablofabian.wagnerboian@gmail.com" title="Pablo Wagner <pablofabian.wagnerboian@gmail.com>"> <span class="fn">Pablo Wagner</span></a>
</span></b>
<pre>(In reply to Pablo Wagner from <a href="show_bug.cgi?id=117318#c2">comment #2</a>)
<span class="quote">> (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.</span >
The expected value for the variance of the slope should be (J52)^2, not B36^2.
M52^2 is the variance of the 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).
EDITED: Wrong quantity (variance sigma_slope isn't right)</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>