diff options
| author | Winfried Donkers <winfrieddonkers@libreoffice.org> | 2013-10-04 17:56:04 +0200 |
|---|---|---|
| committer | Eike Rathke <erack@redhat.com> | 2013-10-18 19:04:09 +0000 |
| commit | ccbebd991b6bbce30d10b88f464140338f706c5b (patch) | |
| tree | 5f3215ba22d5630df1345f5cb5692155a8ac6e6e /sc/source/ui/src/scfuncs.src | |
| parent | 82275ecb0c5aae406dcf6637a56a84d729e78ac7 (diff) | |
fdo#70000 add support for COVARIANCE.P and COVARIANCE.S functions
These functions have been introduced with Excel 2010, but were not
supported yet in calc.
COVARIANCE.P (population) replaces the COVAR function, but the COVAR
function remains present (in Excel as well as in calc).
COVARIANCE.S (sample) is a new function.
Change-Id: If5501b4090fb716adfb3d121c7898528fd1b7ad4
Reviewed-on: https://gerrit.libreoffice.org/6135
Reviewed-by: Eike Rathke <erack@redhat.com>
Tested-by: Eike Rathke <erack@redhat.com>
Diffstat (limited to 'sc/source/ui/src/scfuncs.src')
| -rw-r--r-- | sc/source/ui/src/scfuncs.src | 66 |
1 files changed, 65 insertions, 1 deletions
diff --git a/sc/source/ui/src/scfuncs.src b/sc/source/ui/src/scfuncs.src index b054a6d37b43..4d5dd944fea5 100644 --- a/sc/source/ui/src/scfuncs.src +++ b/sc/source/ui/src/scfuncs.src @@ -7515,7 +7515,71 @@ Resource RID_SC_FUNCTION_DESCRIPTIONS2 { String 1 // Description { - Text [ en-US ] = "Calculates the covariance." ; + Text [ en-US ] = "Calculates the population covariance." ; + }; + ExtraData = + { + 0; + ID_FUNCTION_GRP_STATISTIC; + U2S( HID_FUNC_KOVAR ); + 2; 0; 0; + 0; + }; + String 2 // Name of Parameter 1 + { + Text [ en-US ] = "Data_1" ; + }; + String 3 // Description of Parameter 1 + { + Text [ en-US ] = "The first record array." ; + }; + String 4 // Name of Parameter 2 + { + Text [ en-US ] = "Data_2" ; + }; + String 5 // Description of Parameter 2 + { + Text [ en-US ] = "The second record array." ; + }; + }; + // -=*# Resource for function COVARIANCE.P #*=- + Resource SC_OPCODE_COVARIANCE_P + { + String 1 // Description + { + Text [ en-US ] = "Calculates the population covariance." ; + }; + ExtraData = + { + 0; + ID_FUNCTION_GRP_STATISTIC; + U2S( HID_FUNC_KOVAR ); + 2; 0; 0; + 0; + }; + String 2 // Name of Parameter 1 + { + Text [ en-US ] = "Data_1" ; + }; + String 3 // Description of Parameter 1 + { + Text [ en-US ] = "The first record array." ; + }; + String 4 // Name of Parameter 2 + { + Text [ en-US ] = "Data_2" ; + }; + String 5 // Description of Parameter 2 + { + Text [ en-US ] = "The second record array." ; + }; + }; + // -=*# Resource for function COVARIANCE.S #*=- + Resource SC_OPCODE_COVARIANCE_S + { + String 1 // Description + { + Text [ en-US ] = "Calculates the sample covariance." ; }; ExtraData = { |