diff options
| author | Tomaž Vajngerl <tomaz.vajngerl@collabora.com> | 2016-01-24 15:08:05 +0100 |
|---|---|---|
| committer | Miklos Vajna <vmiklos@collabora.co.uk> | 2016-02-02 10:37:29 +0000 |
| commit | be1f577daaa95d83e2442531b9302a089cc3a3d5 (patch) | |
| tree | 2ffbd41a44834bd0ac4f4bf2a23f751fc367b8b3 | |
| parent | 77ef2df2b4a6f074f58b60018df618b5600f3b18 (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.cxx | 6 |
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 |