summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTomaž Vajngerl <tomaz.vajngerl@collabora.com>2014-11-15 15:55:43 +0100
committerTomaž Vajngerl <tomaz.vajngerl@collabora.com>2014-11-15 18:42:47 +0100
commit817b0b51e78b6870379f595a1f370985179847df (patch)
tree25d1f20e21760250ce2a420160abb61c332da519
parenta6db5e6a2a2ac7f92e6d15669693d991c9460998 (diff)
fdo#81801 add first and third quartile to "Descriptive Statistics"
Change-Id: I7bfdb02a97d6a33c0a6e16b058cbb10b8ab2869b
-rw-r--r--sc/source/ui/StatisticsDialogs/DescriptiveStatisticsDialog.cxx2
-rw-r--r--sc/source/ui/StatisticsDialogs/StatisticsDialogs.hrc2
-rw-r--r--sc/source/ui/StatisticsDialogs/StatisticsDialogs.src8
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 */