summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorToma┼ż Vajngerl <tomaz.vajngerl@collabora.com>2016-01-24 15:08:05 +0100
committerMiklos Vajna <vmiklos@collabora.co.uk>2016-02-02 10:37:29 +0000
commitbe1f577daaa95d83e2442531b9302a089cc3a3d5 (patch)
tree2ffbd41a44834bd0ac4f4bf2a23f751fc367b8b3
parent77ef2df2b4a6f074f58b60018df618b5600f3b18 (diff)
tdf#74667 interchange slope and intercept for power regression
Change-Id: I9da7edeabcc9f963ac19d26114fa101d4b5ce98f (cherry picked from commit 4d67b0baaa4f0fb009b9ee6fbcf4618abf009f53) Reviewed-on: https://gerrit.libreoffice.org/21744 Reviewed-by: Eike Rathke <erack@redhat.com> Reviewed-by: Christian Lohmaier <lohmaier+LibreOffice@googlemail.com> Tested-by: Eike Rathke <erack@redhat.com> Reviewed-by: Miklos Vajna <vmiklos@collabora.co.uk>
-rw-r--r--sc/source/ui/StatisticsDialogs/RegressionDialog.cxx6
1 files changed, 3 insertions, 3 deletions
diff --git a/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx b/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx
index ad092eeb03d0..84939a8c655e 100644
--- a/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx
+++ b/sc/source/ui/StatisticsDialogs/RegressionDialog.cxx
@@ -53,21 +53,21 @@ namespace
{
"=SLOPE(%VARIABLE2_RANGE% ; %VARIABLE1_RANGE%)",
"=SLOPE(%VARIABLE2_RANGE% ; LN(%VARIABLE1_RANGE%))",
- "=EXP(INTERCEPT(LN(%VARIABLE2_RANGE%) ; LN(%VARIABLE1_RANGE%)))"
+ "=SLOPE(LN(%VARIABLE2_RANGE%) ; LN(%VARIABLE1_RANGE%))"
};
OUString constTemplatesINTERCEPT[] =
{
"=INTERCEPT(%VARIABLE2_RANGE% ; %VARIABLE1_RANGE%)",
"=INTERCEPT(%VARIABLE2_RANGE% ; LN(%VARIABLE1_RANGE%))",
- "=SLOPE(LN(%VARIABLE2_RANGE%) ; LN(%VARIABLE1_RANGE%))"
+ "=EXP(INTERCEPT(LN(%VARIABLE2_RANGE%) ; LN(%VARIABLE1_RANGE%)))"
};
OUString constRegressionFormula[] =
{
"=%A% * %ADDRESS% + %B%",
"=%A% * LN(%ADDRESS%) + %B%",
- "=%A% * %ADDRESS% ^ %B%"
+ "=%B% * %ADDRESS% ^ %A%"
};
} // end anonymous namespace