From f3dbf9cbba6e1d5917de9793a95eced4182777b8 Mon Sep 17 00:00:00 2001 From: Tomaž Vajngerl Date: Sun, 24 Jan 2016 15:08:05 +0100 Subject: tdf#74667 interchange slope and intercept for power regression Change-Id: I9da7edeabcc9f963ac19d26114fa101d4b5ce98f (cherry picked from commit 4d67b0baaa4f0fb009b9ee6fbcf4618abf009f53) Reviewed-on: https://gerrit.libreoffice.org/21743 Tested-by: Jenkins Reviewed-by: Eike Rathke Tested-by: Eike Rathke --- sc/source/ui/StatisticsDialogs/RegressionDialog.cxx | 6 +++--- 1 file 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 -- cgit v1.2.3