<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Add Calc extension with multivariate regression (more than 2 variable input)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109042">bug 109042</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>rb.henschel@t-online.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Add Calc extension with multivariate regression (more than 2 variable input)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109042#c6">Comment # 6</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Add Calc extension with multivariate regression (more than 2 variable input)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=109042">bug 109042</a>
from <span class="vcard"><a class="email" href="mailto:rb.henschel@t-online.de" title="Regina Henschel <rb.henschel@t-online.de>"> <span class="fn">Regina Henschel</span></a>
</span></b>
<pre>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
<a href="http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018704_715980110">http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1018704_715980110</a>
or better use the odt-document, where the formulas are better rendered
<a href="http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt">http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.odt</a>.
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.</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>