diff options
| author | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-03-03 19:35:19 -0300 |
|---|---|---|
| committer | Olivier Hallot <olivier.hallot@libreoffice.org> | 2024-03-04 00:25:51 +0100 |
| commit | ef6f345505552524570d22387543bf45ffa4f8f4 (patch) | |
| tree | 9e9ad7a5168f6f2dd2854fbcc3fce6b11bcdd9c6 | |
| parent | 7c608b996929e60592570bf750ea826e11bc3b4a (diff) | |
Add sample file for Calc Data Statistics
Change-Id: Ie417559a6c1c5f65381428a58a84d41dc7a47d1d
Reviewed-on: https://gerrit.libreoffice.org/c/help/+/164319
Tested-by: Jenkins
Reviewed-by: Olivier Hallot <olivier.hallot@libreoffice.org>
83 files changed, 37 insertions, 13 deletions
diff --git a/AllLangPackage_html_media_lang.mk b/AllLangPackage_html_media_lang.mk index a47d2f0059..cbc5c4c08f 100644 --- a/AllLangPackage_html_media_lang.mk +++ b/AllLangPackage_html_media_lang.mk @@ -293,5 +293,6 @@ $(foreach lang,$(filter-out en-US,$(gb_HELP_LANGS)),$(eval $(call gb_AllLangPack files/scalc/$(lang)/functions_ifs.ods \ files/scalc/$(lang)/function_fourier.ods \ files/scalc/$(lang)/conditionalformatting.ods \ + files/scalc/$(lang)/statistics_data.ods \ ))) # vim: set noet sw=4 ts=4: diff --git a/Package_html_media.mk b/Package_html_media.mk index 70575875e2..ed10952193 100644 --- a/Package_html_media.mk +++ b/Package_html_media.mk @@ -21,6 +21,7 @@ $(eval $(call gb_Package_add_files_with_dir,helpcontent2_html_media,$(LIBO_SHARE files/scalc/trigon.ods \ files/scalc/functions_ifs.ods \ files/scalc/conditionalformatting.ods \ + files/scalc/statistics_data.ods \ helpimg/area1.png \ helpimg/area2.png \ helpimg/border_ca_1.png \ diff --git a/source/media/files/scalc/am/statistics_data.ods b/source/media/files/scalc/am/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/am/statistics_data.ods diff --git a/source/media/files/scalc/ar/statistics_data.ods b/source/media/files/scalc/ar/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ar/statistics_data.ods diff --git a/source/media/files/scalc/ast/statistics_data.ods b/source/media/files/scalc/ast/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ast/statistics_data.ods diff --git a/source/media/files/scalc/bg/statistics_data.ods b/source/media/files/scalc/bg/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/bg/statistics_data.ods diff --git a/source/media/files/scalc/bn-IN/statistics_data.ods b/source/media/files/scalc/bn-IN/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/bn-IN/statistics_data.ods diff --git a/source/media/files/scalc/bn/statistics_data.ods b/source/media/files/scalc/bn/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/bn/statistics_data.ods diff --git a/source/media/files/scalc/bo/statistics_data.ods b/source/media/files/scalc/bo/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/bo/statistics_data.ods diff --git a/source/media/files/scalc/bs/statistics_data.ods b/source/media/files/scalc/bs/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/bs/statistics_data.ods diff --git a/source/media/files/scalc/ca-valencia/statistics_data.ods b/source/media/files/scalc/ca-valencia/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ca-valencia/statistics_data.ods diff --git a/source/media/files/scalc/ca/statistics_data.ods b/source/media/files/scalc/ca/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ca/statistics_data.ods diff --git a/source/media/files/scalc/cs/statistics_data.ods b/source/media/files/scalc/cs/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/cs/statistics_data.ods diff --git a/source/media/files/scalc/da/statistics_data.ods b/source/media/files/scalc/da/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/da/statistics_data.ods diff --git a/source/media/files/scalc/de/statistics_data.ods b/source/media/files/scalc/de/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/de/statistics_data.ods diff --git a/source/media/files/scalc/dsb/statistics_data.ods b/source/media/files/scalc/dsb/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/dsb/statistics_data.ods diff --git a/source/media/files/scalc/dz/statistics_data.ods b/source/media/files/scalc/dz/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/dz/statistics_data.ods diff --git a/source/media/files/scalc/el/statistics_data.ods b/source/media/files/scalc/el/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/el/statistics_data.ods diff --git a/source/media/files/scalc/en-GB/statistics_data.ods b/source/media/files/scalc/en-GB/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/en-GB/statistics_data.ods diff --git a/source/media/files/scalc/en-US/statistics_data.ods b/source/media/files/scalc/en-US/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/en-US/statistics_data.ods diff --git a/source/media/files/scalc/en-ZA/statistics_data.ods b/source/media/files/scalc/en-ZA/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/en-ZA/statistics_data.ods diff --git a/source/media/files/scalc/eo/statistics_data.ods b/source/media/files/scalc/eo/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/eo/statistics_data.ods diff --git a/source/media/files/scalc/es/statistics_data.ods b/source/media/files/scalc/es/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/es/statistics_data.ods diff --git a/source/media/files/scalc/et/statistics_data.ods b/source/media/files/scalc/et/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/et/statistics_data.ods diff --git a/source/media/files/scalc/eu/statistics_data.ods b/source/media/files/scalc/eu/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/eu/statistics_data.ods diff --git a/source/media/files/scalc/fi/statistics_data.ods b/source/media/files/scalc/fi/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/fi/statistics_data.ods diff --git a/source/media/files/scalc/fr/statistics_data.ods b/source/media/files/scalc/fr/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/fr/statistics_data.ods diff --git a/source/media/files/scalc/gl/statistics_data.ods b/source/media/files/scalc/gl/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/gl/statistics_data.ods diff --git a/source/media/files/scalc/gu/statistics_data.ods b/source/media/files/scalc/gu/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/gu/statistics_data.ods diff --git a/source/media/files/scalc/he/statistics_data.ods b/source/media/files/scalc/he/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/he/statistics_data.ods diff --git a/source/media/files/scalc/hi/statistics_data.ods b/source/media/files/scalc/hi/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/hi/statistics_data.ods diff --git a/source/media/files/scalc/hr/statistics_data.ods b/source/media/files/scalc/hr/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/hr/statistics_data.ods diff --git a/source/media/files/scalc/hsb/statistics_data.ods b/source/media/files/scalc/hsb/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/hsb/statistics_data.ods diff --git a/source/media/files/scalc/hu/statistics_data.ods b/source/media/files/scalc/hu/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/hu/statistics_data.ods diff --git a/source/media/files/scalc/id/statistics_data.ods b/source/media/files/scalc/id/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/id/statistics_data.ods diff --git a/source/media/files/scalc/is/statistics_data.ods b/source/media/files/scalc/is/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/is/statistics_data.ods diff --git a/source/media/files/scalc/it/statistics_data.ods b/source/media/files/scalc/it/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/it/statistics_data.ods diff --git a/source/media/files/scalc/ja/statistics_data.ods b/source/media/files/scalc/ja/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ja/statistics_data.ods diff --git a/source/media/files/scalc/ka/statistics_data.ods b/source/media/files/scalc/ka/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ka/statistics_data.ods diff --git a/source/media/files/scalc/km/statistics_data.ods b/source/media/files/scalc/km/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/km/statistics_data.ods diff --git a/source/media/files/scalc/ko/statistics_data.ods b/source/media/files/scalc/ko/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ko/statistics_data.ods diff --git a/source/media/files/scalc/lo/statistics_data.ods b/source/media/files/scalc/lo/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/lo/statistics_data.ods diff --git a/source/media/files/scalc/lt/statistics_data.ods b/source/media/files/scalc/lt/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/lt/statistics_data.ods diff --git a/source/media/files/scalc/lv/statistics_data.ods b/source/media/files/scalc/lv/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/lv/statistics_data.ods diff --git a/source/media/files/scalc/mk/statistics_data.ods b/source/media/files/scalc/mk/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/mk/statistics_data.ods diff --git a/source/media/files/scalc/nb/statistics_data.ods b/source/media/files/scalc/nb/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/nb/statistics_data.ods diff --git a/source/media/files/scalc/ne/statistics_data.ods b/source/media/files/scalc/ne/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ne/statistics_data.ods diff --git a/source/media/files/scalc/nl/statistics_data.ods b/source/media/files/scalc/nl/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/nl/statistics_data.ods diff --git a/source/media/files/scalc/nn/statistics_data.ods b/source/media/files/scalc/nn/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/nn/statistics_data.ods diff --git a/source/media/files/scalc/om/statistics_data.ods b/source/media/files/scalc/om/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/om/statistics_data.ods diff --git a/source/media/files/scalc/pl/statistics_data.ods b/source/media/files/scalc/pl/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/pl/statistics_data.ods diff --git a/source/media/files/scalc/pt-BR/statistics_data.ods b/source/media/files/scalc/pt-BR/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/pt-BR/statistics_data.ods diff --git a/source/media/files/scalc/pt/statistics_data.ods b/source/media/files/scalc/pt/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/pt/statistics_data.ods diff --git a/source/media/files/scalc/qtz/statistics_data.ods b/source/media/files/scalc/qtz/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/qtz/statistics_data.ods diff --git a/source/media/files/scalc/ro/statistics_data.ods b/source/media/files/scalc/ro/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ro/statistics_data.ods diff --git a/source/media/files/scalc/ru/statistics_data.ods b/source/media/files/scalc/ru/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ru/statistics_data.ods diff --git a/source/media/files/scalc/si/statistics_data.ods b/source/media/files/scalc/si/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/si/statistics_data.ods diff --git a/source/media/files/scalc/sid/statistics_data.ods b/source/media/files/scalc/sid/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/sid/statistics_data.ods diff --git a/source/media/files/scalc/sk/statistics_data.ods b/source/media/files/scalc/sk/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/sk/statistics_data.ods diff --git a/source/media/files/scalc/sl/statistics_data.ods b/source/media/files/scalc/sl/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/sl/statistics_data.ods diff --git a/source/media/files/scalc/sq/statistics_data.ods b/source/media/files/scalc/sq/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/sq/statistics_data.ods diff --git a/source/media/files/scalc/statistics_data.ods b/source/media/files/scalc/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/statistics_data.ods diff --git a/source/media/files/scalc/sv/statistics_data.ods b/source/media/files/scalc/sv/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/sv/statistics_data.ods diff --git a/source/media/files/scalc/ta/statistics_data.ods b/source/media/files/scalc/ta/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ta/statistics_data.ods diff --git a/source/media/files/scalc/tg/statistics_data.ods b/source/media/files/scalc/tg/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/tg/statistics_data.ods diff --git a/source/media/files/scalc/tr/statistics_data.ods b/source/media/files/scalc/tr/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/tr/statistics_data.ods diff --git a/source/media/files/scalc/ug/statistics_data.ods b/source/media/files/scalc/ug/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/ug/statistics_data.ods diff --git a/source/media/files/scalc/uk/statistics_data.ods b/source/media/files/scalc/uk/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/uk/statistics_data.ods diff --git a/source/media/files/scalc/vi/statistics_data.ods b/source/media/files/scalc/vi/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/vi/statistics_data.ods diff --git a/source/media/files/scalc/zh-CN/statistics_data.ods b/source/media/files/scalc/zh-CN/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/zh-CN/statistics_data.ods diff --git a/source/media/files/scalc/zh-TW/statistics_data.ods b/source/media/files/scalc/zh-TW/statistics_data.ods Binary files differnew file mode 100644 index 0000000000..c115130827 --- /dev/null +++ b/source/media/files/scalc/zh-TW/statistics_data.ods diff --git a/source/text/scalc/01/statistics_anova.xhp b/source/text/scalc/01/statistics_anova.xhp index 02369e8461..f7b100974e 100644 --- a/source/text/scalc/01/statistics_anova.xhp +++ b/source/text/scalc/01/statistics_anova.xhp @@ -44,7 +44,7 @@ <h2 id="hd_id1000080">Parameters</h2> <paragraph id="par_id1001290" role="paragraph"><emph>Alpha</emph>: the level of significance of the test.</paragraph> <paragraph id="par_id1001300" role="paragraph"><emph>Rows per sample</emph>: Define how many rows a sample has.</paragraph> - +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <embed href="text/scalc/01/stat_data.xhp#sampledata01"/> <paragraph id="par_id1001310" role="paragraph">The following table displays the results of the <emph>analysis of variance (ANOVA)</emph> of the sample data above.</paragraph> diff --git a/source/text/scalc/01/statistics_correlation.xhp b/source/text/scalc/01/statistics_correlation.xhp index 51824b9e84..0d4380fa75 100644 --- a/source/text/scalc/01/statistics_correlation.xhp +++ b/source/text/scalc/01/statistics_correlation.xhp @@ -39,6 +39,7 @@ <note id="par_id1001790">For more information on statistical correlation, refer to the <link href="https://en.wikipedia.org/wiki/Correlation">corresponding Wikipedia article</link>.</note> <embed href="text/scalc/01/stat_data.xhp#data"/> <embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <embed href="text/scalc/01/stat_data.xhp#sampledata01"/> <paragraph id="par_id1001800" role="paragraph">The following table displays the results of the correlation of the sample data above.</paragraph> <table id="Tabela6"> diff --git a/source/text/scalc/01/statistics_covariance.xhp b/source/text/scalc/01/statistics_covariance.xhp index 9690994add..c537b98407 100644 --- a/source/text/scalc/01/statistics_covariance.xhp +++ b/source/text/scalc/01/statistics_covariance.xhp @@ -35,7 +35,9 @@ <paragraph id="par_id1001960" role="paragraph">The covariance is a measure of how much two random variables change together.</paragraph> <note id="par_id1001970">For more information on statistical covariance, refer to the <link href="https://en.wikipedia.org/wiki/Covariance">corresponding Wikipedia article</link>.</note> <embed href="text/scalc/01/stat_data.xhp#data"/> -<embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#sampledata01"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> +<embed href="text/scalc/01/stat_data.xhp#sampledata01"/> <paragraph id="par_id1001980" role="paragraph">The following table displays the results of the covariance of the sample data above.</paragraph> <table id="Tabela7"> <tablerow> diff --git a/source/text/scalc/01/statistics_descriptive.xhp b/source/text/scalc/01/statistics_descriptive.xhp index 13476c7188..f8760f6201 100644 --- a/source/text/scalc/01/statistics_descriptive.xhp +++ b/source/text/scalc/01/statistics_descriptive.xhp @@ -36,6 +36,7 @@ <note id="par_id1000670">For more information on descriptive statistics, refer to the <link href="https://en.wikipedia.org/wiki/Descriptive_statistics">corresponding Wikipedia article</link>.</note> <embed href="text/scalc/01/stat_data.xhp#data"/> <embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <embed href="text/scalc/01/stat_data.xhp#sampledata01"/> <paragraph id="par_id1000680" role="paragraph">The following table displays the results of the descriptive statistics of the sample data above.</paragraph> <table id="Tabela4"> diff --git a/source/text/scalc/01/statistics_exposmooth.xhp b/source/text/scalc/01/statistics_exposmooth.xhp index 6815000193..290cfcb7bb 100644 --- a/source/text/scalc/01/statistics_exposmooth.xhp +++ b/source/text/scalc/01/statistics_exposmooth.xhp @@ -32,7 +32,9 @@ <embed href="text/scalc/00/00000412.xhp#stat_expon"/> </section> <paragraph id="par_id1002140" role="paragraph">Exponential smoothing is a filtering technique that when applied to a data set, produces smoothed results. It is employed in many domains such as stock market, economics and in sampled measurements.</paragraph> -<note id="par_id1002150">For more information on exponential smoothing, refer to the <link href="https://en.wikipedia.org/wiki/Exponential_smoothing">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/><embed href="text/scalc/01/stat_data.xhp#grouped"/> +<note id="par_id1002150">For more information on exponential smoothing, refer to the <link href="https://en.wikipedia.org/wiki/Exponential_smoothing">corresponding Wikipedia article</link>.</note><embed href="text/scalc/01/stat_data.xhp#data"/> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <h2 id="hd_id1000120">Parameters</h2> <paragraph id="par_id1002160" role="paragraph"><emph>Smoothing Factor</emph>: A parameter between 0 and 1 that represents the damping factor Alpha in the smoothing equation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> <paragraph id="par_id1002170" role="paragraph">The resulting smoothing is below with smoothing factor as 0.5:</paragraph> diff --git a/source/text/scalc/01/statistics_movingavg.xhp b/source/text/scalc/01/statistics_movingavg.xhp index 81abee2409..d1ed79a7e2 100644 --- a/source/text/scalc/01/statistics_movingavg.xhp +++ b/source/text/scalc/01/statistics_movingavg.xhp @@ -37,6 +37,7 @@ <h2 id="hd_id251681484186482">Trim input range to actual data content</h2> <paragraph role="paragraph" id="par_id141681485134081">Check this box to allow trimming of the input range to the actual data content before computing moving-average. Trimming data ignores unused or empty cells after the last non-empty cell in the input range, thus reducing the computing load of the moving average to the actual data. This checkbox is enabled by default.</paragraph> <embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <h2 id="hd_id1000140">Parameters</h2> <paragraph id="par_id1002530" role="paragraph"><emph>Interval</emph>: The number of samples used in the moving average calculation.</paragraph><embed href="text/scalc/01/stat_data.xhp#timeseries01"/> <h2 id="hd_id1000171">Results of the moving average:</h2> diff --git a/source/text/scalc/01/statistics_sampling.xhp b/source/text/scalc/01/statistics_sampling.xhp index d4bef45c2e..4550c5b828 100644 --- a/source/text/scalc/01/statistics_sampling.xhp +++ b/source/text/scalc/01/statistics_sampling.xhp @@ -46,6 +46,7 @@ <paragraph role="paragraph" id="par_id481623249667345">Picks lines in a pace defined by <emph>Period</emph>.</paragraph> <h3 id="hd_id101623249682605">Period</h3> <paragraph role="paragraph" id="par_id621623249692296">The number of lines to skip periodically when sampling. The <emph>Period</emph> is limited to the population size.</paragraph> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <embed href="text/scalc/01/common_func.xhp#sectionexample"/> <paragraph id="par_id1000110" role="paragraph">The following data will be used as example of source data table for sampling:</paragraph> <table id="Tabela1"> diff --git a/source/text/scalc/01/statistics_test_chisqr.xhp b/source/text/scalc/01/statistics_test_chisqr.xhp index cedfc7d5e2..c587449d0e 100644 --- a/source/text/scalc/01/statistics_test_chisqr.xhp +++ b/source/text/scalc/01/statistics_test_chisqr.xhp @@ -35,6 +35,7 @@ <note id="par_id1004000">For more information on chi-square tests, refer to the <link href="https://en.wikipedia.org/wiki/Chi-square_test">corresponding Wikipedia article</link>.</note> <embed href="text/scalc/01/stat_data.xhp#data"/> <embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> <embed href="text/scalc/01/stat_data.xhp#datafortests"/> <h2 id="hd_id1000231">Results for Chi-square Test:</h2> <table id="tablechisq"> diff --git a/source/text/scalc/01/statistics_test_f.xhp b/source/text/scalc/01/statistics_test_f.xhp index afa8fe602e..2ee4e67e09 100644 --- a/source/text/scalc/01/statistics_test_f.xhp +++ b/source/text/scalc/01/statistics_test_f.xhp @@ -37,7 +37,10 @@ <h2 id="hd_id1000190">Data</h2> <paragraph id="par_id1003280" role="paragraph"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> <paragraph id="par_id1003290" role="paragraph"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1003300" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<paragraph id="par_id1003300" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> +<embed href="text/scalc/01/stat_data.xhp#datafortests"/> <h2 id="hd_id1000200">Results for F-Test:</h2> <paragraph id="par_id1003310" role="paragraph">The following table shows the <emph>F-Test</emph> for the data series above:</paragraph> <table id="Tabela12"> diff --git a/source/text/scalc/01/statistics_test_t.xhp b/source/text/scalc/01/statistics_test_t.xhp index accfb0f4b6..08b3e0d20a 100644 --- a/source/text/scalc/01/statistics_test_t.xhp +++ b/source/text/scalc/01/statistics_test_t.xhp @@ -39,7 +39,10 @@ <h2 id="hd_id1000160">Data</h2> <paragraph id="par_id1002860" role="paragraph"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> <paragraph id="par_id1002870" role="paragraph"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1002880" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<paragraph id="par_id1002880" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> +<embed href="text/scalc/01/stat_data.xhp#datafortests"/> <h2 id="hd_id1000170">Results for paired t-test:</h2> <paragraph id="par_id1002890" role="paragraph">The following table shows the <emph>paired t-test</emph> for the data series above:</paragraph> <table id="Tabela11"> diff --git a/source/text/scalc/01/statistics_test_z.xhp b/source/text/scalc/01/statistics_test_z.xhp index 5f5f86f24e..db7170de98 100644 --- a/source/text/scalc/01/statistics_test_z.xhp +++ b/source/text/scalc/01/statistics_test_z.xhp @@ -46,7 +46,10 @@ <h2 id="hd_id1000220">Data</h2> <paragraph id="par_id1003670" role="paragraph"><emph>Variable 1 range</emph>: The reference of the range of the first data series to analyze.</paragraph> <paragraph id="par_id1003680" role="paragraph"><emph>Variable 2 range</emph>: The reference of the range of the second data series to analyze.</paragraph> -<paragraph id="par_id1003690" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph><embed href="text/scalc/01/stat_data.xhp#grouped"/><embed href="text/scalc/01/stat_data.xhp#datafortests"/> +<paragraph id="par_id1003690" role="paragraph"><emph>Results to</emph>: The reference of the top left cell of the range where the test will be displayed.</paragraph> +<embed href="text/scalc/01/stat_data.xhp#grouped"/> +<embed href="text/scalc/06/calcsamplefiles.xhp#samplestatfile"/> +<embed href="text/scalc/01/stat_data.xhp#datafortests"/> <h2 id="hd_id1000230">Results for z-Test:</h2> <paragraph id="par_id1003700" role="paragraph">The following table shows the <emph>z-Test</emph> for the data series above:</paragraph> <table id="Tabela13"> diff --git a/source/text/scalc/06/calcsamplefiles.xhp b/source/text/scalc/06/calcsamplefiles.xhp index 25bcbe1e9d..fa9a1cc75c 100644 --- a/source/text/scalc/06/calcsamplefiles.xhp +++ b/source/text/scalc/06/calcsamplefiles.xhp @@ -9,28 +9,32 @@ --> <meta> <topic id="textscalc06camplefiles" indexer="exclude" status="PUBLISH"> - <title id="tit" xml-lang="en-US">Calc Sample Files</title> + <title id="tit">Calc Sample Files</title> <filename>/text/scalc/06/calcsamplefiles.xhp</filename> </topic> </meta> <body> <section id="imtrigon"> - <paragraph role="paragraph" id="par_id161521663319917" xml-lang="en-US" localize="false"><object data="media/files/scalc/imtrigon.ods" id="ods_id61521568603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id161521663319917" localize="false"><object data="media/files/scalc/imtrigon.ods" id="ods_id61521568603544" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> <section id="trigon"> - <paragraph role="paragraph" id="par_id161521663319918" xml-lang="en-US" localize="false"><object data="media/files/scalc/trigon.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id161521663319918" localize="false"><object data="media/files/scalc/trigon.ods" id="ods_id61521548603544" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> <section id="pivot"> - <paragraph role="paragraph" id="par_id161521563314918" xml-lang="en-US" localize="false"><object data="media/files/scalc/pivot.ods" id="ods_id61521547603544" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id161521563314918" localize="false"><object data="media/files/scalc/pivot.ods" id="ods_id61521547603544" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> <section id="func_ifs"> - <paragraph role="paragraph" id="par_id721528312694192" xml-lang="en-US" localize="false"><object data="media/files/scalc/functions_ifs.ods" id="ods_id61521547603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id721528312694192" localize="false"><object data="media/files/scalc/functions_ifs.ods" id="ods_id61521547603534" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> <section id="func_fourier"> - <paragraph role="paragraph" id="par_id591561765191143" localize="false"><object data="media/files/scalc/function_fourier.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id591561765191143" localize="false"><object data="media/files/scalc/function_fourier.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> <section id="conditionalformatting"> - <paragraph role="paragraph" id="par_id591563765191143" localize="false"><object data="media/files/scalc/conditionalformatting.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet" /></paragraph> + <paragraph role="paragraph" id="par_id591563765191143" localize="false"><object data="media/files/scalc/conditionalformatting.ods" id="ods_id61521525603534" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> </section> + <section id="samplestatfile"> + <paragraph role="paragraph" id="par_id591573765191143" localize="false"><object data="media/files/scalc/statistics_data.ods" id="ods_id61521325603534" type="application/vnd.oasis.opendocument.spreadsheet"/></paragraph> + </section> + </body> </helpdocument> |