diff options
| author | Tomaž Vajngerl <tomaz.vajngerl@collabora.com> | 2016-01-24 15:08:05 +0100 |
|---|---|---|
| committer | Tomaž Vajngerl <tomaz.vajngerl@collabora.com> | 2016-01-24 15:09:25 +0100 |
| commit | 4d67b0baaa4f0fb009b9ee6fbcf4618abf009f53 (patch) | |
| tree | 55eaaa5d2bc453f086484ff7847115bf7efa70fd /sc/source/ui/StatisticsDialogs | |
| parent | 96d6ceac915b8a5a1f5165ff2941c59e4ad3cb8c (diff) | |
tdf#74667 interchange slope and intercept for power regression
Change-Id: I9da7edeabcc9f963ac19d26114fa101d4b5ce98f
Diffstat (limited to 'sc/source/ui/StatisticsDialogs')
| -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 |