diff options
author | Tomaž Vajngerl <tomaz.vajngerl@collabora.com> | 2014-11-15 15:55:43 +0100 |
---|---|---|
committer | Tomaž Vajngerl <tomaz.vajngerl@collabora.com> | 2014-11-15 18:42:47 +0100 |
commit | 817b0b51e78b6870379f595a1f370985179847df (patch) | |
tree | 25d1f20e21760250ce2a420160abb61c332da519 /sc/source/ui/StatisticsDialogs | |
parent | a6db5e6a2a2ac7f92e6d15669693d991c9460998 (diff) |
fdo#81801 add first and third quartile to "Descriptive Statistics"
Change-Id: I7bfdb02a97d6a33c0a6e16b058cbb10b8ab2869b
Diffstat (limited to 'sc/source/ui/StatisticsDialogs')
3 files changed, 12 insertions, 0 deletions
diff --git a/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx b/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx index 485c04398589..363c84d08afd 100644 --- a/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx +++ b/sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx @@ -42,6 +42,8 @@ static const StatisticCalculation lclCalcDefinitions[] = { STRID_CALC_STD_ERROR, "=SQRT(VAR(%RANGE%)/COUNT(%RANGE%))"}, { STRID_CALC_MODE, "=MODE(%RANGE%)"}, { STRID_CALC_MEDIAN, "=MEDIAN(%RANGE%)"}, + { STRID_CALC_FIRST_QUARTILE, "=QUARTILE(%RANGE%; 1)" }, + { STRID_CALC_THIRD_QUARTILE, "=QUARTILE(%RANGE%; 3)" }, { STRID_CALC_VARIANCE, "=VAR(%RANGE%)"}, { STRID_CALC_STD_DEVIATION, "=STDEV(%RANGE%)"}, { STRID_CALC_KURTOSIS, "=KURT(%RANGE%)"}, diff --git a/sc/source/ui/StatisticsDialogs/StatisticsDialogs.hrc b/sc/source/ui/StatisticsDialogs/StatisticsDialogs.hrc index 3cbed4275dd2..cd2bacefbbc2 100644 --- a/sc/source/ui/StatisticsDialogs/StatisticsDialogs.hrc +++ b/sc/source/ui/StatisticsDialogs/StatisticsDialogs.hrc @@ -46,6 +46,8 @@ #define STRID_CALC_MAX 50 #define STRID_CALC_SUM 51 #define STRID_CALC_COUNT 52 +#define STRID_CALC_FIRST_QUARTILE 53 +#define STRID_CALC_THIRD_QUARTILE 54 #define STR_DESCRIPTIVE_STATISTICS_UNDO_NAME 60 #define STR_ANALYSIS_OF_VARIANCE_UNDO_NAME 61 diff --git a/sc/source/ui/StatisticsDialogs/StatisticsDialogs.src b/sc/source/ui/StatisticsDialogs/StatisticsDialogs.src index b08401935762..4faf2c56277b 100644 --- a/sc/source/ui/StatisticsDialogs/StatisticsDialogs.src +++ b/sc/source/ui/StatisticsDialogs/StatisticsDialogs.src @@ -181,6 +181,14 @@ Resource RID_STATISTICS_DLGS { Text [ en-US ] = "Count"; }; + String STRID_CALC_FIRST_QUARTILE + { + Text [ en-US ] = "First Quartile "; + }; + String STRID_CALC_THIRD_QUARTILE + { + Text [ en-US ] = "Third Quartile"; + }; /* RandomNumberGeneratorDialog */ |